Armanino Blog
SQL Connection Error
October 15, 2009

We had an interesting support case last week that seemed worthy of a blog entry.

At one of our more secure clients we were presented with an odd error message thrown by Great Plains that we had never seen before. The text of the message was "An error occurred creating the pass-through SQL connection: 75" and occurred as the client was printing a standard GP Purchasing distribution report.

Dynamics GP An error occurred creating the pass-through SQL connection

The user was for the most part able to transact normally for the day with just an occasional fail with this same error message. After the standard guesses as to what the issue was (ODBC, network timeout, server timeout) we were able to isolate the error and also rationalize why GP mostly worked for the day for this user.

On review of the SQL logs we were able to see about 100 'access denied for expired password' errors for this user on the server which led us to our 'ah ha' moment as to what this meant, and exposed GP a bit on how it just doesn't quite use the SQL security settings as you might think.

Here is what we put together:

  • The client uses the Advanced SQL Server options to enhance password security
    This will expire the password at a date and time set by the security policy of the system
  • When a user logs into GP their login is validated but further interaction with SQL from the client is done through the DYNGROUP permissions as the connection has been established.
  • As the pass through SQL process opens a new connection to the database that connection is then denied as the password has expired. Unfortunately the error message is too cryptic to help resolve the issue.
  • Once the user logged out then back in GP did prompt them to change their password but this was actually the next day as it was not apparent to the user or initially to us what this error actually meant.

We're ready for it now. I'd be interested if others have seen this or similar issues when using the Advanced SQL Server options.

Stay In Touch

Sign up to stay up-to-date with the latest accounting regulations, best practices, industry news and technology insights to run your business.

Related News & Insights
Future Horizons in Finance for SaaS Industry
Do More With Less Using AI, ML & Workflows for Business Success

October 19, 2023 | 10:00 AM - 11:00 AM PT
Leverage Outsourcing and Automation to Optimize Effectiveness and Efficiency
Outsourcing & Automation: Learn How to Get the Best of Both Worlds

October 11, 2023 | 12:00 PM - 01:00 PM PT
Overview of Salesforce Winter 2023 Release for Nonprofits
Salesforce Winter 2023 Release Has Arrived – Stay Informed of the New Features

October 11, 2023 | 10:00 AM - 10:30 AM PT