Groups | Blog | Home
all groups > sql server clients > december 2003 >

sql server clients : Linked Server


Keith Kratochvil
12/29/2003 12:08:27 PM
You need to configure it for data access...
something like this:

exec sp_serveroption '192.168.0.13', 'data access', 'true'

--=20
Keith


[quoted text, click to view]
Noorali Issani
12/29/2003 10:27:39 PM
I have created the linked server.. the query are as follows


EXEC sp_addlinkedserver @server='192.168.0.13',
@srvproduct='sqlserver',
@provider='MSDAORA', @datasrc='dataserver'

EXEC sp_addlinkedsrvlogin '192.168.0.13','false','sa','sa','ngsol'


it gave me following error

Server: Msg 7411, Level 16, State 1, Line 1
Server 'server' is not configured for DATA ACCESS.

what should i do ?

AddThis Social Bookmark Button