Hi all,
I need help in solving a connection problem. There is a failover
cluster running SQL Server 2000 in to instances, 'AUTUMN-03' and
'WINTER-03\I1'. On an other machine I run a service, 'SNOW', which
should connect to the WINTER-03\I1 instance via DB-Library. But it
fails.
I have checked the Server Network Utility and set up the WINTER-03\I1
instance to listen to TCP/IP communication on port 1434. I also have
created an alias, 'WINTER', on the service machine to refer to the
named instance.
I have no problem using the alias to connect via ODBC as an
administrator on the SQL Server machine, but the SNOW service can not
connect via DB-Library, using the same Windows account.
I just get the following error message: 'Unable to connect. SQL Server
is unavailable or does not exist.'
What is wrong?
TIA
Fredrik Möller