New Question
 
 
PRTG Network Monitor

Intuitive to Use.
Easy to manage.

200.000 administrators have chosen PRTG to monitor their network. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free PRTG
Download >>

 

What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general. You are invited to get involved by asking and answering questions!

Learn more

 

Top Tags


View all Tags


How do I configure a Microsoft SQL database server sensor properly?

Votes:

0

Your Vote:

Up

Down

I want to set up monitoring for a MS-SQL data base. Do you have any configuration tips?

configuration prtg sensor sql

Created on Feb 19, 2010 10:43:09 AM by  Daniel Zobel [Paessler Support]



1 Reply

Accepted Answer

Votes:

0

Your Vote:

Up

Down

General Introduction to SQL Server Sensors

For general information and common settings for SQL sensors, please check the manual sections for SQL Server Sensors.

Configuration Tips for Microsoft SQL Sensors

  • Identify the MS SQL Server Version you use. If it is SQL Server 2005 then identify the instance name. You can get the instance name from the SQL Server Configuration manger (shown in brackets after the Servername), often this is SQLEXPRESS.
  • With earlier SQL Server versions there is by default no instance name. But it is possible to create named instances there as well. In this case either you should know the name as you created the instance or the database admin should be able to tell you the instance name.
  • Note: Sometimes you see connection strings like SQLSERVER\SQLINSTANCE in database clients. The first part is the server name that was configured in the 'General steps' section of this document (setting of PRTG Network Monitor's device object). The second part is the instance name mentioned here. Do NEVER enter the string in this form in the instance field of the sensor setup page, only the second part (and without the backslash)
  • In SQL Server 2005 there is always an instance name so enter this name located in the previous step now in the 'Instance Name' field of the sensor setup page. With other SQL Server versions you should usually leave this property empty unless you are sure that the instance you want to monitor was created as a 'named instance'
  • If your SQL Server runs the instance at a different static port than 1433 you can enter the port number in the 'Port' field of the sensor setup page. If your SQL Server uses the default value of 1433 or is configured for dynamic port setting then leave the 'Port' field empty.
  • The 'database' setting is a logical entity on the database server where database objects like tables, users, roles exist. Set the appropriate database that contains the table(s) which are used in the SQL statement of the sensor. Look at a 'databases' folder when browsing through the database objects with an SQL server management tool

Note: There may be restrictions which computers can log on to the sql server, so check the appropriate server settings if you have problems connecting to the server.

Created on Feb 19, 2010 10:47:55 AM by  Daniel Zobel [Paessler Support]

Last change on Mar 25, 2013 12:40:12 PM by  Gerald Schoch [Paessler Support]



Please log in or register to enter your reply.


Disclaimer: The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.