Post reply

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

  • 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

  • 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

  • April 26, 2013 at 4:19 pm

    #1610536

    Duplicate Post..

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

  • April 27, 2013 at 5:42 am

    #1610586

    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

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

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