Error after Dynamics GP 2013 Restore
Posted by Donna Krizik on May 7, 2015
We recently ran into an issue when creating a TEST company in Dynamics GP. When we tried to restore it from LIVE for a client, this error message appeared:
"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"
Luckily, this isn’t something that hasn’t happen before and we were able to do a little digging on the internet and found the solution. Here is what you’ll need to do if this happens to you.
- Check the SY00100 table of the restored company database and verify that the CMPANYID and DBNAME columns are correct.
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.
Big thanks to Microsoft Dynamics Community site for providing solution to this error.