SQL Server 2012 Installation and startup graphics tutorial _mssql

Source: Internet
Author: User
Tags mixed management studio sql server management sql server management studio

This article introduces the SQL server2012 installation and start graphics and text tutorial, very detailed.

The sqlserver2012 installation steps are as follows:

SQL Server 2012 installation process is very long, many of the interface is not one by one, I am in the Win7 Enterprise version of the 64-bit and WIN10 Professional Edition SP1 64-bit SQL Server 2012, there is no problem.

1. Install the function selection, select "All"

2. Database engine settings, select "Mixed Mode" to set the login password for the system Administrator SA.

If you select Windows login at installation time, you can modify it after installing the program.

3. Add SQL Server administrator name, there will be several interfaces to add, there are three, not one list. Select "Add Current User"

The other is installed by default, the installation time is very long, waiting patiently.

Below look at the sqlserver2012 boot method

1. Start SQL Server Management Studio

2. Choose Login Mode

Server name: "." Represents a local database

Authertication:windowsauthertication for administrator logon rights, general select SQL Serverauthertication Login

If you do not select "Mixed login" when installing, then you can windowsauthertication login to modify the configuration before:

A. Server right key "Properties"

B. Select a mixed login mode

Properties of the C. SA

d. Mixed login allowed

E. Re-login is available.

The above is a small set to introduce the SQL Server 2012 installation and start graphics and text tutorials, I hope to help you, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!

Related Article

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.