|
This section details the various connection settings available for performing queries on Microsoft SQL database server. Step 1 and 2 are common to all database queries and connection methods. They are documented in the Database Query Analysis section.
Step 3.1a - Setting Command line connection to Microsoft SQL database servers
If you have selected Command Line Utility as the connection method at Step 2 of the Database Query Analysis wizard, the following panel is displayed:
Database Query Analysis Wizard — Microsoft SQL Server Command Line Connection Settings
| • | Hostname: Name of the server where SQL Server is running (host name or IP address) |
| • | SQL Server instance name: Specify the SQL server instance name if there are several SQL Server instances installed. Leave "default" if there is a single instance |
| • | Database name: Name of the database |
| • | Authentication mode (SQL Server/Windows): Select Windows if you wish to connect to the database through your Windows user account. Select SQL Server if you wish to connect the database with a specified login name and password from a non-trusted connection. In that case, SQL Server performs the authentication itself by checking to see if a SQL Server login account has been set up and if the specified password matches the one previously recorded. If SQL Server does not have a login account set, authentication fails and you get an error message. |
| • | Username: Account used to connect to the database |
| • | Password: Password associated with the specified username |
Click Next to access the query definition panel.
Step 3.2a - Setting JDBC connection to Microsoft SQL database servers
If you have selected Java Database Connectivity (JDBC) as the connection method at Step 2 of the Database Query Analysis wizard, the following panel is displayed:
Database Query Analysis Wizard — MS SQL Server JDBC Connection Settings
| • | Host name: Name of the server where SQL Server is running (host name or IP address) |
| • | SQL Server instance name: Specify the SQL server instance name if there are several SQL Server instances installed. Leave "default" if there is a single instance |
| • | Database name: Name of the database |
| • | Authentication mode (SQL Server/Windows): Select Windows if you wish to connect to the database through your Windows user account. Select SQL Server if you wish to connect the database with a specified login name and password from a non-trusted connection. In that case, SQL Server performs the authentication itself by checking to see if a SQL Server login account has been set up and if the specified password matches the one previously recorded. If SQL Server does not have a login account set, authentication fails and you get an error message. |
| • | Port: Specify the Microsoft SQL port number |
| • | Username: Account used to connect to the database |
| • | Password: Password associated with the specified username |
Click Next to access the query definition panel
Step 3.3a - Setting ODBC connection to Microsoft SQL database servers
If you have selected Open Database Connectivity (ODBC) as the connection method at Step 2 of the Database Query Analysis wizard, the following panel is displayed:
Database Query Analysis Wizard — MS SQL Server ODBC Connection Settings
Click Next to open the query definition panel.
| • | ODBC Driver (for ODBC Connection only): Select the appropriate ODBC driver. The ODBC driver must be installed on the PATROL Agent |
| • | Host name: Name of the server where SQL Server is running (host name or IP address) |
| • | Database name: Name of the database |
| • | Username: SQL Server account used to connect to the database |
| • | Password: Password associated with the specified username |
 | Monitoring Studio provides two drivers for Windows: SQL Server and SQL Server 2005; and one driver for UNIX: Easysoft ODBC-SQL |
Click Next to access the query definition panel.
| 
