Anyone know what 'Data Provider 'System.Data.SqlClient' not found.' means when trying to create a SQL Server User Experience Monitor?

I'm trying to create a new SQL Server User Experience Monitor and I am getting the above error.

I have tried two different sets of credentials, one a local SQL login and the second an AD account that is also set up as a SQL User for the DB.

Also if I run the query directly from the DB Manager instead of SAM with the same user/password it runs perfect.

Am I missing a library on my Orion server or something?

Find more posts tagged with

data provider 'system.data.sqlclient' not found

Accepted answers

All comments

bobmarley

I got it, don't put the server name in where it ask for SQL Server Instance. Leave it blank.

shuth

Delayed response but the SQL Server Instance name is different to the server name.

Roughly speaking, you can have multiple installations of SQL on the same server and they are kept in separate "instances". If you have a default SQL install, the default instance name is MSSQLSERVER and (as far as I am aware) what the SQL server will default to if you don't specify an instance name. IF you did name your SQL instance something else, you would need to put the new name in that instance field. Additionally, I believe SQL Express creates an instance called SQLEXPRESS (different to a full SQL Server install).