Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Oct 26, 2012 01:15 PM by kaushikmaheta
Member
66 Points
24 Posts
Oct 26, 2012 01:02 PM|LINK
Hi,
when i connect to sql server data base i got the error like"login failed user "sa" in sql server .I have tried to connet with sql server defualt creadetial
thanks,
All-Star
66017 Points
7639 Posts
Moderator
Oct 26, 2012 01:04 PM|LINK
have you tried setting the user/pass in the connection string?
98023 Points
14516 Posts
Oct 26, 2012 01:06 PM|LINK
probably locking issue - http://blog.sqlauthority.com/2009/04/23/sql-server-fix-error-18486-login-failed-for-user-sa-because-the-account-is-currently-locked-out-the-system-administrator-can-unlock-it-unlock-sa-login/
or else check this - http://forums.asp.net/t/1801115.aspx/1
Thanks,
Oct 26, 2012 01:07 PM|LINK
i have tried with user name "sa" and password empty
Contributor
2280 Points
659 Posts
Oct 26, 2012 01:09 PM|LINK
we will connect to data base creating new user .
http://csharpektroncmssql.blogspot.com/2012/07/login-failed-for-user-sa-in-sql-server.html
3773 Points
896 Posts
Oct 26, 2012 01:15 PM|LINK
your sql server database is server authonticate than give username="sa" and password="sa" and integrated security=false
otherwise
integrated security=true no set username and password
devsolutions
Member
66 Points
24 Posts
Cannot open user database. Login failed
Oct 26, 2012 01:02 PM|LINK
Hi,
when i connect to sql server data base i got the error like"login failed user "sa" in sql server .I have tried to connet with sql server defualt creadetial
thanks,
Curt_C
All-Star
66017 Points
7639 Posts
Moderator
Re: Cannot open user database. Login failed
Oct 26, 2012 01:04 PM|LINK
have you tried setting the user/pass in the connection string?
v5.1 of iTracker (Inventory Tracker Starter Kit) is out, Download it now!
ramiramilu
All-Star
98023 Points
14516 Posts
Re: Cannot open user database. Login failed
Oct 26, 2012 01:06 PM|LINK
probably locking issue - http://blog.sqlauthority.com/2009/04/23/sql-server-fix-error-18486-login-failed-for-user-sa-because-the-account-is-currently-locked-out-the-system-administrator-can-unlock-it-unlock-sa-login/
or else check this - http://forums.asp.net/t/1801115.aspx/1
Thanks,
JumpStart
devsolutions
Member
66 Points
24 Posts
Re: Cannot open user database. Login failed
Oct 26, 2012 01:07 PM|LINK
i have tried with user name "sa" and password empty
bhaskar.mule
Contributor
2280 Points
659 Posts
Re: Cannot open user database. Login failed
Oct 26, 2012 01:09 PM|LINK
Hi,
we will connect to data base creating new user .
http://csharpektroncmssql.blogspot.com/2012/07/login-failed-for-user-sa-in-sql-server.html
Site:Rare technical solutions
kaushikmahet...
Contributor
3773 Points
896 Posts
Re: Cannot open user database. Login failed
Oct 26, 2012 01:15 PM|LINK
your sql server database is server authonticate than give username="sa" and password="sa" and integrated security=false
otherwise
integrated security=true no set username and password
Remember to click Mark as Answer on the post that helps to others.