I did a SQL 2000 migration from SQL 2000 SP3 to SQL 2000 SP4 on a different hardware.
I have moved the database to a second instance which is listening on port 1435 and I able to telnet 1435 from the
the web and app boxes and also the connection string seems to be fine with the user credentials.
Data source = 'servername\instancename,1435'
But still I am getting the error below when clicking on the url
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (-2147467259)
can someone please advise what could be the issue as I have checked the FW and it looks fine.
Thanks in advance,
View Complete Post