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
Store

Error connecting to SQL 2005 database in Database Manager

I receive the following error when trying to add a SQL server to Database Manager

cannot connect to SQL Server on "Server Name"

I found the following possible solution but it did not work

How do I correct connection issues in which my Orion server cannot connect to my SQL Server database?This is often caused by a registration issue with SQLdmo.dll on the Orion NPM server. Locate the SQLdmo.dll file and write down the location. At a command prompt, enter regsvr32 fullPathToSQLdmo.dll\SQLdmo.dll. For example, enter regsvr32 C:\Program Files\SolarWinds\Common\SQLDMO9\sqldmo.dll. After registering SQLdmo.dll, run the Orion Configuration wizard to reconnect to your SQL Server instance

The SQL user we are using to connect is the owner and we were able to connect to the database during setup. It appears that Orion (v8.5.1)is using the databse to store informaiton we just can't add the database to Database Manager. The database also shows up under SolarWinds Orion>Advanced Features>Monitor Polling Engines.

Find more posts tagged with

Accepted answers

All comments

mark_wiggans

The DB Manager needs a user account with SA rights.

FormerMember

Is it possible to just connect to a particular databse instead of all the databases on the server?

mark_wiggans

Yes, then the user should only need to be the db_owner role.

FormerMember

That is the way we have it. For some reason Database Manager only shows the SQP server to connect ot and does not ask for which database to connect to. What has to be done to connect to a database on a SQL server using Database Manager?