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 12:24] admin |
installing_sql_server_2008_r2_express_in_windows [2013/04/25 15:36] (current) admin |
||
|---|---|---|---|
| Line 17: | Line 17: | ||
| - Review the "Named Instance" and change if necessary. The "Instance ID" will automatically match the "Named Instance." **!!Write this name down!!**{{ :sqlexp06.png?nolink |}} | - Review the "Named Instance" and change if necessary. The "Instance ID" will automatically match the "Named Instance." **!!Write this name down!!**{{ :sqlexp06.png?nolink |}} | ||
| - Review the credentials that will be used for the services that will be created. Click the **Use the same account for all SQL Server services**. Enter an "Account Name" and "Password" for a user account that will administer the SQL Server. This account must already exist on the system. Click **Ok** and click **Next**.{{ :sqlexp07.png?nolink |}} | - Review the credentials that will be used for the services that will be created. Click the **Use the same account for all SQL Server services**. Enter an "Account Name" and "Password" for a user account that will administer the SQL Server. This account must already exist on the system. Click **Ok** and click **Next**.{{ :sqlexp07.png?nolink |}} | ||
| - | - Choose the **Mixed Mode** Authentication. Enter a password (twice) for a "sa" account. **!!Write this password down if you are installing AppMonitor!!**{{ :sqlexp08.png?nolink |}} | + | - Choose the **Mixed Mode** Authentication. Enter a password (twice) for the "sa" account. **!!Write this password down if you are installing AppMonitor!!** Continue to add any additional users into the box below if desired and click **Next**.{{ :sqlexp08.png?nolink |}} |
| - Review the Error Reporting settings.{{ :sqlexp09.png?nolink |}} | - Review the Error Reporting settings.{{ :sqlexp09.png?nolink |}} | ||
| - That’s it!{{ :sqlexp10.png?nolink |}} | - That’s it!{{ :sqlexp10.png?nolink |}} | ||
| + | |||
| + | =====Configure===== | ||
| + | |||
| + | - 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 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**.{{ :sql_conf04.png?nolink |}} | ||
| + | - Above that, click on the **IP Addresses** tab. | ||
| + | - 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 the field next to it and click **Ok**. Ignore the warning that follows. | ||
| + | - In the left-hand pane, click on **SQL Server Services**. | ||
| + | - 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]] | ||
| + | |||
| + | =====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.1366917880.txt.gz · Last modified: 2013/04/25 12:24 by admin
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial 3.0 Unported
