 | | Configuration / Firewall management for SQL Server 2000, SQL Server 2005, SQL Server Express and Office Timesheets | | The answers to frequently asked configuration / firewall settings when using SQL Server 2000, SQL Server 2005, or SQL Server Express with Office Timesheets are listed below:
1) Will the user always need to open TCP port 1433 on the SQL Server?
A: No, this depends on the specific firewall in place.
For additional information please review the link http://support.microsoft.com/kb/287932 .
2) Will the user always need to add any .exe files to the firewall dealing with SQL Server?
A: No, this depends on the specific firewall in place. If firewall allows you to filter by *.exe then it is the preferable option.
If using the Windows Firewall option, see http://support.microsoft.com/kb/914277 . If the firewall in use does not allow filtering by *.exe then port 1433 must remain open.
3) Enabling Network Access during the installation of SQL Server Express:
For additional information please review the link http://msdn2.microsoft.com/en-us/library/ms143446.aspx | | | Related articles | | | Back to Search Results |
|
