Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2003
    Posts
    163

    Red face Unanswered: Unable to register a server - URGENT

    Hi,

    In Enterprise Manager when I try to register a server, I get the following error mesage:


    Login failed for 'sa'. Not associated
    with a trusted SQL server connection


    What does all of this mean? How do I create a "trusted SQL server connection"?

    Kindly assist.

  2. #2
    Join Date
    Aug 2002
    Posts
    17
    i think your server's security settings are set to 'windows only' authentication. try to login with a regular windows account (maybe th one you were logged in whe you installed sql-server).
    and then change this setting on the property pages of the sql-server to 'SQL-Server and Windows'.

    thomas

  3. #3
    Join Date
    Jan 2003
    Location
    India
    Posts
    523

    Re: Unable to register a server - URGENT

    Originally posted by Joozh
    Hi,

    In Enterprise Manager when I try to register a server, I get the following error mesage:


    Login failed for 'sa'. Not associated
    with a trusted SQL server connection


    What does all of this mean? How do I create a "trusted SQL server connection"?

    Kindly assist.
    what is u'r authentication mode?

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    The following is relevant.
    'sa' is a SQL Server login, a member of the SysAdmin fixed server role.
    'sa', by definition, CANNOT login using Windows/Trusted connection.

    One fix would be to change your connection string by providing a password for 'sa'.

    Instead, either use a valid Windows login with the appropriate privileges, or create SQL login to use, and again, add the appropriate password to the connection string.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  5. #5
    Join Date
    Oct 2003
    Posts
    163
    Everyone,

    Many thanks for the help. The problem is history

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •