I am trying to connect from a workstation to an MSDE named instance on a win 2003 server. I have allowed the sql ports in ISA 2004 SP 2 for the named instance as well as port 1433. This is an MSDE (SQL 2000) instance not a SQL 2005 instance. "error: 26 - Error Locating Server/Instance Specified"
I followed the FAQ and here are my results:
Can you ping the server? Yes
Can you telnet to the SQL Service port on the SQL Server? Yes - I can telnet the port I opened for the named instance and No - "Could not open connection to the host, on port 1433: Connect failed" So I added 1433 outbound to the list of opened ports. Still cannot telnet.
Can you connect to the file share on the server? Yes
Can you connect to the SQL server from another machine on the same network as the workstation that isn't working? No
Are there any firewalls or ACLs on your network preventing access? Yes - I have Microsoft ISA 2004 SP 2 on the server where the instance resides. I added the rules to allow 1433 and the port for the named instance.
I followed the FAQ and here are my results:
Can you ping the server? Yes
Can you telnet to the SQL Service port on the SQL Server? Yes - I can telnet the port I opened for the named instance and No - "Could not open connection to the host, on port 1433: Connect failed" So I added 1433 outbound to the list of opened ports. Still cannot telnet.
Can you connect to the file share on the server? Yes
Can you connect to the SQL server from another machine on the same network as the workstation that isn't working? No
Are there any firewalls or ACLs on your network preventing access? Yes - I have Microsoft ISA 2004 SP 2 on the server where the instance resides. I added the rules to allow 1433 and the port for the named instance.