August 5, 2010 at 3:30 am
im trying to open replication monitor on my publisher server. i open repl monitor, click on add publisher and enter the DSN for this server ( not the same as the actual server name). i click connect and i get the error:
TITLE: Connect to Server
------------------------------
Cannot connect to DSN.
------------------------------
ADDITIONAL INFORMATION:
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, 'ActualServerName'. (Replication.Utilities)
------------------------------
BUTTONS:
OK
------------------------------
so, i put in the actual serer name, and i get this error:
TITLE: Connect to Server
------------------------------
Cannot connect to ActualServerName.
------------------------------
ADDITIONAL INFORMATION:
Failed to connect to server "ActualServerName. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
I can only connect to the publisher when i connect via repl monitor on the distributor ( different server from publisher)
For the sake of this example the physical server is called "ActualServerName", the Mapped Name is "DSN". when i run @@servername in sql server it returns "ActualServername".
anyone advise what i can do here
August 5, 2010 at 7:34 pm
Are you trying to connect to a named instance?
August 6, 2010 at 3:12 am
no, its the default instance.
August 6, 2010 at 9:02 am
Can you connect via ssms to the publisher (without using the alias)?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply