Could not connect to 'srvrXYZ' server because 'srvrXYZ' is not defined as a remote server

Question

Could not connect to 'srvrXYZ' server because 'srvrXYZ' is not defined as a remote server

dba.sql29

SSCommitted

Points: 1837
More actions
April 25, 2013 at 8:19 am

#277023

Hi Experts
I am trying to delete my publication from my Publication server and i am getting error. I have already dropped distribution database and none of the jobs are running still I can not drop the Publication. Please help
Screen Short Attached of the problem
Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Calibear Ten Centuries Points: 1377 More actions · Answer 1

dba.sql29 (4/25/2013)
Hi Experts
I am trying to delete my publication from my Publication server and i am getting error. I have already dropped distribution database and none of the jobs are running still I can not drop the Publication. Please help
Screen Short Attached of the problem
Thanks

It looks like the article here should be able to help you:

http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/f1574c57-d753-4a5f-b34f-023505aaa515/

One of the commenters says:

Please execute

The following shows the available options

USE master;

GO

EXEC sp_configure 'show advanced option', '1';

RECONFIGURE;

EXEC sp_configure;

The following enables the Agent XPs

EXEC sp_configure 'Agent XPs', '1';

--------
For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
You can also follow my twitter account to get daily updates: @BLantz2455

Neeraj Dwivedi SSCertifiable Points: 6768 More actions · Answer 2

Duplicate Post..

http://www.sqlservercentral.com/Forums/Topic1446290-291-1.aspx#bm1446716

Hemant.R Ten Centuries Points: 1286 More actions · Answer 3

hi,

as seen in snapshot there is problem with sql server agent ..

plz check using 'sp_configure '

'Agent Xp ' option ... it is enable or not.

if you are deleting your publication ..

1st delete subscriber under publisher..

then publisher...

Connect sql server using servername ,

not connecting then used Client alias..

then delete it..

regards,

HEMANT