Error after GP 2013 Restore - "The selected company is not configured as a company of the current Microsoft Dynamics GP system database. You must resolve the database configuration to log in..."

Dynamics GP
Written By Hanna Madkour

If you are refreshing your GP 2013 test company database from a production company, after running the restore and the SQL refresh script, you may get the following message when attempting to log in to the restored company:

"The selected company is not configured as a company of the current Microsoft Dynamics GP system database. You must resolve the database configuration to log in to the company"

Check the SY00100 table of the restored company database and verify that the CMPANYID and DBNAME columns are correct. In our case the DBNAME column was set to the test company database name instead of our system database name (DYNAMICS). We've also seen issues where the CMPANYID needs to be updated to the match the CMPANYID in the SY01500 table of the system database.

To view the data from these tables, use the following SQL queries:

  • Select * from <System Database>..SY01500

  • Select * from <Company Database>..SY00100

  • Where <System Database> = DYNAMICS or whatever you set as the system database during installation and
    <Company Database> is the database name for the company causing the error.

Thanks to Microsoft Dynamics Community site for providing the answer.

See the post here:

http://community.dynamics.com/product/gp/f/32/p/91083/182784.aspx

Hanna Madkour
Previous

Project Accounting Information for this vendor does not exist. Do you want to add the vendor's project information?
Next

Using Inquiries in Dynamics GP