SQL Server 2012 Installation and startup graphics tutorial _mssql

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!