Access MS SQL through ISA Server 2004

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:

Connection failed:
SQLState: '01000'
SQL Server Error: 10061
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).
Connection failed:
SQLState: '08001'
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?

Many thanks!

Dan
danielgalloAsked:
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.

Keith AlabasterEnterprise ArchitectCommented:
What are you trying to achieve? Publish the sql server to the outside or use it for your internal users?
What ports have you forwarded from your external firewall/router to the ISA server external interface? (If its to the outside world)
Have you allowed traffic from the internal to local host and back? (if its for the internal users)

Need some details please
0
danielgalloAuthor Commented:
Hi, thanks for the reply.

I'm trying to publish the SQL Server to internal users only.  

I have setup a rule in ISA Server following the guide on the Microsoft site (http://www.microsoft.com/technet/prodtechnol/isa/2004/deploy/publishingsql.mspx):

Protocol: TCP Inbound, Port 1433
From / Listener: Internal, Local Host
To: 10.1.1.1 (Internal IP address of server)

When I monitor the connections in the "Logging" section of ISA Server, the connection pops up and it matches the rule name that was created for SQL Server.  There's several items that are displayed which match this rule, one for "Initiated Connection" and another for "Closed Connection".  There's about 36 of these logged for each time an ODBC connection has tried to be setup on an internal computer.

Everything else works fine for the client computers, i.e. they can access the net, e-mail etc, it's just I can't seem to get this SQL problem sorted.

Hope this info helps.
0
Keith AlabasterEnterprise ArchitectCommented:
OK.

You don't need to publish the sql server then as 'publishing' is for outside users coming in.
If the SQL service is running on the ISA server, all you need to do is create a new access rule allowing internal & local host (in the from box) to internal & local host (in the to box).
In the protocol box, you can either set it for all protocols or just for the MS sql server protocol.
0

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
danielgalloAuthor Commented:
So simple!  Thanks very much for that!
0
Keith AlabasterEnterprise ArchitectCommented:
More than welcome :)

Regards
Keith
ISA MCT
0
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
Microsoft Forefront ISA Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.