How do I connect to a MS SQL 2005 Named Instance?

Question ID : 109
Created on 2009-09-30 at 11:58 AM
Author : Veryant Support [support@veryant.com]

Online URL : http://support.veryant.com/support/phpkb/question.php?ID=109


Question:
What should I do if I have more than one MS SQL Server instance in the same computer/server, and I want to connect to any of its named instances and not to the default one?

Answer:

Make sure you have followed the general instructions on the article called "How do I set up isCOBOL ESQL Generator for use with Microsoft SQL Server?" before applying the specifics described below.
Use the "SQL Server Configuration Manager" software that comes with your MS SQL product and follow these steps:

  1. Click SQL Server Network Configuration
  2. Double-click "Protocols for myNamedInstance"
  3. Enable TCP/IP protocol (right-click TCP/IP, enable)
  4. Double-click TCP/IP (to view its properties)
  5. Click IP Addresses tab
  6. Go to IPAll section, change the TCP Port to 1435 (or any other available TCP/IP port)
  7. Click OK to save configuration
Change the jdbc.url setting in the iscobol.properties as follows: 
   iscobol.jdbc.url=jdbc:sqlserver://computername:1435;user=sa;password=mysapassword;DatabaseName=mydbname


Back to Original Question