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




MS Sql Server LazyDBA home page