SQL Server Performance

user sa

Discussion in 'SQL Server 2005 General Developer Questions' started by zaidqais, Jun 17, 2006.

  1. zaidqais New Member

    hi
    when i try to enter the user sa
    using SQL server Authoration
    i cant ... and this is the error message :

    TITLE: Connect to Server
    ------------------------------

    Cannot connect to TOOLSBOXSQLEXPRESS.

    ------------------------------
    ADDITIONAL INFORMATION:

    Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)

    For help, click:http://go.microsoft.com/fwlink?ProdName=Mi...52&LinkId=20476

    ------------------------------
    BUTTONS:

    OK
    ------------------------------
    zaidqais, Jun 17, 2006
    #2

  2. Luis Martin Moderator

    Have you set sql authentication in sql server?

    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



    Luis Martin, Jun 17, 2006
    #2

  3. FrankKalis Moderator

    FrankKalis, Jun 18, 2006
    #2

  4. dineshasanka Moderator

    Looks like you are using sql authentication while the mixed mode authentication is off during installation. You can turn on mixed mode authentication or use intergrated authentication.

    ----------------------------------------
    http://dineshasanka.blogspot.com/
    dineshasanka, Jun 19, 2006
    #2

  5. FrankKalis Moderator

    Looks like someone googled and found that entry in the MSDN forums. [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a>
    FrankKalis, Jun 19, 2006
    #2

  6. satya Moderator

    satya, Jun 19, 2006
    #2

Share This Page