sql server replication: Hello.

We're running SQL Server 2000.

I've created a transactional publication with queued updating at server
"DATASERVER1" .

When I attempt to push a subscription I receive an error in the Distribution
Agent, as follows:

Server 'DATASERVER1' is not configured for DATA ACCESS

Can anyone tell me what this means? I cannot find anything on MSDN.

Thank you in advance,

Mike

Can you check the value of sp_configure 'remote access' on the subscriber.
Also, please check select @@servername to ensure the name is the
netbiosname.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Hi, Paul. Thanks for the response.

I ran "sp_configure 'remote access'" and got: minimum=1, maximum=1,
config_value=1, run_value=1.

The name is the NetBios name.

Does it matter that the subscriber and distributor is the same machine?

Thanks again,

Mike

[quoted text, click to view]

Mike,
this is not a problem. Usually it is the other way round - publisher and
distributor on the same box, though - is there a particular reason you are
implementing it this way? As for the message, I'm not sure what the problem
is :). Is there connectivity between the servers? Can you open a QA windon
on the publisher and connect to the subscriber ok? What if you try setting
up a linked server on the subscriber to the publisher as a separate test -
do you get the same error?
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)