Friday, February 17, 2012

Connecting two servers

Hello there
After i create remote server on my current server i got an error:
Server 'Win2000Serv' is not configured for DATA ACCESS.
what can i do to solve it?Roy
exec sp_serveroption 'Win2000Serv' ,'data access','true'
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:%23RfL8da9FHA.220@.TK2MSFTNGP14.phx.gbl...
> Hello there
> After i create remote server on my current server i got an error:
> Server 'Win2000Serv' is not configured for DATA ACCESS.
> what can i do to solve it?
>|||Hi,
sp_addlinkedserver
and
sp_addlinkedsrvlogin
:-)
Regards
--
Andy Davis
Activecrypt Team
---
SQL Server Encryption Software
http://www.activecrypt.com
"Roy Goldhammer" wrote:

> Hello there
> After i create remote server on my current server i got an error:
> Server 'Win2000Serv' is not configured for DATA ACCESS.
> what can i do to solve it?
>
>

No comments:

Post a Comment