Post reply

Linked Server

  • April 1, 2003 at 9:46 am

    #159080

    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

    #452726

    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