SQL SERVER Login error...!
-
--> i want to use SQL SERVER 2000 on windows vista... but it gives me a login error... remember that the sql server is on local system.... i am providing the following connection string from vb.net 2005..... "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=CSM;Data Source=." --> but when i use this on windows XP... it works smoothly.... --> plz solve my problem.... thanx....
J A Nasir K
-
--> i want to use SQL SERVER 2000 on windows vista... but it gives me a login error... remember that the sql server is on local system.... i am providing the following connection string from vb.net 2005..... "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=CSM;Data Source=." --> but when i use this on windows XP... it works smoothly.... --> plz solve my problem.... thanx....
J A Nasir K
Is your SQL Server setup to use Windows Authentication?? Have you setup your account in the SQL Server?? This question really has nothign to do with VB.NET and should be in the General Database forum.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008 -
--> i want to use SQL SERVER 2000 on windows vista... but it gives me a login error... remember that the sql server is on local system.... i am providing the following connection string from vb.net 2005..... "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=CSM;Data Source=." --> but when i use this on windows XP... it works smoothly.... --> plz solve my problem.... thanx....
J A Nasir K
--> are you connecting to an instance? try connecting to:
"Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=CSM;Data Source=.\SQLEXPRESS"
--> did you check the settings? (like, allow remote connections and stuff?) --> it don't make a dif'rence whether it's XP or Vista.
I are troll :)
-
--> i want to use SQL SERVER 2000 on windows vista... but it gives me a login error... remember that the sql server is on local system.... i am providing the following connection string from vb.net 2005..... "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=CSM;Data Source=." --> but when i use this on windows XP... it works smoothly.... --> plz solve my problem.... thanx....
J A Nasir K
You may also want to read some articles on using SQL Server 2000 on Vista. Google results[^] Using 2000 on Vista is not without it's problems...
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008