web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Setting up test enviro...
Microsoft Dynamics SL (Archived)

Setting up test environment, Company Name configuration error 7006

(0) ShareShare
ReportReport
Posted on by Community Member

Good morning,

We are attempting to create a test environment and have run into some issues.

What we've done:

Cloned the application server (Dynamics SL (2011) and Unanet)

Copied the database(s) and renamed them

Upgraded out Unanet environment

Attempting to log in into SL using our new databases (on same database server)

We did rename the databases

UPDATE COMPANY SET DatabaseName = 'XXXXXX' where DatabaseName = 'YYYYYY'
UPDATE DOMAIN SET DatabaseName = 'XXXXXX' where DatabaseName = 'YYYYYY'

as well as run the database maintenance tool to synchronize

But we are unable to log in due to an error with "Company Name" 

System Message 7006

Company Configuration error: Company XX not properly matched to system Database

Any guidance to what the next step is would be greatly appreciated.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Based on your update queries run I am assuming that you also included a new test system database and ran the queries against that new system database as opposed to adding new companies under the production system database.  If that assumption is correct, did you run the update master views process using the new system database.  There are views that associate the application database with the system database.

  • Community Member Profile Picture
    Community Member on at

    Rick,

    Thanks for the suggestion. Yes, I think.  So I was able to run the scripts against the APP database successfully but not the System Database ( Msg 208, Level 16, State 1, Line 1

    Invalid object name 'Company'.). We did Update Views as well as  Execute Master indexes, Views, and Stored Procedures.  We are still unable to connect SL to the database.

    Same Error: 7006

    Company Configuration Error: Company XX not properly matched to system database XXXXXXX

    We did not change the company name (XX) and I expect it is the same as it was in the original database.

    Full Disclosure, I am not a Database expert.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    There is one view in the application database that, when incorrect, typically causes this message.  Not sure that is your issue but execute the following against the test application database:

    sp_helptext vs_company

    switch to results to text option before executing the above.

    Look at the text of the view and note the system database name after the from statement.  If that is showing the wrong system database name for the test environment then execute the following:

    drop view vs_company

    go

    create view vs_Company as select * from  xxxxxx..Company

    note: replace the xxxxxx with the test system database name.

    Try launching SL again and see if this takes care of your issue.

  • Suggested answer
    Bill Degnan Profile Picture
    Bill Degnan 660 on at

    did you run the update views process in Database maintenance?

  • Community Member Profile Picture
    Community Member on at
    I am not exactly sure what fixed it, or why it is working this way but... We are able to connect to the "test" system database, and when SL opens it is reading/connected to the "test" app database. On the live system we connect directly to the app database, hey but it is working and reading the test data.  We did change the company name to test_XX so that must have done it.
    Thanks,

    Mike

  • Suggested answer
    notrozer Profile Picture
    notrozer 12 on at

    I ran into this myself...  But what I found out is that the Database name In the System Database goes in 2 tables..

    The 'Domain' and 'Company' tables .. When they dont Match I get that error.,

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans