January 31, 2007 at 4:48 pm
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.
January 31, 2007 at 7:54 pm
Make sure you have the rights...
Logon to the server open EM and check your login exists...
MohammedU
Microsoft SQL Server MVP
February 1, 2007 at 2:38 am
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"
February 1, 2007 at 4:24 am
As you have configured the server for mixed mode, try to login with 'sa' and the check logins and righs.
February 1, 2007 at 6:02 am
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
February 1, 2007 at 12:17 pm
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
February 1, 2007 at 1:49 pm
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