7.4 Register a Moved DB

SUGGESTED

We moved our database from SQL-02 to SQL-03 server name. I am unable to register the application to use it's modules. I've ran the Database Synchronization Utility be get the following error:

I also tried to manually register but receive this error:

Can someone help with this please?

Parents
  • 0
    SUGGESTED

    What version of Sage 500 are you using?  Sage has an article in their knowledgebase with this occurring for version 7.4.  

    Here is what the knowledgebase says about this issue and how to resolve.  It may help.

    Cause

    In this specific case, trying to register 7.40 version of Sage 500 ERP on SQL Server verson 2012 in preparation for upgrade to version 7.60. Found that issue related to syntax changes in update trigger for tsmsiteprofile.

    In another instance of this error, it was a compatibility issue while trying to run the DB SYNC and registering while using a Sage 500 v7.40 database on a SQL Server v2012, which is not a supported configuration.

    Resolution

    Replace the 7.40 version of the tsmsiteprofile update trigger with the 7.60 version of the trigger

    Also, instead of running the DBSYNC utility on a SQL 2012 server, this process should be run on a SQL 2008 version.

Reply
  • 0
    SUGGESTED

    What version of Sage 500 are you using?  Sage has an article in their knowledgebase with this occurring for version 7.4.  

    Here is what the knowledgebase says about this issue and how to resolve.  It may help.

    Cause

    In this specific case, trying to register 7.40 version of Sage 500 ERP on SQL Server verson 2012 in preparation for upgrade to version 7.60. Found that issue related to syntax changes in update trigger for tsmsiteprofile.

    In another instance of this error, it was a compatibility issue while trying to run the DB SYNC and registering while using a Sage 500 v7.40 database on a SQL Server v2012, which is not a supported configuration.

    Resolution

    Replace the 7.40 version of the tsmsiteprofile update trigger with the 7.60 version of the trigger

    Also, instead of running the DBSYNC utility on a SQL 2012 server, this process should be run on a SQL 2008 version.

Children