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

SQL Server Database Counters

I put the latest template for 2005 2008 SQL Databases and assigned nodes to monitor. I get this error on all of of the component status:

Unexpected error occurred. Input string was not in a correct format.

What should I be looking for?

Find more posts tagged with

Accepted answers

All comments

martin.susil

What APM version are you using? Could you post SQL statement which is used by the failing component?

nkelly1

I do not think it is the query I think it is the right of the user. I did some further checking. The user is an administrator on the server but I am getting this error when testing:

Testing on node SQLSERVER00: failed with 'NotAvailable' status

I guess my question should be what type of rights does the user need on the database. In this case I was testing the performace monitor

nkelly1

Also in testing the template that just uses performance counters and not queries I get this error:

Testing on node SQLSERVER00: failed with 'NotAvailable' status

Instance '_Total' does not exist in the specified Category.

JasonFerree

For a performance counter monitor we would focus on the permissions of the windows account used to poll the data rather than the rights needed in the database. We are going to be polling windows and asking the OS for the statistic. Just like if you were to go into your "performance monitor" in windows. You'll want to go to the catagory listed in the component monitor and see if _Total is an optional instance value.

ligiahag7902

I do not think it is the query I think it is the right of the user. I did some further checking. The user is an administrator on the server but I am getting this error when testing:
Testing on node SQLSERVER00: failed with 'NotAvailable' status
Login failed for user ''. The user is not associated with a trusted SQL Server connection.
I guess my question should be what type of rights does the user need on the database. In this case I was testing the performace monitor

I also think so.
__________________
[url=http://moviesonlinewatch.net]watch movies online free

martin.susil

I do not think it is the query I think it is the right of the user. I did some further checking. The user is an administrator on the server but I am getting this error when testing:
Testing on node SQLSERVER00: failed with 'NotAvailable' status
Login failed for user ''. The user is not associated with a trusted SQL Server connection.
I guess my question should be what type of rights does the user need on the database. In this case I was testing the performace monitor

What credentials are you using for connection to SQL server? It seems you are using Windows Authentication with invalid credentials. You should try SQL authentication with proper SQL account.