Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about the solution of SQL Server 2012 sa user login error 18456, which may not be well understood by many people. in order to make you understand better, the editor has summarized the following content for you. I hope you can get something according to this article.

Recently want to study the SQL SERVER2012 Enterprise version of the database, I heard that the function is very powerful. I installed it on win7, and the installation process went smoothly. I used "Windows authentication" and everything was OK, but the following error occurred when logging in to the database with SA users:

Previously installed SQL7.0, SQL2000, SQL2005 version, 2008 version, does not seem to be this complicated ah, Baidu found a solution, summed up: this error is generally caused by three reasons, login mode setting error, sa setting error and whether IP mode is enabled, the following three problems are solved in turn.

Solution:

I. setting of login method

1. Log in as "Windows Authentication", enter the server, right-click, and select Properties:

two。 In the pop-up dialog box, set Server Authentication method in Security to SQL Server and Windows Authentication modes:

II. Sa setting

1. Enter "Security", "login name", "sa", and right-click "sa" to select properties.

two。 In the pop-up dialog box, turn on Login

3. Enable IP

1. Open the SQL Server configuration Manager, expand SQL Server Network configuration, and turn on TCP/IP in MSSQLSERVER's Protocol:

two。 Configure the IP attribute, enter the TCP/IP attribute, and enable the required address

3. Restart the SQLServer service:

Next, you can log in to the database with sa.

After reading the above, do you have any further understanding of the solution to SQL Server 2012 sa user login error 18456? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.