Unable to register a sql server

  • Greetings,

    One of our baxes hosting SQL Server was just rebuilt and sql server reinstalled. Now I am attempting to register a sql server connecting form this box to another box. I go through the follwoing steps.

    Bring up the Enterprise Manager, roght click on SQL Server Groups and choose New SQL Server registration. The wizard comes up and I add the server I wish to connect to and click next and I see the box asking me to select an authentication mode. I choose Windows authentication the Add the SQL Server to an existing SQL Server group. It then goes to complete the connection and returns the message

    HOSTNAME - Login failed for user '(null)'. Reason: not associated with a trusted SQL Server connection.

    I am sure something on the remote server is configured incorrectly. WHen SQL Server was installed I chose to use either SQL Server or Windows authentication for the connection.

    What should I be looking at to resolve this issue? Thanks.

  • Make sure you have the rights...

    Logon to the server open EM and check your login exists...

     

    MohammedU
    Microsoft SQL Server MVP

  • Agreed with MohammedU

    Please check these links for more info on connection issues

    http://support.microsoft.com/kb/840219/en-us

    http://support.microsoft.com/kb/827422/

     

    Minaz Amin

    "More Green More Oxygen !! Plant a tree today"

  • As you have configured the server for mixed mode, try to login with 'sa' and the check logins and righs.

  • its surely a permission issue. i hope after rebuilding the server u have not added the windows user to the sql server logins. r u getting this error only with windows accounts or also with sql accounts.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • It may NOT be a permission error. Is the new server still in the same domain as the original server? Is the server using the same name as it originally was? Can you PING the new server by it's name? If not, can you PING it by IP Address?

    You could try to see if you can register it by IP address. If so, then its name/IP Address isn't resolving. Make sure it's in the DNS server.

    -SQLBill

  • Thanks all, it was a permissions issue.

Viewing 7 posts - 1 through 6 (of 6 total)

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