Open Properties of your linked ServerB, go to Server Options and make sure Data Access, RPC, RPC Out are checked in.
If this is SQL 2005 then you just set these options to True.


Albert Frazer
Database Administrator
Home Decor Products, Inc
[Email address protected]
732-593-3637


-----Original Message-----
From: Dodi Suharto (IT) [mailto:mssqldba-ezmlmshield-x12829342.[Email address protected]
Sent: Wednesday, April 30, 2008 7:11 AM
To: LazyDBA Discussion
Subject: Server 'ServerB' is not configured for DATA ACCESS - Replication Server

Hi all,

Need your help..

I'm trying execute this query from SQLserver 'ServerA'

SELECT Col1, Col2, Col3, Col4
From [ServerB].[WFCDB].dbo.BillingProjection

I got the error message:
Msg 7411, Level 16, State 1, Line 1
Server 'ServerB' is not configured for DATA ACCESS.

I though it's simply by add linkserver, but it's not, because
there is replication between SQLserve 'ServerA' and 'ServerB'
'ServerB' already registered on list of 'Remote Servers' on SQLserver
'ServerA'

Does anyone have similar problem and how to solve it..?
I don't want to drop and recreate replication between the servers.

Some info from BOL and internet couldn't help.. really appreaciate your
help.

SQLConfig
SQL 2000 + SP4

Regards
Dodi





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page