Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

BCP Utility Error logging into GP Utilities as DYNSA

(0) ShareShare
ReportReport
Posted on by

BCP Utility Error logging into GP Utilities as DYNSA, do not receive error when logging in as SA.  This is a new install, the ODBC connection is 32-bit and was created by the installation.  We are running GP Utilities by right click and run as administrator.  Has anyone run into this before?  The client does not want to create new client installs by using SA, they want to use DYNSA.  I believe this is supported???  Any input is much appreciated.

*This post is locked for comments

  • Community Member Profile Picture
    on at
    RE: BCP Utility Error logging into GP Utilities as DYNSA

    This is on GP2015 and I believe the server had to be recreated, by the client, so it is very possible that DYNSA is not the  owner on the databases.  I am checking with the client and will update the post.  Thank you for the response!

  • Suggested answer
    Mahmoud Saadi Profile Picture
    32,738 on at
    RE: BCP Utility Error logging into GP Utilities as DYNSA

    I agree with Vaidy, I've never seen this from a long while as well.

    My quick fix would be to copy the whole GP folder from another existing client which is working with no issues, then go to the GP folder and make sure that the synchronization command is set to false (Syncronize = FALSE) . Then, proceed with deleting the ODBC and re-creating it all over again.

    Let us know how things go with you,

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: BCP Utility Error logging into GP Utilities as DYNSA

    This error is too old. And I haven't seen this in long time.

    However, you may check the DB owner at the backend and set DB owner to DYNSA if it's someone else. This could be one possible reason.

    Also run GP utilities once as "sa" and see if DYNSA is already setup. You may also try changing the password of DYNSA and see if that works.

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans