User Tools
installing_sql_server_2008_r2_express_in_windows
Differences
This shows you the differences between two versions of the page.
|
installing_sql_server_2008_r2_express_in_windows [2013/04/25 14:49] admin |
installing_sql_server_2008_r2_express_in_windows [2013/04/25 15:36] (current) admin |
||
|---|---|---|---|
| Line 35: | Line 35: | ||
| =====Change Firewall Settings===== | =====Change Firewall Settings===== | ||
| + | |||
| + | The SQL Server uses port 1433, therefore the firewall must be configured to allow this port to communicate. | ||
| ====Windows Vista or 7==== | ====Windows Vista or 7==== | ||
| + | - Be sure you have permissions to change firewall settings. | ||
| + | - Click on **Start > Control Panel**. | ||
| + | - If the "View" is by "Category" click on the **System and Security** header, and click on **Windows Firewall**. If the "View" is by "Icon" just click on **Windows Firewall** icon. | ||
| + | - In the left-hand pane, click on **Advanced Settings**. | ||
| + | - In the left-hand pane of the new window, right-click on **Inbound Rules** and click **New Rule...**.{{ :sql_firewall03.png?nolink |}} | ||
| + | - Select the **Port** radio button and click **Next**.{{ :sql_firewall04.png?nolink |}} | ||
| + | - Next to **Specific local ports**, type **1433** in the field and click **Next**. Click **Next** again.{{ :sql_firewall05.png?nolink |}} | ||
| + | - Uncheck the **Public** checkbox, unless you know the SQL Server will need this functionality, and click **Next**.{{ :sql_firewall06.png?nolink |}} | ||
| + | - Type a name in the field so you can remember what this firewall rule does and click **Finish**. | ||
| ====Windows XP==== | ====Windows XP==== | ||
| + | - Be sure you have permissions to change firewall settings. | ||
| + | - Click on **Start > Control Panel** and double-click on **Windows Firewall**. | ||
| + | - Click on the **Exceptions** tab at the top.{{ :sql_firewall01.png?nolink |}} | ||
| + | - Click on the **Add port...** button near the bottom. | ||
| + | - Provide a name in the "Name" field so you can remember what this firewall rule does, type **1433** into the "Port number" field, and click **Ok**. Click **Ok** again.{{ :sql_firewall02.png?nolink |}} | ||
installing_sql_server_2008_r2_express_in_windows.1366926595.txt.gz ยท Last modified: 2013/04/25 14:49 by admin
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial 3.0 Unported
