Hi experts, I'd appreciate any assistance with the following please!
I have a server that has ISA Server 2004 set up on it, and also MS SQL 2000. When creating an ODBC connection on the server to MS SQL it connects fine, however any internal computers cannot connect to SQL Server - I just get the following error:
SQL Server Error: 10061
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied.
So far I have done the following to try and get this working:
1) Followed the steps highlighted in http://www.microsoft.com/technet/prodtechnol/isa/2004/deploy/publishingsql.mspx
2) Logged all traffic in ISA Server, and it picks up that the client's trying to connect to SQL Server, but nothing is coming up as "Denied"
3) SQL Server is setup to allow "SQL Server and Windows" authentication
4) In SQL Server properties, "TCP/IP" is in the "Enabled Protocols" list set to port 1433
5) When creating an ODBC connection I have tried connecting with Windows Authentication and the System Administrator login details
6) Also when creating the ODBC connection I have unselected the "Dynamically determine port" option and set the port to 1433.
What obvious thing am I doing wrong?