Workaround for SQL Server identity logon failure

A few days ago to write a program need to use the database, downloaded a use, there have been a lot of small problems (blame my 32bit do not make up the notebook), there are problems do not fear, at least prove that we are thinking about solutions. Don't talk nonsense, go straight to the chase.

SQL Server has two types of login, one is SQL Server Authentication login, the other is: Windows login, where SQL Server Authentication login method is very secure, requires an account and password (generally installed, you have set up an account and password, that is SA). General installation, we choose SQL Server Authentication method login, enter the password, may appear failed to login, summed up the online method, listed the following hands-on summary of the practice.

First of all, it may be that you do not configure identity login mode, the solution is to open the client, you can not connect, then right-click instances, properties, security, on the right side of the panel check the mixed authentication mode, enter the user name and password , OK.

Or we can first log into the database management interface with Windows login, then right-click on "Database" to select "Security" and select Hybrid authentication mode. and restart the server (note: Restarting the server is not the server shutting down, but the right-click "Database", restart Service).

Select Hybrid Login Mode

If you have checked the hybrid authentication mode and checked the start Server proxy account, enter the user name SA and password, and after restarting SQL Server, the server type is database engine, still cannot log in SQL Server authentication, display cannot connect, error code is 18456, What to do, problems to solve, the problem will always be less (a bit crazy), then it may be that SQL Server servers are not turned on, we look at the status of your server. To do this: Microsoft sqlserver-> Configuration Tool->sql Configuration Manager, in the Pop-up dialog box, select SQL Server service on the left, and see if the state of SQL MSSQLSERVER is running ", if not, right-click Start. Then try again and see if you can connect. If the SQL Server Configuration tool is not installed, to start a service, you can not pour us, right click on "My Computer" Click Management, and then click "Services"

Locate the SQL Server service and right-click to start.

If you still can't connect at this time, first hold the anger, we have to check, sa account is enabled, the solution is: first windows into the server,:1) into the "Security" right-click SA user, open the properties. 2) Select the "Status" tab and check enable in the login . Such as.

Problem analysis to now, believe that 99% of the fault has been ruled out, if at this point still not go (estimated already crazy), that should be SQL Server configuration problem, long pain is not as short as pain, uninstall clean, re-install it (helpless lift AH), perhaps the problem solved.

Workaround for SQL Server identity logon failure