gilmanschool
asked on
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.
What connection type you have used to connect to the database?
ASKER
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.GIL
Connecting To millennium...Could not open connection to the host, on port 1433:
Connect failed
C:\Documents and Settings\Administrator.GIL
Connecting To millennium...Could not open connection to the host, on port 1433:
Connect failed
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi, Can you tell me what the ISA rule you created was please?
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..