This shows you the differences between two versions of the page.
installing_sql_server_2008_r2_express_in_windows [2013/04/25 15:16] admin |
installing_sql_server_2008_r2_express_in_windows [2013/04/25 15:36] (current) admin |
||
---|---|---|---|
Line 43: | Line 43: | ||
- Click on **Start > Control Panel**. | - 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. | - 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 **Allow a program or feature through Windows Firewall**. | + | - In the left-hand pane, click on **Advanced Settings**. |
- | - In the top right, click the **Change settings** button. It may then ask you for administrative credentials. | + | - In the left-hand pane of the new window, right-click on **Inbound Rules** and click **New Rule...**.{{ :sql_firewall03.png?nolink |}} |
- | - In the bottom right, click the **Allow another program...** button. | + | - 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==== | ||