How to connect to a clustered or named instance on a MS SQL database using the SIM product collector

Products

• Security Information Manager

Issue/Introduction

The collector PDF's don't currently address named instances in the jdbc connection example.

Cause

Your database needs to know what instance you are connecting to, without it your connections will fail.

Resolution

 

Below are examples of MS SQL connection strings based on MS SQL server environment layout.

 

JDBC instance string method #1

 

MSSQL 2000:

jdbc:microsoft:sqlserver://<hostname>;instanceName=<named_instance>;DatabaseName=DB_name

 

MSSQL 2005:

jdbc:sqlserver://<hostname>;instanceName=<named_instance>;DatabaseName=DB_name

 

JDBC instance string method #2

 

MSSQL 2000:

jdbc:microsoft:sqlserver://<hostname>\<named_instance>:1433;DatabaseName=DB_name

 

MSSQL 2005:

jdbc:sqlserver://<hostname>\<named_instance>:1433;DatabaseName=DB_name

 

JDBC clustered environement string method

 

MSSQL 2005:

jdbc:sqlserver://<named_instance>:1433;DatabaseName=sepm
 

Note: For the clustered environment string,  you do not need <hostname> in the string, just the instance name. 

 

If the examples below do not work, please contact your MS SQL database administrator for the exact string needed in that case.