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

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

Authored by: Veryant Support on Wed, Sep 30th, 2009 at 7:00 PM
This question has been viewed 6778 times so far.
Online URL: http://support.veryant.com/support/phpkb/question.php?ID=109

Powered by PHPKB Knowledge Base Software