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 at one of these links:
Tired of maintaining that old Dynamics GP server?
See how migrating Dynamics GP to the cloud can help your organization reduce IT costs, improve security, and boost employee productivity.