**linked server**

Hi
I'm working with MS sql server 2000 and I want to add a linked server. but
there is an empty "provider name" combo box, with following message at the
bottom "Provider Name is one of the providers installed on the server"
what programs should I install in order to get a complete names of
providers and be able to continue?
(I have no problem on my personal client(WinXP) in our LAN, but this is a
problem in our server.)
my second question:
Is it possible to have a remote server throught VPN by a linked server?
(now I have the remote SQL server through a new SQL server registration
but I want to have it in a linked server in order to easily join its table
with my local network tables and ...)
Any help would be greatly appreciated.
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/1) Do you try to create a linked server to another SQL Server? Check SQL
Server under Server Type option
2) I think it is permission issue, I have never tried it. Have you tried to
create a linked server?
"M" <rez1824@.yahoo.co.uk> wrote in message
news:op.tk5uxesen9ig5y@.system109.parskhazar.net...
> Hi
> I'm working with MS sql server 2000 and I want to add a linked server. but
> there is an empty "provider name" combo box, with following message at the
> bottom "Provider Name is one of the providers installed on the server"
> what programs should I install in order to get a complete names of
> providers and be able to continue?
> (I have no problem on my personal client(WinXP) in our LAN, but this is a
> problem in our server.)
>
> my second question:
> Is it possible to have a remote server throught VPN by a linked server?
> (now I have the remote SQL server through a new SQL server registration
> but I want to have it in a linked server in order to easily join its table
> with my local network tables and ...)
> Any help would be greatly appreciated.
> --
> Using Opera's revolutionary e-mail client: http://www.opera.com/mail/|||Hi
Try adding the linked server through T-SQL using something like:
EXEC sp_addlinkedserver @.server='RemoteSQLServer', @.srvproduct='',
@.provider='SQLOLEDB',
@.datasrc='RemoteSvr\SQLInstance'
If you can register the remote server you should be ok to define it as a
linked server. Response over the VPN may be quite slow.
John
"M" wrote:
> Hi
> I'm working with MS sql server 2000 and I want to add a linked server. but
> there is an empty "provider name" combo box, with following message at the
> bottom "Provider Name is one of the providers installed on the server"
> what programs should I install in order to get a complete names of
> providers and be able to continue?
> (I have no problem on my personal client(WinXP) in our LAN, but this is a
> problem in our server.)
>
> my second question:
> Is it possible to have a remote server throught VPN by a linked server?
> (now I have the remote SQL server through a new SQL server registration
> but I want to have it in a linked server in order to easily join its table
> with my local network tables and ...)
> Any help would be greatly appreciated.
> --
> Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
>