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 13:10] admin |
installing_sql_server_2008_r2_express_in_windows [2013/04/25 15:36] (current) admin |
||
|---|---|---|---|
| Line 23: | Line 23: | ||
| =====Configure===== | =====Configure===== | ||
| - | - After successfully installing SQL Server Express, go to **Start > All Programs > Microsoft SQL Server 2008 R2 > Configuration Tools > SQL Server Configuration Manager**. | + | - After successfully installing SQL Server Express, go to **Start > All Programs > Microsoft SQL Server 2008 R2 > Configuration Tools > SQL Server Configuration Manager**.{{ :sql_conf01.png?nolink |}} |
| - In the left-hand pane, expand the **SQL Server Network Configuration** node and click on **Protocols for [YourServerName]**. | - In the left-hand pane, expand the **SQL Server Network Configuration** node and click on **Protocols for [YourServerName]**. | ||
| - | - In the right-hand pane, right-click on **TCP/IP** and click **Properties**. | + | - In the right-hand pane, right-click on **TCP/IP** and click **Properties**.{{ :sql_conf03.png?nolink |}} |
| - | - Under "General" next to "Enable", change the **No** to a **Yes**. | + | - Under "General" next to "Enable", change the **No** to a **Yes**.{{ :sql_conf04.png?nolink |}} |
| - Above that, click on the **IP Addresses** tab. | - Above that, click on the **IP Addresses** tab. | ||
| - | - Here you will see two more "Enable lines. Change them to **Yes**. | + | - Here you will see two more "Enable" lines. Change them to **Yes**.{{ :sql_conf06.png?nolink |}} |
| - | - At the very bottom of the list, under "IPAll" there is a line that says "TCP Port". Enter 1433 into this the field next to it and click **Ok*. Ignore the warning that follows. | + | - At the very bottom of the list, under "IPAll" there is a line that says "TCP Port". Enter 1433 into the field next to it and click **Ok**. Ignore the warning that follows. |
| - In the left-hand pane, click on **SQL Server Services**. | - In the left-hand pane, click on **SQL Server Services**. | ||
| - | - Right-click on **SQL Server (YourServerName)** and click **Restart**. | + | - Right-click on **SQL Server (YourServerName)** and click **Restart**.{{ :sql_conf09.png?nolink |}} |
| - After restarting, SQL Server should be ready to use. If you are installing AppMonitor, follow this next guide. [[installing_appmonitor|CLICK HERE]] | - After restarting, SQL Server should be ready to use. If you are installing AppMonitor, follow this next guide. [[installing_appmonitor|CLICK HERE]] | ||
| + | |||
| + | =====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==== | ||
| + | |||
| + | - 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==== | ||
| + | |||
| + | - 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.1366920624.txt.gz · Last modified: 2013/04/25 13:10 by admin
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial 3.0 Unported
