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 2005 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 2005 product and follow these steps: 

1) Click SQL Server 2005 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 4870 times so far.
Online URL: http://support.veryant.com/support/phpkb/question.php?ID=109

Powered by PHPKB Knowledge Base Software