May 29, 2005 at 1:07 pm
I am trying to register a SQL Server from a remote PC so that I can set up replication with SQL Server on my local PC
I connected from my local PC to a remote PC called callcentre using VPN with the Windows firewall off. On my local PC I ran the command
net view \\callcentre
I got the response
Shared resources at \\callcentre
external call centre
Share name Type
Callcentre SQL Server Disc
In the Action menu of Enterprise Manager I ran New SQL Server Registration. I pressed the button beside the Server box and selected the Callcentre server. I selected Windows Authentication and pressed OK. The error was
"SQL Server Registration failed because of the following connection failure
Logon failed for user Callcentre\Guest"
I got the same error if I tried to use SQL Server authentication.
Can anyone suggest what I am doing wrong?
May 31, 2005 at 1:38 am
May 31, 2005 at 9:21 am
Or use a standard SQL login. The login failed message means you connected to the server, but were not authenticated. If the server port was not reachable, you could have gotten the "server does not exist" message.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply