By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,620 Members | 1,303 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,620 IT Pros & Developers. It's quick & easy.

Transactional Replication with Immediate updation DBNETLIB problem.

P: n/a
Hi,

I am trying to set up Transactional replication with immediate
updation.

The configuration is as follows:

1. Publisher is SQL server 2000 Enterprise Edition, and Distributor is
on the same server.
2. Publisher SQL server is installed on Windows 2003.
3. Subscriber is an SQLServer 2000 Evaluation version on Windows
Professional 2000 with sp2.

When I set up the Publisher with transactional replication with
immediate updation only, the set up was successful.
I subscribed 2 instances of SQL server from Windows 2000 professional
on the local LAN in the same domain. The set up went fine.

When I update from the publisher end the updation is successfully
replicating to all the subscribers. But when I try to insert any
records in any one of the subscribers, I am getting the following
error:

[Microsoft] [ODBC SQL Server Driver ][SQL Server
][DBNETLIB][ConnectionOpen(Connect()).] SQL Server does not exists or
access denied.

I am beginner to this replication technology, but I have to set up in
my organisation. Please anybody help me in figuring out the actual
problem and resolving it.
Thanks in advance.

Prashant N M

Mar 10 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.