MSDE and ISA

I am running 2 instances of MSDE2000 on a server with Win2K server SP4 and
ISA Server 2000. From the workstations on the network I am able to create
an ODBC connection to the default instance of SQL (MSSQL) but receive an
error when trying to connect to the 2nd instance (MSSQL\INSTANCENAME). Both
names appear in the dropdown list when creating the ODBC connection. Both
instances are running and networking for TCP/IP is enabled using SVRNETCN.
Both instances use the same SA password and connection is made using SQL
Authentication.
Error Message is
Connection Failed
SQLState 01000
SQL Server Error: 10048
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect())
Connection Failed
SQLState 08001
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied
If I stop both instances of SQL and start only the 2nd instance i am then
able to connect to it but am unable to connect to the default instance when
it is restarted. It seems that the first instance of SQL to start can have
a connection made to it and any other instances cannot have an ODBC
connection. I think it may be related to ISA Server but cannot confirm at
this stage
Any advice would be appreciated.
Darrin
Darrin Acreman wrote:
> I am running 2 instances of MSDE2000 on a server with Win2K server SP4 and
> ISA Server 2000. From the workstations on the network I am able to create
> an ODBC connection to the default instance of SQL (MSSQL) but receive an
> error when trying to connect to the 2nd instance (MSSQL\INSTANCENAME). Both
> names appear in the dropdown list when creating the ODBC connection. Both
> instances are running and networking for TCP/IP is enabled using SVRNETCN.
> Both instances use the same SA password and connection is made using SQL
> Authentication.
> Error Message is
> Connection Failed
> SQLState 01000
> SQL Server Error: 10048
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect())
> Connection Failed
> SQLState 08001
> SQL Server Error: 17
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
> access denied
> If I stop both instances of SQL and start only the 2nd instance i am then
> able to connect to it but am unable to connect to the default instance when
> it is restarted. It seems that the first instance of SQL to start can have
> a connection made to it and any other instances cannot have an ODBC
> connection. I think it may be related to ISA Server but cannot confirm at
> this stage
> Any advice would be appreciated.
> Darrin
>
Check the port numbers for both instances, they should be different
different. Check the application log/system log for any errors generated
by the second instance you start.