1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

SQL Server Authentication problem

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

  1. Carlos

    Carlos New Member

    Joined:
    Dec 5, 2008
    Messages:
    57
    Likes Received:
    0
    Trophy Points:
    0
    Occupation:
    none
    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

    Joined:
    Oct 17, 2007
    Messages:
    84
    Likes Received:
    0
    Trophy Points:
    0
    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