SQL Server Authentication problem

Carlos's Avatar, Join Date: Dec 2008
Contributor
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???
0
urstop's Avatar, Join Date: Oct 2007
Contributor
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.