We help IT Professionals succeed at work.

Creating Replication....

Please someone help me in creating Replication database on another server.

As my team wants two servers  to work with.
Comment
Watch Question

Database Consultant
CERTIFIED EXPERT
Top Expert 2009
Commented:
Jagdish DevakuSr DB Architect

Author

Commented:

I have just created publications by right clicking on Local Publication and selecting New Publication.

Now I am trying to create Subscription by right clicking on the created Publication and selecting New Subscriptions...

In that... while I am giving the Logins details of the Subscription database, its not allowing me to give the IP address, its asking for server name (Subscription database is on remote database).

When I give the remote server name its giving me the following error:

TITLE: Connect to Server
------------------------------

Cannot connect to malamalleb.

------------------------------
ADDITIONAL INFORMATION:

Failed to connect to server malamalleb. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

An error has occurred 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)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------


Please help me regarding this...
David ToddSenior Database Administrator
CERTIFIED EXPERT

Commented:
Hi,

Can the tools on the SQL 2005 server connect to the SQL 2000 server?

That is, can the servers connect to each other? What are their relative locations, and what about any firewall(s) between them? Are these named instances (on random TCP ports) or default instances running on port 1433?

Cheers
  David
Jagdish DevakuSr DB Architect

Author

Commented:
those are named instances located in different places....


can anyone help...
David ToddSenior Database Administrator
CERTIFIED EXPERT

Commented:
Hi,

I wrote:
Are these named instances (on random TCP ports)

You replied:
those are named instances

But you don't seem to have noticed that I mentioned that they will be on a random port - NOT 1433.

You do need to look up the section on named instances in BOL.

Cheers
  David
Jagdish DevakuSr DB Architect

Author

Commented:

They are on the default ports.

I can connect to those servers through management studio and I am able work on the database except on replication. But while connecting them through replication its not getting connected. While I am giving the IP address in the place server name its asking for instance name. But only by giving instance name it will not get connected as it is on different server.

David ToddSenior Database Administrator
CERTIFIED EXPERT

Commented:
Hi,

Did you set these to the default port and how?

Cheers
  David

Explore More ContentExplore courses, solutions, and other research materials related to this topic.