We help IT Professionals succeed at work.

SQL Server 2008 cannot delete publisher error 18482

DDB
DDB asked
on
I tried to delete publisher and got error:
Cannot delete publication xxx. Cannot connect to server'Distibution server name' becase 'Publisher server name' is not defined as a remote server. error 18482.

I checked and my publisher server defined as remote server and distibution server, subscriber server also in sysserver table defined as remote servers.

appreciate your help in advance.
Comment
Watch Question

Commented:
Try running following in master server
select @@servername

If this gives NULL it means something is wrong with the metadata. So, make it fine using:-

Use Master
go
exec Sp_DropServer '<publisherServerName>'
go
Use Master
go
exec Sp_Addserver '<publisherServerName>', 'local'
go
DDB

Author

Commented:
I've requested that this question be deleted for the following reason:

Issue was resolved by myself

Commented:
What was the solution? Can you please share with us? It would be helpful to assist others. And also request for closing the question rather than deletion.
DDB

Author

Commented:
I've requested that this question be deleted for the following reason:

I don't remember what I was done to resolve this issue., but problem was solved by me.