Sample Company Data restore error in GP 2013

(0) Share

Report

Posted on by Mdmahbubur Bhuiyan

485

In GP 2013, I have creaded a sample company with DB name TWO1 and then created another company, Sample Company 2 with DB name TWO2. In order to have some data in Sample Company 2, I have restored TWO1 over TWO2. Now I get following error in logon window:

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

I appreciate your help.

Thanks.

Mahbubur Bhuiyan

*This post is locked for comments

I have the same question (0)

All responses (22)

Answers (3)

Suggested answer

Community Member on at

Like (0)

Report

Starting from GP 2013, database name for TWO and DYNAMICS databases became customizable, therefore looks like folks at Microsoft has added the database name inside the company database to be able to identify where they are connected and your case will show up, logically both databases are sample companies while infact one is not, thats why you are getting this message.

Was this reply helpful? Yes No
Mdmahbubur Bhuiyan 485 on at

Like (0)

Report

Thanks for your reply Mohammad. If I don't restore restore TWO1 over TWO2, then both companies are accessible. Is there any solution to it? Thanks.

Was this reply helpful? Yes No
Jonathan Fear on at

Like (0)

Report

Please note that GP 2013 is not available for customers at this point. Also there is no official support for GP 2013 yet. The reason you are running into these type of errors is due to the ability to name your system database. If you continue to have issues please post in Partner forums.

Thanks,

Was this reply helpful? Yes No
Mdmahbubur Bhuiyan 485 on at

Like (0)

Report

Thanks

Was this reply helpful? Yes No
Verified answer

Kelly Powers 50 on at

Like (0)

Report

Hi

After a restore update the SY00100 table in the company database with the correct CMPANYID from the DYNAMICS ( or whatever name you gave it ) SY01500 table. I am still testing but this let me login to the company without error.

Was this reply helpful? Yes No
Verified answer

Mdmahbubur Bhuiyan 485 on at

Like (0)

Report

Thank you for your response. I am able to login to the company after updating SY00100 table.

Was this reply helpful? Yes No
Janeece Moreland 270 on at

Like (0)

Report

I have reviewed this table and it is correct. It has the SY01500 companyid and the Interid. I still cannot login to this company.

Any suggestion would be helpful.

Was this reply helpful? Yes No
Janeece Moreland 270 on at

Like (0)

Report

Can you please have someone at Microsoft post an updated article for GP2012 and GP 2013 in response to this error?

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.

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Hi Janeece,

I just noticed you mentioned have checked the SY00100 table and it had the SY01500 table companyid and the Interid. What confuses me is that the SY00100 does not contain the Interid. Is it possible that you might have selected a different table than the SY00100?

Kind regards,

Leslie

Was this reply helpful? Yes No
Verified answer

AndreaIES 1,005 on at

Like (1)

Report

I just went through this issue and the way I fixed was to update the SY00100 table on the company database and set the DBNAME = 'DYNAMICS' or whatever the name is (in case it was changed).

Was this reply helpful? Yes No