Announcement

Collapse
No announcement yet.

error Publisher Properties

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • error Publisher Properties

    I faced the below error when try to enable transactional replication on database that i restore it from old server to new one( the new server has new name and IP) the database on old server had replication.

    the error:

    TITLE: Publisher Properties
    ------------------------------

    An error occurred while saving publication database.

    Do you want to continue saving other changes?

    For help, click: http://go.microsoft.com/fwlink?ProdN...B&LinkId=20476

    ------------------------------
    ADDITIONAL INFORMATION:

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

    ------------------------------

    Could not find server 'OldServer\instanceName' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
    Changed database context to 'DataBaseName'.
    The statement has been terminated. (Microsoft SQL Server, Error: 7202)

    For help, click: http://go.microsoft.com/fwlink?ProdN...2&LinkId=20476

    ------------------------------
    BUTTONS:

    &Yes
    &No
    ------------------------------

    and after EXEC sp_addlinkedserver @server='OldServer\instanceName'

    the error message become

    TITLE: Publisher Properties
    ------------------------------

    An error occurred while saving publication database.

    Do you want to continue saving other changes?

    For help, click: http://go.microsoft.com/fwlink?ProdN...B&LinkId=20476

    ------------------------------
    ADDITIONAL INFORMATION:

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

    ------------------------------

    Internal Query Processor Error: The query processor could not produce a query plan. For more information, contact Customer Support Services.
    Changed database context to 'DataBase Name'. (Microsoft SQL Server, Error: 8624)

    For help, click: http://go.microsoft.com/fwlink?ProdN...4&LinkId=20476

    ------------------------------
    BUTTONS:

    &Yes
    &No
    ------------------------------

    Please advice to enable replication on restored database and remove old replication setting from restored database
    Last edited by bustanji83; 12th December 2012, 06:39.

  • #2
    Re: error Publisher Properties

    Hey Guys according to that i also obtained the same error when I had the content kind hub url as the intranet sector .I could not discover a way through PowerShell to alter the url so i removed the assistance program and regenerated it using.Thanks!!

    Comment

    Working...
    X