April 1, 2003 at 9:46 am
I have tried to setup a linked server between the various SQL Servers. I always get Server Exists as it is defined as a remote server. I can't eliminate the remote server, as it is part of replication.
How can I get around this ?
KlK, MCSE
KlK
April 1, 2003 at 10:59 am
You should be able to eliminate any remote server if it doesn't have any logins specified. You could try removing the logins firts wit hsp_droplinkedsrvlogin or drop the server with sp_dropserver 'servername', 'droplogins'.
But if you don't want to eliminate the servers, you could specify differents logins to existing servers with sp_addlinkedsrvlogin stored procedure.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy