Member server SQL 2008 Server Installation configuration graphics tutorial in AD domain _mssql2008

Source: Internet
Author: User
Tags sql 2008
Test environment:

DC01 DC Server
Member servers in the CNDB02 domain to install SQL Server

First step:
Adding users to SQL Services and SQL administrators

Service startup account
Sqlsvc Password: liy6$z92
SQL Administrator user
Sqladmin Password: k3$f0z6 password can be set, here in order to conform to the AD domain password policy.










Step Two:
Log on as a local administrator CNDB02 for program installation


Automatically install the system components required for SQL after inserting the installation CD














Reboot the server as required
After logging in, double-click the installation CD to start the installation


Open System Configuration Checker



Open a new SQL Server standalone installation



Enter serial number

Accept the terms of the license





If a 64-bit system needs to modify the version in the option



If you are minimizing the installation, select the Database engine service and SQL Server replication


Because you need to manage the database server on your computer, check the administration tools, and Books Online can be used to check for help when you're not using it.

Instance using the default instance

Set service startup user as Sqlsvc




Add SQL Server administrator to Sqladmin









To view the installation log, the services have been successfully installed



Step Three:
Sqladmin logon CNDB02 Verify that the permissions are available







The database was created successfully, and this installation is complete.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.