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 :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / BCP Utility Error logg...
Microsoft Dynamics GP (Archived)

BCP Utility Error logging into GP Utilities as DYNSA

(0) ShareShare
ReportReport
Posted on by Community Member

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

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member 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.

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 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,

  • Community Member Profile Picture
    Community Member 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!

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans