Notifications
Announcements
No record found.
Attempting to create a TEST environment by cloning the Production VM, everything appears to go smooth but I'm unable to login to the SA account. I've run the Capture_Logins.sql script as well as tried resetting the SA password from within SQL Security. Still getting the following error when launching GP utilities however I am able to use SA login for SQL authentication
Go into SSMS and Security->Logins and 'sa' and right-click properties. Make sure the 'sa' login is not disabled.
It is/was enabled
Are you on the server trying to login? If not, make sure this is not a firewall issue. The default port for SQL is 1433.
I am directly on the database server
So you can log into SSMS as 'sa' but not GP? I would check the ODBC connection using the 32 bit ODBC Administrator. Perhaps even create a new one.
community.dynamics.com/.../how-to-create-an-odbc-for-microsoft-dynamics-gp-2010
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 660 Most Valuable Professional
André Arnaud de Cal... 549 Super User 2025 Season 2
Sohaib Cheema 307 User Group Leader
