Creating Replication....

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

As my team wants two servers  to work with.
LVL 14
Jagdish DevakuSr DB ArchitectAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jagdish DevakuSr DB ArchitectAuthor 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...
0
David ToddSenior DBACommented:
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
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Jagdish DevakuSr DB ArchitectAuthor Commented:
those are named instances located in different places....


can anyone help...
0
David ToddSenior DBACommented:
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
0
Jagdish DevakuSr DB ArchitectAuthor 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.

0
David ToddSenior DBACommented:
Hi,

Did you set these to the default port and how?

Cheers
  David
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.