Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Web Site Error

I keep getting this error when going to the NPM site:

Cannot access main SQL Server database.

Connection = Provider=SQLOLEDB.1;User ID='SolarWindsNPM';Password='*********';Persist Security Info=False;Initial Catalog=NetPerfMon;Data Source=DATA;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=CATVModemMgmt;Use Encryption for Data=False;Tag with column collation when possible=False

Error = [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

I have uninstalled and reinstalled the V7.5
But it doesn't fix it.
Help!

Dennis A Moxley

Find more posts tagged with

Accepted answers

All comments

OK based on your connection string, your SQL server is on a box called DATA.

1) from the command prompt, is DATA resolvable? (can you type ping DATA and it resolve)
2) if you can resolve DATA, can you ping it?
3) Is the SQL server on DATA the default instance or is it installed as a secondary instance. Like if it is the SOLARWINDS instance of MSDE, then your DATA Source would need to be DATA\SOLARWINDS. This would could also be the problem if the SQL server is local.
4) is your SQL server running on the default TCP port of 1433? if not then add a ,port after the DATA Source Name=DATA,1899
5) is a firewall blocking TCP 1433

BK
Nobody Special

DarrenJeffrey

We are currently getting the exact same error message running 7.2.2. So it is not version related. We can use the GUI interface, but the Web component generated this error message. It started about a week ago. I check the Windows Update logs and the last time we did a Microsoft patch was back in Feburary.

If I run the SolarWinds Database Manager, I get can not 'Cannot connect to DBSRV07'

I can telnet to DBSRV07 port 1433 and get prompt.

We also get this from the trace of the connect:
5188 Apr-18 14:19:41 : Error = [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
5188 Apr-18 14:19:41 : SQL = Select * From WebSettings Where SettingName='Advanced Customization'
5188 Apr-18 14:19:42 : Error #= -2147467259

Any suggestions?

Isaac

Hello all,

Darren, it looks like, in your case, something has changed on the database server such that the account being used by Orion no longer has access to your database. I have my database on a SQL server that is maintained by a different group. They changed some of the security settings on the SQL server and Orion was no longer able to connect to the database.

This line was in my trace:
Error = [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

I hope your problem is as simple as mine was to fix. I just had to choke one of our systems analysts and everything started working again.

Be fantastic.