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

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Created test company and then Copied production data, now no security access

(0) ShareShare
ReportReport
Posted on by

All,

We wanted proiduction data in a test company:

 

1. We successfully created a new company, and were able to login.

2. We copied production data an overwrote the new test company created in Step 1.

3. We ran the script that beginf

if xists (select 1 from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = 'SY00100') begin

4. We set the company access for sa and a couple of other users to be able to use the new company.

5. We can login to the company, but do not appear to have security rights to do anything, even when logged in as sa.

 

*This post is locked for comments

I have the same question (0)
  • Jonathan Fear Profile Picture
    on at
    RE: Created test company and then Copied production data, now no security access

    Well you should always be following the steps in the KB for this process:

    872370 Set up a test company that has a copy of live company data by using Microsoft Dynamics GP on MSDE 2000, SQL Server 2005 Express, or SQL Server 2008 Express

    mbs.microsoft.com/.../KBDisplay.aspx

    As for the issue with copy company I cannot say I have ran into this because I know of other customers that do this and it does work. I would just manually setup security in this or you can try the same process again if you want to get to the bottom of this.

  • Suggested answer
    KirkLivermont Profile Picture
    5,985 on at
    RE: Created test company and then Copied production data, now no security access

    From your live company can you verify that 'sa' is marked as a power user?  Have you verified the SQL security for sa in SSMS?

    Kirk

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
babubaskaran@outlook.com Profile Picture

babubaskaran@outloo... 2

#1
Yng Lih Profile Picture

Yng Lih 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans