[Last Call] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 635
  • Last Modified:

can't connect to a sql database from an ISA server

I am testing some reporting software (GFI Webmonitor) on an ISA 2004 server and I have created a new database on our sql server but for some reason I cannot connect to it.  I can connect to the sql server from any other computer, just not the ISA 2004 server.  I created a rule but that didn't make any difference.
1 Solution
Raja Jegan RSQL Server DBA & ArchitectCommented:
Kindly post the error you encounter to help you out better..

Also kindly confirm / let me know

1. How you try to connect to that database either using SSMS or the application
2. Check the credentials that are used to connect the database..
What connection type you have used to connect to the database?
gilmanschoolAuthor Commented:
I'm just trying to telnet to it on port 1433.   Not using any credentials at that point.   When done from any other machine that isn't an ISA server I get a black screen which the software tech people tell me is what you're supposed to get.  From an ISA server I get:

C:\Documents and Settings\Administrator.GILNET>telnet millennium 1433
Connecting To millennium...Could not open connection to the host, on port 1433:
Connect failed
Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Jason WatkinsIT Project LeaderCommented:
I am 99.9% sure that the telnet protocol is not sanctioned on the ISA server.  Enable telnet and it's associated port (23) on the ISA server's exception list.
gilmanschoolAuthor Commented:
The original ISA rule i created wasn't 100% correct.    I had the rule allowing traffic to the sql database server specifically.  When I changed it to "internal" it worked.
Hi, Can you tell me what the ISA rule you created was please?

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now