1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

SQL Server Authentication problem

Discussion in 'SQL Server' started by Carlos, Nov 6, 2009.

  1. Carlos

    Carlos New Member

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

    urstop New Member

    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.
     

Share This Page