Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SQL connection error

    Sorry I failed to include the code..

    exec sp_who2

    This is a statement that will return a list of all connections, connection SPID, and the status.  Do you see your users name listed in this list?  What is the status?  

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SQL connection error

    Do they experience any other network related issues at the time of the service interruption?  Also when you get this error can you open SSMS and execute the following SQL statement.  What version of Windows are on the server and the client?  

  • Suggested answer
    Tom Mathew Profile Picture
    Tom Mathew 1,750 on at
    RE: SQL connection error

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

  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 3,134 on at
    RE: SQL connection error

    Does this help?

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

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: SQL connection error

    Is anyone testing firewall settings on the local computers?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SQL connection error

    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.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SQL connection error

    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?

  • MarkM110 Profile Picture
    MarkM110 125 on at
    Re: SQL connection error

    I love intermittent problems!!!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: SQL connection error

    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
    Re: SQL connection error

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

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans