Connectivity problem

Question

Post reply

Connectivity problem

saidapurs

Hall of Fame

Points: 3477
More actions
November 3, 2011 at 1:57 am

#247278

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

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

crazy4sql SSCoach Points: 19590 More actions · Answer 1

crazy4sql

SSCoach

Points: 19590

November 3, 2011 at 2:17 am

#1402515

if everything is correct, try instance name with port number.

How many instance of sql server on that server?

----------
Ashish

saidapurs Hall of Fame Points: 3477 More actions · Answer 2

saidapurs

Hall of Fame

Points: 3477

November 3, 2011 at 3:01 am

#1402529

Hi,

I tried through port, it's not working....

I have only single instance (Default)...

crazy4sql SSCoach Points: 19590 More actions · Answer 3

crazy4sql

SSCoach

Points: 19590

November 3, 2011 at 3:03 am

#1402530

can you copy/paste your error by masking whatever specific to your environment.

----------
Ashish

saidapurs Hall of Fame Points: 3477 More actions · Answer 4

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)