Hi All,
I want to configure this plug in. Can someone please help me giving step by step guidance.
Basically the plug in need to be placed in plug in directory and after that it requires 2 more steps.
WMI (I need step by step how to configure)
ADO/Sqloledb how to configure this, where exactly it is located
Regards
After the plugin is in the ~plugins directory, you also need to add a mssql.ini file in the check_mk directory.
That file should look something like this;
[auth]
type = db
username = username_of_db_user
password = password_of_db_user
After that perform an inventory of the MSSQL host/cluster and it should find the new services.
On Tue, May 9, 2017 at 4:21 AM, Narendra Kumar via checkmk-en checkmk-en@lists.mathias-kettner.de wrote:
Hi All,
I want to configure this plug in. Can someone please help me giving step by step guidance.
Basically the plug in need to be placed in plug in directory and after that it requires 2 more steps.
- WMI (I need step by step how to configure)
- ADO/Sqloledb how to configure this, where exactly it is located
Regards
checkmk-en mailing list
Hi Paul,
Sorry for late reply, which version of mssql.vbs u r suggesting?
I see instructions on mssql.vbs
Check_MK windows agent plugin to gather information from local MSSQL servers
’
’ This plugin can be used to collect information of all running MSSQL server
’ on the local system.
’
’ The current implementation of the check uses the “trusted authentication”
’ where no user/password needs to be created in the MSSQL server instance. It
’ is only needed to grant the user as which the Check_MK windows agent service
’ is running access to the MSSQL database.
’
’ The following sources are asked:
’ 1. WMI - to gather a list of local MSSQL-Server instances
’ 2. MSSQL-Servers via ADO/sqloledb connection to gather infos these infos:
’ a) list and sizes of available databases
’ b) counters of the database instance
’
’ This check has been developed with MSSQL Server 2008 R2. It should work with
’ older versions starting from at least MSSQL Server 2005.
’ -----------------------------------------------------------------------------
I have done as per your guidelines
I get access denied error
<<<mssql_versions>>>
C:\Program Files (x86)\BT\Monitoring\Agent\plugins\mssql.vbs(130, 5) Microsoft OLE DB Provider for SQL Server: VIEW SERVER STATE permission was denied on object ‘server’, database ‘master’.
Please let me know how to get it done.
Regards
On May 9, 2017 9:27 PM, Paul D paulmonitoring@gmail.com wrote:
- There is nothing to configure on WMI.
- Not sure you need to do anything here either.
After the plugin is in the ~plugins directory, you also need to add a mssql.ini file in the check_mk directory.
That file should look something like this;
[auth]
type = db
username = username_of_db_user
password = password_of_db_user
After that perform an inventory of the MSSQL host/cluster and it should find the new services.
On Tue, May 9, 2017 at 4:21 AM, Narendra Kumar via checkmk-en checkmk-en@lists.mathias-kettner.de wrote:
Hi All,
I want to configure this plug in. Can someone please help me giving step by step guidance.
Basically the plug in need to be placed in plug in directory and after that it requires 2 more steps.
- WMI (I need step by step how to configure)
- ADO/Sqloledb how to configure this, where exactly it is located
Regards
checkmk-en mailing list
Hi,
you’ve to either grant the user, the agent runs as, the appropriate permission or configure the mssql.ini to use another user, which has the needed permission.
Regards,
Marcel
Narendra Kumar via checkmk-en checkmk-en@lists.mathias-kettner.de schrieb am Do., 11. Mai 2017 09:09:
Hi Paul,
Sorry for late reply, which version of mssql.vbs u r suggesting?
I see instructions on mssql.vbs
Check_MK windows agent plugin to gather information from local MSSQL servers
’
’ This plugin can be used to collect information of all running MSSQL server
’ on the local system.
’
’ The current implementation of the check uses the “trusted authentication”
’ where no user/password needs to be created in the MSSQL server instance. It
’ is only needed to grant the user as which the Check_MK windows agent service
’ is running access to the MSSQL database.
’
’ The following sources are asked:
’ 1. WMI - to gather a list of local MSSQL-Server instances
’ 2. MSSQL-Servers via ADO/sqloledb connection to gather infos these infos:
’ a) list and sizes of available databases
’ b) counters of the database instance
’
’ This check has been developed with MSSQL Server 2008 R2. It should work with
’ older versions starting from at least MSSQL Server 2005.
’ -----------------------------------------------------------------------------
I have done as per your guidelines
I get access denied error
<<<mssql_versions>>>
C:\Program Files (x86)\BT\Monitoring\Agent\plugins\mssql.vbs(130, 5) Microsoft OLE DB Provider for SQL Server: VIEW SERVER STATE permission was denied on object ‘server’, database ‘master’.
Please let me know how to get it done.
Regards
On May 9, 2017 9:27 PM, Paul D paulmonitoring@gmail.com wrote:
- There is nothing to configure on WMI.
- Not sure you need to do anything here either.
After the plugin is in the ~plugins directory, you also need to add a mssql.ini file in the check_mk directory.
That file should look something like this;
[auth]
type = db
username = username_of_db_user
password = password_of_db_user
After that perform an inventory of the MSSQL host/cluster and it should find the new services.
On Tue, May 9, 2017 at 4:21 AM, Narendra Kumar via checkmk-en checkmk-en@lists.mathias-kettner.de wrote:
Hi All,
I want to configure this plug in. Can someone please help me giving step by step guidance.
Basically the plug in need to be placed in plug in directory and after that it requires 2 more steps.
- WMI (I need step by step how to configure)
- ADO/Sqloledb how to configure this, where exactly it is located
Regards
checkmk-en mailing list
checkmk-en mailing list
As Marcel suggested, my mssql.ini file has a DB user that has the needed permissions to check the database.
On Thu, May 11, 2017 at 12:24 AM, Marcel Schulte schulte.marcel@gmail.com wrote:
Hi,
you’ve to either grant the user, the agent runs as, the appropriate permission or configure the mssql.ini to use another user, which has the needed permission.
Regards,
Marcel
Narendra Kumar via checkmk-en checkmk-en@lists.mathias-kettner.de schrieb am Do., 11. Mai 2017 09:09:
Hi Paul,
Sorry for late reply, which version of mssql.vbs u r suggesting?
I see instructions on mssql.vbs
Check_MK windows agent plugin to gather information from local MSSQL servers
’
’ This plugin can be used to collect information of all running MSSQL server
’ on the local system.
’
’ The current implementation of the check uses the “trusted authentication”
’ where no user/password needs to be created in the MSSQL server instance. It
’ is only needed to grant the user as which the Check_MK windows agent service
’ is running access to the MSSQL database.
’
’ The following sources are asked:
’ 1. WMI - to gather a list of local MSSQL-Server instances
’ 2. MSSQL-Servers via ADO/sqloledb connection to gather infos these infos:
’ a) list and sizes of available databases
’ b) counters of the database instance
’
’ This check has been developed with MSSQL Server 2008 R2. It should work with
’ older versions starting from at least MSSQL Server 2005.
’ -----------------------------------------------------------------------------
I have done as per your guidelines
I get access denied error
<<<mssql_versions>>>
C:\Program Files (x86)\BT\Monitoring\Agent\plugins\mssql.vbs(130, 5) Microsoft OLE DB Provider for SQL Server: VIEW SERVER STATE permission was denied on object ‘server’, database ‘master’.
Please let me know how to get it done.
Regards
On May 9, 2017 9:27 PM, Paul D paulmonitoring@gmail.com wrote:
- There is nothing to configure on WMI.
- Not sure you need to do anything here either.
After the plugin is in the ~plugins directory, you also need to add a mssql.ini file in the check_mk directory.
That file should look something like this;
[auth]
type = db
username = username_of_db_user
password = password_of_db_user
After that perform an inventory of the MSSQL host/cluster and it should find the new services.
On Tue, May 9, 2017 at 4:21 AM, Narendra Kumar via checkmk-en checkmk-en@lists.mathias-kettner.de wrote:
Hi All,
I want to configure this plug in. Can someone please help me giving step by step guidance.
Basically the plug in need to be placed in plug in directory and after that it requires 2 more steps.
- WMI (I need step by step how to configure)
- ADO/Sqloledb how to configure this, where exactly it is located
Regards
checkmk-en mailing list
checkmk-en mailing list
Hi
I am using same user for login under MS sql management studio and able to view reports by right clicking dbs. Only sys.traces permissions are not available for this user which I am connected
So user having access but still getting access denied.
Regards
On May 12, 2017 1:32 AM, Paul D paulmonitoring@gmail.com wrote:
As Marcel suggested, my mssql.ini file has a DB user that has the needed permissions to check the database.
On Thu, May 11, 2017 at 12:24 AM, Marcel Schulte schulte.marcel@gmail.com wrote:
Hi,
you’ve to either grant the user, the agent runs as, the appropriate permission or configure the mssql.ini to use another user, which has the needed permission.
Regards,
Marcel
Narendra Kumar via checkmk-en checkmk-en@lists.mathias-kettner.de schrieb am Do., 11. Mai 2017 09:09:
Hi Paul,
Sorry for late reply, which version of mssql.vbs u r suggesting?
I see instructions on mssql.vbs
Check_MK windows agent plugin to gather information from local MSSQL servers
’
’ This plugin can be used to collect information of all running MSSQL server
’ on the local system.
’
’ The current implementation of the check uses the “trusted authentication”
’ where no user/password needs to be created in the MSSQL server instance. It
’ is only needed to grant the user as which the Check_MK windows agent service
’ is running access to the MSSQL database.
’
’ The following sources are asked:
’ 1. WMI - to gather a list of local MSSQL-Server instances
’ 2. MSSQL-Servers via ADO/sqloledb connection to gather infos these infos:
’ a) list and sizes of available databases
’ b) counters of the database instance
’
’ This check has been developed with MSSQL Server 2008 R2. It should work with
’ older versions starting from at least MSSQL Server 2005.
’ -----------------------------------------------------------------------------
I have done as per your guidelines
I get access denied error
<<<mssql_versions>>>
C:\Program Files (x86)\BT\Monitoring\Agent\plugins\mssql.vbs(130, 5) Microsoft OLE DB Provider for SQL Server: VIEW SERVER STATE permission was denied on object ‘server’, database ‘master’.
Please let me know how to get it done.
Regards
On May 9, 2017 9:27 PM, Paul D paulmonitoring@gmail.com wrote:
- There is nothing to configure on WMI.
- Not sure you need to do anything here either.
After the plugin is in the ~plugins directory, you also need to add a mssql.ini file in the check_mk directory.
That file should look something like this;
[auth]
type = db
username = username_of_db_user
password = password_of_db_user
After that perform an inventory of the MSSQL host/cluster and it should find the new services.
On Tue, May 9, 2017 at 4:21 AM, Narendra Kumar via checkmk-en checkmk-en@lists.mathias-kettner.de wrote:
Hi All,
I want to configure this plug in. Can someone please help me giving step by step guidance.
Basically the plug in need to be placed in plug in directory and after that it requires 2 more steps.
- WMI (I need step by step how to configure)
- ADO/Sqloledb how to configure this, where exactly it is located
Regards
checkmk-en mailing list
checkmk-en mailing list
The agent is usually running as local\system. Unless you configured the agent to run as another user that’s the user needing SQL permissions.
HTH,
Marcel
Am 15.05.2017 09:19 schrieb “Narendra Kumar” narendra_ta@yahoo.co.in:
Hi
I am using same user for login under MS sql management studio and able to view reports by right clicking dbs. Only sys.traces permissions are not available for this user which I am connected
So user having access but still getting access denied.
Regards
On May 12, 2017 1:32 AM, Paul D paulmonitoring@gmail.com wrote:
As Marcel suggested, my mssql.ini file has a DB user that has the needed permissions to check the database.
On Thu, May 11, 2017 at 12:24 AM, Marcel Schulte schulte.marcel@gmail.com wrote:
Hi,
you’ve to either grant the user, the agent runs as, the appropriate permission or configure the mssql.ini to use another user, which has the needed permission.
Regards,
Marcel
Narendra Kumar via checkmk-en checkmk-en@lists.mathias-kettner.de schrieb am Do., 11. Mai 2017 09:09:
Hi Paul,
Sorry for late reply, which version of mssql.vbs u r suggesting?
I see instructions on mssql.vbs
Check_MK windows agent plugin to gather information from local MSSQL servers
’
’ This plugin can be used to collect information of all running MSSQL server
’ on the local system.
’
’ The current implementation of the check uses the “trusted authentication”
’ where no user/password needs to be created in the MSSQL server instance. It
’ is only needed to grant the user as which the Check_MK windows agent service
’ is running access to the MSSQL database.
’
’ The following sources are asked:
’ 1. WMI - to gather a list of local MSSQL-Server instances
’ 2. MSSQL-Servers via ADO/sqloledb connection to gather infos these infos:
’ a) list and sizes of available databases
’ b) counters of the database instance
’
’ This check has been developed with MSSQL Server 2008 R2. It should work with
’ older versions starting from at least MSSQL Server 2005.
’ -----------------------------------------------------------------------------
I have done as per your guidelines
I get access denied error
<<<mssql_versions>>>
C:\Program Files (x86)\BT\Monitoring\Agent\plugins\mssql.vbs(130, 5) Microsoft OLE DB Provider for SQL Server: VIEW SERVER STATE permission was denied on object ‘server’, database ‘master’.
Please let me know how to get it done.
Regards
On May 9, 2017 9:27 PM, Paul D paulmonitoring@gmail.com wrote:
- There is nothing to configure on WMI.
- Not sure you need to do anything here either.
After the plugin is in the ~plugins directory, you also need to add a mssql.ini file in the check_mk directory.
That file should look something like this;
[auth]
type = db
username = username_of_db_user
password = password_of_db_user
After that perform an inventory of the MSSQL host/cluster and it should find the new services.
On Tue, May 9, 2017 at 4:21 AM, Narendra Kumar via checkmk-en checkmk-en@lists.mathias-kettner.de wrote:
Hi All,
I want to configure this plug in. Can someone please help me giving step by step guidance.
Basically the plug in need to be placed in plug in directory and after that it requires 2 more steps.
- WMI (I need step by step how to configure)
- ADO/Sqloledb how to configure this, where exactly it is located
Regards
checkmk-en mailing list
checkmk-en mailing list