Post reply

SQL login

  • May 5, 2008 at 8:54 pm

    #187220

    Hi, I've got a problem "Login failed for user '(sa)'. Reason: not associated with a trusted SQL Server connection."

    when I tried to login SQL Server in SQL Query Analyzer using SQL Server Authentication.

  • May 5, 2008 at 10:09 pm

    #811005

    Someone has configured SQL Server to accept Windows logins only (not SQL Server logins).

    If you are needing to login using "sa" you will need to change the configuration of SQL Server (this is done using Enterprise Manager). You must connect to SQL with a login that has sysadmin privileges to do this.

  • May 6, 2008 at 11:04 am

    #811344

    Right click server properties and then in security -> check SQL Server and windows and select OK.

    Basically, change server to mixed authentication mode.

    SQL DBA.

  • May 7, 2008 at 9:13 pm

    #812193

    I've got it. Thanks all of you.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply