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..."

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 ..SY01500
• Select * from ..SY00100
• Where = DYNAMICS or whatever you set as the system database during installation and
  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