Install SQL Server 2008 R2
summary
Provides installation instructions for SQL Server 2008 R2.
Operation confirmation version
Supported SQL Server versions
- 2008 R2
Check SQL Server version
- 2008 R2
Check for operation Windows version
- 2008 R2
substance
Put the installation DVD into the CD/DVD drive and start the installer. (or bind the SQL Server image file to a virtual drive.)
Installation requires administrative rights. For Windows Vista and later operating systems, a dialog will be displayed to promote, so click "Yes".
When the SQL Server Installation Center appears, select Install from the left menu, and then choose Perform a fresh installation or add functionality to an existing installation.
Click the "OK" button.
For the full version, enter your product key.
After reading the license terms, check "I accept the license terms", and click "Next".
Click the "Install" button. Installation of sql server itself is not yet because setup support files are installed.
Click Next.
Check Install SQL Server Features and click Next.
If you want to use PowerPivot in conjunction with SharePoint, check SQL Server PowerPivot for SharePoint. (SharePoint 2010 is required separately)
Check the function you want to install and click "Next". You can install additional these features later.
The decision whether to install the main functions will be described below, so please refer to it.
| Item | description |
|---|---|
| Database Engine Service | If you want to create a database in the OS environment where you installed it, check it. You don't need to have a database already on another server and you only want to install tools to connect from your client PC. |
| Analysis Services | Service for data analysis. You don't have to install it unless you explicitly want to use Analysis Services. On the other hand, if you install it poorly, the setting items will increase. |
| Reporting Services | A service that creates and manages reports with database tables and cubes created in Analysis Services. You don't have to install it unless you explicitly want to use Reporting Services. On the other hand, if you install it poorly, the setting items will increase. |
| Business Intelligence Development Studio | Visual Studio-based tools for creating projects for Integration Services, Analysis Services, and Reporting Services. If you don't use these features, you don't need to install them. |
| Client tool connections & Management tools |
Includes tools that you can work with using the GUI into SQL Server. Let's install it because it is more convenient to have. It can also be used if you want to connect to SQL Server from another PC. |
| Integration Services | It is a service that can perform data conversion and migration of each database and various workflows. Explicitly Integration Services You do not have to install it unless you want to use . |
Install other items as needed.
Click Next.
If you are installing SQL Server a new one, and you do not have any particular rules for instance names, you can specify a default instance. If it is the default instance, you can omit the instance name when connecting to SQL Server.
If sql server already uses the default instance, you cannot specify the default instance. In that case, you must explicitly specify a named instance.
Click Next.
Specifies the execution account for each service. Set it up for your domain environment and other circumstances. You can specify the local account of the server for personal use.
These settings vary depending on the service you have installed.
The collation is left as the default.
Wizard that is displayed when installing the database engine.
If you want to access only PCs installed in the database engine, or from users managed by the domain, you can only access Windows authentication mode.
If you need to access it from a completely different PC user, make SQL Server authentication available. In that case, you need to set a password.
You can also change the authentication mode later.
Specifies the SQL Server administrator. If you want to manage with the current logged-in user, click the "Add Current User" button to add the user to the list. If you are a group of other users, use the "Add" button to add them as needed.
Data disk tori, FILESTREAM, is left as the default.
Wizard that appears when you install Analysis Services.
Specifies the Analysis Services administrator. If you want to manage with the current logged-in user, click the "Add Current User" button to add the user to the list. If you are a group of other users, use the "Add" button to add them as needed.
Wizard that is displayed when you install Reporting Services.
Check Install an existing configuration in native mode, and then click Next.
If you want to use it in conjunction with SharePoint, check Install the default configuration for SharePoint integration mode. This requires a separate SharePoint.
Click Next.
Click Next.
Check the installation and, if you are satisfied, click the "Install" button to start the installation.
Wait for the installation to complete.
Once installed successfully, click the "Close" button to close it.
Please close the remaining screens.
If you have a database engine installed, let's check if you can connect.
From the Start menu, start Microsoft SQL Server 2008 R2 → SQL Server Management Studio. (Management tools must be installed)
Since the connection dialog to the server is displayed, "Server type" is set to "Database engine".
The server name is "." is specified. (If you specify an instance name, click ". (instance name))
Make authentication Windows authentication. Specifies SQL Server authentication if the logged-in user does not have connection rights. (Requires sql server authentication permission)
Sql Server Management Studio starts and the database configuration tree appears on the left to install successfully.
If you have Reporting Services installed in addition to the system database, you can verify that a database for Reporting Services has also been created.