How do you connect to an instance (or named instance) of MS SQL that is not the default instance

Products

• Security Information Manager

Issue/Introduction

You need to connect to a specific instance of MS SQL and the connection string in the SSIM Collector documentation assumes the default instance

 

Cause

Without the instance name, the connection will fail.

Resolution

JDBC Connection strings for Named and Multiple MS SQL Server Instances:
 

• MS SQL2005
  jdbc:sqlserver://<IP address or hostname>;instanceName=XXXXX;DatabaseName=YYYYY

• MS SQL2000
  jdbc:sqlserver://<IP address or hostname>:1433;instanceName=XXXXX;DatabaseName=YYYYY

For more information on JDBC connections to a MS SQL database please review the MS SQL documentation or your database administrator