servers Error Microsoft SQL Server, Error: 7411

1. Replication Transactional between two servers

-- SQL Server 2005 as Distributors and Subscribers

SQL Server 2000 as Publishers

2. Linked Servers errors:

" Server (Publication Server) is not configured for DATA ACCESS. (Microsoft SQL Server, Error: 7411)"

Did anyone familiar with this problem?

Thankssss

TJ_1

Could you provide more details? Do you use UI or T-SQL to create replication? And at which step do you see the problem?

Peng

|||

I configured in UI Microsoft SQL Server Management Studio and Enterprise Manager.

1. The initial snapshoot copy the publications database completed with no errors.

2. The Log Reader Agent is running in SQL Server 2005

3. There are two Linked Servers:

LinkA is working.

Link B is not working and prompt error of "Link Servers Error Microsoft SQL Server, Error: 7411 when I right click and

select test connection.

4. Pretty sure the Transactional replication was setup using Link B.

Thank you.

TJ_1

|||

My Server 2005 'repl_distributor is not configured for DATA ACCESS.

I run the a script of

use master

exec sp_serveroption 'server name', 'data access', 'true'

go

Go back to relp_distributor and test the connection. Still got the same error.

|||

Sorry, I am still confused.

Do you mean this message is not thrown when you configure replication or call some replication stored procs? Instead, you just use repl_distributor to do RPC access? repl_distributor is a special remote server that is created by replication and it is not enabled for data access.

Peng