User Tools

Site Tools


installing_sql_server_2008_r2_express_in_windows

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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 |}}
installing_sql_server_2008_r2_express_in_windows.1366927387.txt.gz · Last modified: 2013/04/25 15:03 by admin