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 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Â
Back to Original Question