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


Article ID: 109
Created: September 30, 2009
Last Updated: March 17, 2023
Author: Support KB Author

Online URL: https://support.veryant.com/phpkb/article.php?id=109