April 7, 2003 at 11:08 am
Hi everyone, I am trying to create a linked server from server 1 to 2. There is already a linked server from 2 to 1. I get the error message that the server that I am trying to create already exists. What is wrong? Thanks.
April 7, 2003 at 12:06 pm
execute sp_helpserver to see if the linked server already exists. If it does, you can erase it with sp_droplinkedserver. You need to drop any logins you have set for that linked server with sp_droplinkedsrvlogin. Or just execute sp_DropServer 'Servername', 'droplogins'.
Once erased you can execute sp_addlinkedserver and sp_addlinkedsrvlogin.
You also must execute sp_Serveroption 'Servername',' Data Access', True to allow the linkedserver for access.
April 7, 2003 at 12:13 pm
I ran the sp_helpserver query and the server shows up (even though it doesn't show up in EM). I tried deleting it as you told me and I get this message. Again, in EM, replication doesn't show up. What to do?
Server: Msg 20583, Level 16, State 1, Procedure sp_MSrepl_check_server, Line 30
Cannot drop server 'DPLADS03' because it is used as a Subscriber in replication.
April 7, 2003 at 12:52 pm
Run Client network utility in Server 1 to create server alias to Server 2 first and create linked server in server 1 with the alias to link to server 2. In this setup, you can have two linked servers in server 1 to link to same server 2.
April 7, 2003 at 1:52 pm
If you have replication and that server configured as a subscriber of your replication, you won't be able to drop the linked server and re create it, unless to disable the server as a subscriber. If you don't have replication configured, then I think that you must have some time and deleted but it didn't deleted right. To manually disable the subscriber you will have to run sp_dropsubscriber and then re try what I told before.
April 8, 2003 at 12:01 pm
There must have been some replication done before, and dropped. After I removed the subscriber, I was able to drop the linked server and recreate it. Thanks for your help.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply