1. Go to the SQL Server installation center and select the "Install" option. When installing SQL2008 on a new computer, you can directly choose "Install new SQL Server independently or install existing functions", and a default SQL instance will be installed.
2. Function selection: For servers with only databases installed, function selection can be made according to actual work needs. I generally choose: database engine service, client tool connection, SQL Server Books Online, management tools-basic, management tools-complete, in which database engine service is the core service of SQL database, and analysis and report services can be installed according to deployment requirements. These two services may need the support of IIS.
3. For instance settings, you can directly select the default instance for installation, or if there are multiple data service instances in the same server, you can install them according to different instance names.
4. Server configuration mainly refers to the configuration of service startup account. It is suggested to use the system account of NT AUTHORITYSYSTEM as the account name of the service, and specify the startup type of the currently selected service.
5. Database engine configuration. In the current configuration, SQL login authentication mode and account password are mainly set, and it is recommended to use mixed mode and SQL data storage directory and identity authentication mode for authentication. The password of the built-in SQL Server system administrator account (sa) during the installation process is quite special, and SQL2008 requires high password strength for SA, which needs to be composed of uppercase and lowercase letters, numbers and symbols, otherwise the installation is not allowed. In "Specify Sql Server Administrator", it is best to specify the system administrator of this computer.
6. The next step is to preview and confirm the information. After confirmation, you can start the installation.