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" <naissani@lycos.co.uk> wrote in message =
news:%23bgfREjzDHA.2148@TK2MSFTNGP12.phx.gbl...
> I have created the linked server.. the query are as follows
>=20
>=20
> EXEC sp_addlinkedserver @server=3D'192.168.0.13',
> @srvproduct=3D'sqlserver',
> @provider=3D'MSDAORA', =
@datasrc=3D'dataserver'
>=20
> EXEC sp_addlinkedsrvlogin '192.168.0.13','false','sa','sa','ngsol'
>=20
>=20
> it gave me following error
>=20
> Server: Msg 7411, Level 16, State 1, Line 1
> Server 'server' is not configured for DATA ACCESS.
>=20
> what should i do ?
>=20
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 ?