Hyperic and SQL

[vSohill]

Hi,

After I install Hyperic agent on SQl Sever and it went fine , but after that I could not reach any of the SQL database. In the following screenshot do I need to provide hqadmin password for sql admin password?

Is there any additional configuration do I need to do?

Thanks for the help

[admin]

Correct. You have to provide an user and password to connect to MSSQL instance.

[vSohill]

Thanks for your help, Is it hqadmin password or SQL DBO password

[admin · Accepted solution]

SQL DBO password

[VirtualAlex23]

Hi at all,

i'm trying to configure sql monitoring, but i can't collect metrics, can someone explain me how to configure it ?

Service_name

User

sqlserver_name

instance-name

and the type of permissions for admin user ?

Thx at all

[admin]

Hi,

Most of that parameters are auto-discovered by MSSQL plugin.

• Service_Name - MSSQL Windows Service Name
• User/Password - credentials for connection to MSSQL instance
• SqlServer_Name - Server name
• Instance_Name - Default/Named instance of MSSQL
• MSSQL-Cluster-Name - Cluster Name
• Cluster-Nodes - List of cluster's nodes

[VirtualAlex23]

Hi Boris,

thx for your reply, this is my situation:

• Service_Name - Windows Services: MSSQLSERVER
• User/Password - ADMINITRATOR
• SqlServer_Name - IP ADDRESS (it's ok ?)
• Instance_Name - MSSQLSERVER

Thx again for your help

[admin]

Looks good.

Make sure that you're using relevant credentials for connection to DB (not to OS).

[VirtualAlex23]

Hi Boris,

i'm using builtin\administrator account of Windows, this account have the possibility to login to SQL (management studio - windows authentication).

I need to create a specific user in SQL, with administrator grant for the instance ?

Another question maybe you can help me, SQL Plugin (Hyperic Server) need to resolve sql_server dns name, and viceversa, for the correct communication ?

Thx for your help

[VirtualAlex23]

Hi Boris,

i solve the problem with your info.

Thx again