Home Forums SQL Server 2008 SQL Server Newbies Could not connect to 'srvrXYZ' server because 'srvrXYZ' is not defined as a remote server RE: Could not connect to 'srvrXYZ' server because 'srvrXYZ' is not defined as a remote server

  • April 25, 2013 at 6:39 pm

    #1610168

    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