After SQL Server is installed today, SQL Server can only log on with Windows identity, and cannot log on with SQL Server, such as SA, because SQL Server only has Windows authentication set and no SA logins set. Modify the Logon method. Check on the Internet, found this article, solve the problem, in order to facilitate the use of later, so it reproduced over, for everyone needs to see friends. If you are not setting up a hybrid login mode while you are loading sql2008, and you have to access sql2008 through the SQL Server mode, this article is for you; after reconnecting the SQL Server configuration, be sure to restart the SQL service Services, the above configuration does not take effect this article transfers from: http://www.2cto.com/database/201203/123759.html
See how to resolve the issue of "SQL Server can only log on using Windows identity and cannot log on with SQL Server such as SA"
