November 3, 2011 at 1:57 am
Hi All,
I am configuring replication from 1 server to secondary server.
Problem :- i am able to connect 2nd server through IP but i want to connect
through Instance name.
When i connecting Instance through giving error (Error 40 & error 53)
Server name is correct, Share Memory, Named Pipe & TCP/IP are ENABLE.
Let me know where i doing mistake...
Thanks in advance...
Satish saidapur
November 3, 2011 at 2:17 am
if everything is correct, try instance name with port number.
How many instance of sql server on that server?
----------
Ashish
November 3, 2011 at 3:01 am
Hi,
I tried through port, it's not working....
I have only single instance (Default)...
November 3, 2011 at 3:03 am
can you copy/paste your error by masking whatever specific to your environment.
----------
Ashish
November 3, 2011 at 3:34 am
ERROR :-
Cannot connect to MPBABTPJSDB01
ADDITIONAL INFORMATION:-
An error has occured while estalishing a connection to the server. When connecting to SQL Server 2005, this failure be caused by the fact that under the default setting SQL Server does not allow remote connections. (Provider : named Pipes provider, error : 40-could not open a connection to SQL server)(MS SQL Server, error :53)
November 3, 2011 at 3:37 am
if you really getting error then you would be getting "additional information" with your error. Paste it here.
Also the way you connecting. Is it sql authentication or windows authentication?
----------
Ashish
November 3, 2011 at 4:15 am
Is the SQL Browser service started in the 2nd server?
Best regards,
Best regards,
Andre Guerreiro Neto
Database Analyst
http://www.softplan.com.br
MCITPx1/MCTSx2/MCSE/MCSA
November 3, 2011 at 4:15 am
Hi,
I tried both....same error...
November 3, 2011 at 10:36 pm
Hi,
This is resolved....
Problem is Servers are not registered in DNS...
November 4, 2011 at 4:18 am
Thanks for posting the solution.
Others may benefit from this topic in the future.
Best regards,
Best regards,
Andre Guerreiro Neto
Database Analyst
http://www.softplan.com.br
MCITPx1/MCTSx2/MCSE/MCSA
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply