• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 959
  • Last Modified:

SQL Server 2008 cannot delete publisher error 18482

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.
0
DDB
Asked:
DDB
  • 2
  • 2
1 Solution
 
TempDBACommented:
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
0
 
DDBAuthor Commented:
I've requested that this question be deleted for the following reason:

Issue was resolved by myself
0
 
TempDBACommented:
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.
0
 
DDBAuthor 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.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now