SQL Server Installation

The first time you install SQL Server is version 2016, because "the win7-64 version of the system configuration is low", so it is unsuccessful.

The second installation of version 2012, in the "Database engine configuration", the choice is "Add current User", and the subsequent need to add users to choose "Add current User", causing the installation failed, mainly because my computer is set up a user name password login in "Computer-right-management-local Users and Groups", Users and groups in the administrator only with the corresponding management and mapping permissions, and I install time to add the current user is my Computer login user, it does not have a corresponding management and mapping relationship, so in the last step of the installation will be reported "account name and security ID no mapping between the complete" error.

Third Reinstall version 2012, error during installation: "The instance name is already in use."

"Solution" main Reference blog "26349927"

First step: Uninstall.

1. In the Run box, enter "Appwiz.cpl" to open the control panel and find something about SQL Server 2012, uninstall.

During the uninstallation process

In the "Select instance" step, the instance from which you want to remove the feature "select:" The one that the instance has used before the error prompt.

"Select Features" step: "Choose All"-"next"

The follow-up is basically "next"

Step Two: Re-install SQL server2012.

During the installation process

In order to use only the necessary features, in the "Feature selection" step, "instance features" only tick "database engine services" + "SQL Server Replication", "sharing features" only tick "management tools-Basic" + "management tool complete".

Instance configuration step, select default instance

In the "Database engine configuration" step, select "Mixed SQL Server Authentication and Windows Authentication"-need to enter a password, such as I entered 123456, pointing to SQL Server here, add-select Administrator, (because my computer, Administrator has administrative rights and has the corresponding user and group relationship)

The rest is basically "next". The installation was successful.

--------------------------------------

When you log on, SQL server2012 Windows connection is not on server error 18456.

Resolution: Refer to "52534323"

Log in with SA, password is entered at install time: 123456

Log in: File-new-query using the current connection

Input command: CREATE login [Sandy-pc\sandy] From Windows Click the Execute button and then exit SA login with Windows login also succeeded.

where Sandy-pc\sandy on the command line above is the user name prompted when Windows logs in, the brackets [] in the command are reserved.

----------------------------------------

There are two ways to use SQL Server to turn on services:

Method 1. Computers-right-management-services and Applications-sql Server Configuration Manager-sql Server service

Method 2. All Programs-Find the sqlserver2012-Configuration tool-sql Server Configuration Manager-"The following steps are the same as Method 1"

-------------------------

Start your trip to sql:)

SQL Server Installation