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???
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.