Transactional Replication with Immediate updation DBNETLIB problem.

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

.

Relevant Pages

  • RE: Transactional vs Merge Replication: 2 Publishers and 1 Subscri
    ... added on the publisher is 'unique' in terms of the merge ... you could do is use transactional replication and modify ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: Merge Replication Initial Snapshot
    ... Backup and restore can be used for a nosync initialization, ... shouldn't be changed on the publisher while this takes place so effectively ... In transactional replication there is the option to have ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: Peer to peer replication on SQL 2000?
    ... Bi directional transactional replication only works between 2 nodes. ... closest you can get is merge, but this would require your publisher to be ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: Transactional Replication Strategy Needed!
    ... the publisher, so if the publisher is down, there will be no data ... modifications allowed on the subscriber. ... transactional replication with queued updating subscribers. ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: Single point of failure
    ... Looking for a SQL Server replication book? ... publisher and subscriber to each other and to the other publishers ...
    (microsoft.public.sqlserver.replication)