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

Notifications

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) / SQL connection error
Microsoft Dynamics GP (Archived)

SQL connection error

(0) ShareShare
ReportReport
Posted on by Houry 425

I have 2 Dynamics GP experiencing the same error: "a SQL network connection error occurred and your connections was cleared. This probably occurred because all available connections to the server are in use. Please try again later." They are both on GP2010 and SQL Server 2008R2.  One of the customers has been on GP2010 for about 15 months, and these errors just started randomly occurring a few weeks ago.  The other customer just upgraded from GP10 to GP2010 and moved from a SQL 2005 Express to SQL 2008R2 Standard version.  After they get the error they can log back into GP and continue working, or the error clears up and the connection is reestablished.  The number of connections in SQL server is set to 0 (unlimited).  What could be causing this and how can we resolve it? Thank you.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Wired, I am getting the same from one of my customers and thought that this might be due to network disconnection, but looks it is not.

    I will invistigate more with this and update back my findings.

  • Community Member Profile Picture
    Community Member on at

    Mohammad, did you find anything regarding this error?  We too have 1 user who is having this issue.

  • MarkM110 Profile Picture
    MarkM110 125 on at

    Any luck figuring this one out, I'm experiencing the same issue.

  • Community Member Profile Picture
    Community Member on at

    Nope... Did lot's of digging on this and even went to our gold partner regarding this issue with no resolution.  For us the problem is intermittent enough that it's not a deal breaker so we've just worked around it.

  • MarkM110 Profile Picture
    MarkM110 125 on at

    I love intermittent problems!!!

  • Community Member Profile Picture
    Community Member on at

    I have started to experience this problem with several users after upgrading to GP2013.   All users access GP via Remote Desktop Session.  All servers are WIndows 2008R2 and SQL 2008.  All services are in a VMWare envionment.

    Has anyone found a solution yet?

  • Community Member Profile Picture
    Community Member on at

    Kelly, our problem just seemed to go away.  I can't explain it.  I don't remember anything about what we did that might have addressed the issue.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at

    Is anyone testing firewall settings on the local computers?

  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 933 Super User 2025 Season 2 on at

    Does this help?

    blogs.msdn.com/.../more-on-sql-server-connection-issues-with-microsoft-dynamics-gp.aspx

  • Suggested answer
    Tom Mathew Profile Picture
    Tom Mathew 1,750 on at

    do they have any VBA projects...maka sure to close all ADO connections made to access sql data

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans