1, the first is the landing problem, SQL Server 2008 Select Windows Authentication cannot log on (Microsoft SQL Server, error: 18456)
is when you connect to SQL Server 2008, select Windows Authentication, prompting for a wrong user name or password.
Whether it is Windows authentication or SQL authentication, there should be a corresponding login name in SQL Server.
Through the sa account password, check "security"-"login name", found that there is only one systenm Windows account, no administrator account. Create a administrator login, select Windows Authentication, and at the server role tick sysadmin, OK. Then log back in, select Windows Authentication, and you will be able to log in as expected. ----------------------------------------------------------------------------------------------================= =========================================== 2, set user password settings user mappings specify the database to be accessed--------------------------------------------- -------------------------------------------------============================================================
SQL Server related Error issues and workarounds