Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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

  • 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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans