Go4Expert (http://www.go4expert.com/)
-   SQL Server (http://www.go4expert.com/forums/sql-server-forum/)
-   -   SQL Server Authentication problem (http://www.go4expert.com/forums/sql-server-authentication-t20013/)

Carlos 6Nov2009 19:55

SQL Server Authentication problem
Hi! i have newly installed MS SQL Server Management studio express. I log in through Windows authentication successfully but when i try to log in through SQL Server authentication mode it gives me error:

Login failed for user 'sa'. The user is not associated with a trusted SQL Connection.

It have even changed 'sa' password, but even it does not work?

Can anyone tell me How to login in through SQL Server Authentication mode???

urstop 19Nov2009 21:32

Re: SQL Server Authentication problem
You will first have to set the SQL Server to use Mixed Authentication mode. Its by default set to Windows Authetication mode and allows only windows users to log in.

Once you set that, then you can login using both windows accounts as well as SQL Server accounts like sa.

All times are GMT +5.5. The time now is 19:23.