0

hi i get an error saying cannot login to the ms sql server, i did all the things restarted the server, and changed the authentication mode to mixed mode nothing doesen't work,

i created an another login with mixed mode authenitication the same error

saying login falied to user sa Microsoft sql server error 18456

what is the solution for this,
i have been searching for several hours coudn't find it

please if someone can help me
thanx

3
Contributors
3
Replies
4
Views
6 Years
Discussion Span
Last Post by judithSampathwa
0

Bad login or password.
http://msdn.microsoft.com/en-us/library/cc645917.aspx
Are you sure you have the password correct for "sa"? Do you have the caps lock on? Did you accidentally delete the "sa" login? Are you trying to connect as "sa" when you shouldn't be? You aren't providing a lot of information about what you're using to connect...is it an app, a service, a query tool? More detail, please.

0

when you was installed MS-SQL, have u selected mixed mode authentication or not ?..you must be select mixed mode authentication for your solution

0

i got it

after changing to mixed mode

i started restarting ut it didn't do it since i didn't haave the admin rights to do it

solved

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.