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

Running SQL Query on Remote Database

Hi, I'm trying to run a SQL query on a remote database and I am getting a connection error.

Testing on node SQLCLSTCACHE: failed with 'NotAvailable' status

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

I have verified 'Name Pipes' is enabled (saw another post about that). I ran a sql query from the Orion server to the remote server and was able to query the results.

If we were to use the Orion database as an example:

Test Server: Orion_server
SQL Server Instance: .
Initial Catalog: NetPerfMon
Windows Authentication: Enabled

I tried using a stored procedure from Orion as a test and used the above setting as a test and I'm still getting the same error. I take it that I don't have the settings correct.