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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Help Security to conne...
Microsoft Dynamics GP (Archived)

Help Security to connect databases with Dynamics GP Users.

(0) ShareShare
ReportReport
Posted on by Gilberto Ojeda 267

Hello,

I am developing a system and I need to use the Microsoft Dynamics GP users that are created in SQL Server, to be able to access the databases of the companies, however it has not been possible since it does not allow it, so I ask, Is it possible to use these users to read and edit information in any of the tables?

I am using this statement "PWDCOMPARE ('clear_text_password'   , password_hash    [, version])" of SQL Server to compare the key and it only works with the user that is native to SQL Server, the users that are created from Dynamics GP do not generate the result to the query that I am doing.

Another question I have is, how does that key coming from Dynamics GP work? Does it come in blank? and that's why he does not let me access.

Thank you.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Nanook Software Profile Picture
    Nanook Software 2 on at

    The short answer is NO.

    The SQL users that Dynamics GP creates uses an encryption key to create the SQL user password. This is by design. This is also the reason that the Dynamics GP SQL password is NOT the same length max as SQL. Dynamics Pre 2018R2 it was 15, now it is 21, where SQL Server is 128.

    BTW the encryption key is tied to the ODBC DNS name - but that is another issue.

    If you are creating your own program, then you can utilize the GPConn.dll / GPConnNet.dll libraries. (Post DynGP v9)

  • Gilberto Ojeda Profile Picture
    Gilberto Ojeda 267 on at

    Thanks a lot

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March 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