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?
>
>
Friday, February 17, 2012
Connecting two servers
Labels:
access,
configured,
connecting,
create,
current,
database,
errorserver,
microsoft,
mysql,
oracle,
remote,
server,
servers,
sql,
thereafter,
win2000serv
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment