SQL Server Instance Syntax

robertlj

I am getting an error when trying to connect to an SQL database using the SQL Server User Experiance Monitor.

The Error is

provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified

I have tried:

 hostname/SQLEXPRESS hostname\SQLEXPRESS hostname\\SQLEXPRESS etc etc.

I use the same information when connecting using Microsoft SQL Server Managment Studio and it does not work.

My sql server is 2008 express.

Any ideas why this would be failing?

JasonFerree

The host name should be taken from the node assignment so you shouldn't have to specify it in the component configuration.  You assign the user experience monitor to the host name.  Inside the component details you should only need to specify the instance name.

http://www.solarwinds.com/NetPerfMon/SolarWinds/OrionAPMPHComponentTypesSqlQA.htm

Take a look at this page of the admin guide.  If you still have issues, submit a support ticket and we'll take a closer look.

thanks