Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Accessing sql server through a firewall

Author  Topic 

esthera
Master Smack Fu Yak Hacker

1410 Posts

Posted - 2004-10-27 : 05:48:43
I created an sql server on my hosting account.
I want someone else who has a web server with a firewall to access it through his asp page. He says he couldn't get through his firewall. Is there anyway of finding out what port my sql server uses? When trying to access the asp page connecting to my sql server on his server we get a servr application error.

Any suggestions?

surefooted
Posting Yak Master

188 Posts

Posted - 2004-10-27 : 11:11:26
In the Server Network Utility, highlight TCP/IP, then click properties. That is your port. If you haven't changed the default, it should be 1433.

-Jon
Should still be a "Starting Member" .
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-10-27 : 13:05:32
1433 is probably blocked on the firewall as it should be. Change the port that SQL Server listens on, punch a hole in the firewall for this port, add an alias using Client Network Utility on the client machines for this port.

Tara
Go to Top of Page
   

- Advertisement -