Remote SQL Access Through ISA (SBS 2003)

Hi All:
Our Software vendor needs to log on to SQL Server (we
have SBS 2003 Premium Edition)through ISA server. I have
followed microsoft direction and have opened port 1433.
He still cannot log on. He can log on through terminal
services but has no access to sql server. I have tried my
self and get the message that either the server does not
exsist or permission has been denied.
I can Ping the server sucessfully from remote site.
Please advice.
Thank you.
I have read articles # 300211 on microsoft web site in
knowledge base.
Many thanks for your time.
.Is your SQL Server a default or a named instance? If it's a default
instance then by default it listens on port 1433 but an admin could have
changed it to some other port. If it's a named instance then it will by
default use a dynamic port. You would need to check the Server Network
Utility on the server or read the latest SQL error log to see what port
your SQL Server is actually listening on and then open the appropriate port.
Also, if it's a named instance you will need to open UDP port 1434 OR
make your port static through the Server Network Utility AND specify the
port at the client (through an alias or by adding ,XXXX to the server name
in the connection string).
823938 How to use static and dynamic port allocation in SQL Server 2000
http://support.microsoft.com/?id=823938
You didn't mention the error you get, but most likely it's the one from:
328306 INF: Potential Causes of the "SQL Server Does Not Exist or Access
http://support.microsoft.com/?id=328306
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.