Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Could not connect to 'srvrXYZ' server because 'srvrXYZ' is not defined as a remote server Expand / Collapse
Author
Message
Posted Thursday, April 25, 2013 8:19 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 12:17 AM
Points: 53, Visits: 866
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


  Post Attachments 
Replication Error.jpg (11 views, 277.88 KB)
Post #1446528
Posted Thursday, April 25, 2013 6:39 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, August 8, 2013 7:16 PM
Points: 221, Visits: 132
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/
You can also follow my twitter account to get daily updates: @BLantz2455
Post #1446760
Posted Friday, April 26, 2013 4:19 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 8:47 AM
Points: 839, Visits: 1,198
Duplicate Post..

http://www.sqlservercentral.com/Forums/Topic1446290-291-1.aspx#bm1446716
Post #1447193
Posted Saturday, April 27, 2013 5:42 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, March 3, 2014 4:05 AM
Points: 47, Visits: 236
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



Post #1447254
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse