7 Replies Latest reply on Apr 10, 2017 9:42 AM by jburke

SQL connectivity losts and restores after Rebooting server.

aqeel73 Jul 9, 2016 10:17 AM

Hi Everyone, I am facing a problem with SQL and Solarwinds server connectivity. While every thing is working fine, Suddenly SQL server disconnects with error

"Service was unable to open new database connection when requested.

Exception A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)....." . After Rebooting NPM Servers, everything starts to work again . I have checked, DB is available during this error to other servers so there is no problem in DB server or its connectivity. Both Machines are on Same Subnet. Hosts firewalls are disabled...

AK,.

Re: SQL connectivity losts and restores after Rebooting server.

neomatrix1217 Jul 10, 2016 7:32 PM (in response to aqeel73)

Add the following to the max pool size and see if it corrects the issue. Unable to open new database connection - SolarWinds Worldwide, LLC. Help and Support
Like (1)

Actions
Re: SQL connectivity losts and restores after Rebooting server.

crzyr3d Aug 3, 2016 1:49 AM (in response to aqeel73)

Having the same issue. Will try this but if it doesn't work I'm putting in a ticket. I'm tired of being called around 2 am almost EVERY SINGLE NIGHT. It's almost like clockwork. Driving me crazy.
Like (0)

Actions
Re: SQL connectivity losts and restores after Rebooting server.

zeppyy Oct 17, 2016 10:50 AM (in response to aqeel73)

I'm also having the same issue. Although every week or 2 weeks our solarwinds will get this same SQL error. Only fixed I've found is to restart the solarwinds server.
I added the Max Pool=1000 to the db file. I'll update and see if anything changes. Thanks.
Like (0)

Actions
Re: SQL connectivity losts and restores after Rebooting server.

jburke Feb 1, 2017 3:10 PM (in response to aqeel73)

Were there any updates to this? We are seeing something similar.
Thanks
Like (0)

Actions
Re: SQL connectivity losts and restores after Rebooting server.

f.k.lucas Apr 10, 2017 9:38 AM (in response to aqeel73)

I'm having the same issue - I have a ticket open and have carried out multiple suggestions but I typically lose connection in the evening every few days.

I checked the article in neomatrix1217's post and my swnetperfmon.db is already configured as described in the article.
Like (0)

Actions
- Re: SQL connectivity losts and restores after Rebooting server.
  
  jburke Apr 10, 2017 9:42 AM (in response to f.k.lucas)
  
  Installing SAM 6.3 SP2 a couple of weeks ago seems to have fixed the issue for us.
  Not sure if it helps you at all...
  
  Like (0)
  
  Actions
  - Re: SQL connectivity losts and restores after Rebooting server.
    
    jburke Apr 10, 2017 9:42 AM (in response to jburke)
    
    Sorry Hotfix 2, not SP...
    
    Like (0)
    
    Actions

Go to original post