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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Database Connection Issue
Microsoft Dynamics GP (Archived)

Database Connection Issue

(0) ShareShare
ReportReport
Posted on by Larry Powell 100

I restored my Microsoft Dynamics Point of Sale 2.0 DB to a SQL Server 2005 from the local database.  Now while I can change the connection in the application just fine meaning the list of databases appear form the server, when I try to login as a cashier account it won't login.

The error I get is "login failed for user . the user is not associated with a trusted sql server connection" which usually means the SQL server security is set to Windows only mode but the server setting is actually set to mixed mode.

 

Any thoughts?

 

Thanks,

 

LP

*This post is locked for comments

I have the same question (0)
  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: Re: Database Connection Issue

    First, all db's MUST have a db_owner.  Changing the db_owner is described in tech notes from the MS-SQL sites but I do not think you need to do this.

    Once you have moved the db, can you sign on as a sys_admin?  If so, you will need to re-establish cashier users.

    You should probably contact your partner at this point for on site assistance.

     

  • Larry Powell Profile Picture
    Larry Powell 100 on at
    Re: Database Connection Issue

    Thanks Richard, 

    I attempted to remove the users it brought over in the restore but dbo and db_owner could not removed or changed.  I was using the POS Manager's Guide to move the DB.  Do you have any documentation that describes the steps top move from the SQL express to SQL Standard Edition?

    Thanks again,

     Larry

  • Larry Powell Profile Picture
    Larry Powell 100 on at
    Re: Re: Database Connection Issue

    Thanks Richard,

    I was using the POS Manager's Guide to move the DB.  I attempted to remove the users it brought over in the restore but dbo and db_owner could not removed or changed.  Do you have any documentation that describes the steps top move from the SQL express to SQL Standard Edition.  Thanks, LP
  • Ron Wilson Profile Picture
    Ron Wilson 6,010 on at
    Re: Re: Database Connection Issue

     Richard,

     Will this work for POS?  That was the application he was asking about (I think???)?

     Ron

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: Database Connection Issue

    GP provides a utility called Grant.sql (found in the SQL folder) which adds rights to tables to appropriate roles.  Also, there are scripts that need to be run under the original sql and then again under the new sql to move logins.  If it is too late to run the pre-move script, you will need to delete the user logins out of the db and re-create security,

     

  • Ron Wilson Profile Picture
    Ron Wilson 6,010 on at
    Re: Re: Re: Database Connection Issue

     I would say that you will get a better response in the POS forums.  Since these forums are completely GP based, it would be kind of a "shot in the dark" as to whether or not anyone here actually used POS. 

    Good luck.

  • Larry Powell Profile Picture
    Larry Powell 100 on at
    Re: Re: Database Connection Issue

    Thanks,

    I posted the issue there as well.

    Larry 

     

  • Ron Wilson Profile Picture
    Ron Wilson 6,010 on at
    Re: Database Connection Issue

     

    Hi Larry, This forum is for Dynamics GP posts you will want to post your question on the Retail Forum found usig the following link. https://community.dynamics.com/forums/t/30710.aspx

    Thank you

    Ron

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

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