This shows you the differences between two versions of the page.
|
installing_sql_server_2008_r2_express_in_windows [2013/04/25 15:03] admin |
installing_sql_server_2008_r2_express_in_windows [2013/04/25 15:36] (current) admin |
||
|---|---|---|---|
| Line 40: | Line 40: | ||
| ====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. | - Be sure you have permissions to change firewall settings. | ||
| - Click on **Start > Control Panel** and double-click on **Windows Firewall**. | - Click on **Start > Control Panel** and double-click on **Windows Firewall**. | ||
| - | - Click on the **Exceptions** tab at the top. | + | - Click on the **Exceptions** tab at the top.{{ :sql_firewall01.png?nolink |}} |
| - Click on the **Add port...** button near the bottom. | - 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. | + | - 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 |}} |