SQL Server Performance
  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
    ------------------------------
  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.



  3. FrankKalis Moderator

  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/
  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>
  6. satya Moderator

Share This Page