SQL server login error

[LightningStar]

I've never had this problem before but The SQL password isnt to what i set it too... I goto change it by right clicking the main icon(Windows NT) and edit... change pass and press ok. When i try to log in i get the following error.
Connection Failed:
SQL State:'28000'
SQL Server Wrror 18456
[Microsoft][ODBC SQL Server Driver] [SQL Server] Login failed for user 'sa'

If you know whats wrong please let me know asap.

 

[Kaori]

that error is so meaningful, you forgot your sa password.
uninstall/reinstall sql and write down your SA password.

 

[Amenovis]

mhh thats why i wrote in the other post u must have a pass like i show u i had the same prob i ever made a password like winter or sommer or or or but sql havent like it after i saved it i start sql and he told me also odbc cant connect with the same error. so try it like i said before and make sure that ur odbc and all files from MirServer had the right password

 

[Demonic]

http://homepage.ntlworld.com/liquid-ice/guide/sql.html

Make sure you have MIXED MODE as this is why SQL could be failing on ODBC if you failed to select this on install.

 

[LightningStar]

Hi, thanks for the feedback, I did have mixed mode when i installed it, ive installed it on all my friends servers and computers and they have all worked, I dont see the problem with this 1.

 

[Dr3AmScAp3]

Hi, thanks for the feedback, I did have mixed mode when i installed it, ive installed it on all my friends servers and computers and they have all worked, I dont see the problem with this 1.

have you made sure that the password is correct for both SQL and ODBC as thats a login issue with ODBC