Problems accessing SQL Server on ISA Server machine via Enterprise Manager

Hi there,
we're running SBS2K with ISA-Server. The same machine also runs a SQL Server database and the SQL Server database agent.

I need to connect to an SQL Server database that is on the Internet, i.e. outside our firewall.
When I try this from a client computer with the firewall client installed, everything works.

But when I open up Enterprise Manager from my Server machine (the one that's running ISA Server as well) and try to connect to the same outside machine I get a "connection does not exist or connection denied" error. I really need to run Enterprise Manager / Agent from my server as I have to do some regular maintenance tasks from there, and only the server is running 24/7, not my clients.

Any advice on where to find the reasons for this problem and how to solve it would be greatly appreciated.

best regards,
Stefan
stdirkAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

stdirkAuthor Commented:
Thanks for the speedy response, but my problem is NOT that my clients cannot connect to external SQl-Servers.
It is, that I cannot connect from the server machine on which SQL Server and ISA-Server is running!!! This, however, is not covered in the article...
best regards,
stefan
geoffrynCommented:
You need to create a packet filter for SQL 1433.  By default, the ISA server itself has very limited outbound services.  You have to enable packet filters for new services

http://isaserver.org/tutorials/How_to_use_ISA_Server_Packet_Filters.html

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Tim HolmanCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

 --> ACCEPT:geoffryn


Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

 
tim_holman
EE Cleanup Volunteer
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Fonts Typography

From novice to tech pro — start learning today.