October 8, 2008 at 1:41 am
Hi,
My computer name is [4A-2F-177-CP3W], there is SQL Server 2005 installed on my machine as a default instance and I am able to connect to the SQL Server instance using the computer name [4A-2F-177-CP3W] upto this it is fine.
When I try to configure the SQL Server replication I am getting the below error 'SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported specify the actual server name, 'SRVR-B0E323'.(Replication.Utilities)'
When I select the select @@servername in sql server it is giving SQL Server instance name [SRVR-B0E323].
When I try to connect to the SQL Server using [SRVR-B0E323], I could not connect it is giving the below error message.
Cannot connect to SRVR-B0E323.
An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.(Provider:Named Pipes Provider, error:40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error:53)
I verified that default settings SQL Server to allow remote connections, it was configured to allow the remote connections.
Could you please help me how to resolve this issue.
Regards
Rajesh Kasturi.
Rajesh Kasturi
October 8, 2008 at 7:36 pm
This usually happens when you put a image of another computer on your machine.
All you need to do is : -
1. sp_dropserver --- drop the srv.... servername
2. sp_addserver -- add the [4... ] servername
Restart the sql service and check the @@servername and sp_helpserver to see that the Srv.... servername is gone 🙂
October 14, 2008 at 12:47 am
Hi Thanks for the reply, You are right, my problem is solved by executing the script proveded by microsoft.
http://support.microsoft.com/kb/818334
Regards
Rajesh Kasturi
Rajesh Kasturi
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply