What exceptions do I need to make in the windows firewall in order for people
to connect to and use my SQL 2008 server and databases?

Long answer - it depends on what people are doing. See How to: Configure a
Windows Firewall for Database Engine Access
http://msdn.microsoft.com/en-us/library/ms175043.aspx
Short answer, if you are connecting to the default instance, TCP port 1433.
If you are connecting to a named instance, UDP port 1434, plus the TCP port
used for that instance.
--
Rick Byham, MSFT
(Implies no warranty or rights)


"biff" <biff (AT) discussions (DOT) microsoft.com> wrote

biff (biff (AT) discussions (DOT) microsoft.com) writes:
In additions to Rick's answer, what people will connect to your database?
That is, is this within the office which has a corporate firewall? Or will
you expose the database directly on the Internet? In that case, be very
very careful.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Only corporate should be able to connect.

"Erland Sommarskog" wrote: