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

book

Article ID: 177619

calendar_today

Updated On:

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