Many people SQL is not standardized, resulting in a variety of problems or long time, the password to forget, how to do? Re-installed?
Inverse days take a few more common things, the first is a variety of settings of the problem: (my home is a simple version, you develop the best Enterprise version)
1, first you see your Server service open? method One:win+r-->services.msc--> Select SQLExpress (instance name) and right-click Start Method Two: Right-click Computer--manage-- Services and Applications--Choose sqlexpress--> Right-click to start) method three: net start service name net stop service name (right-click Service--Properties-you can see name)
2, and then see if you can login Windows authentication (not ...) Big Brother Reload it, I can't do it. "In case of Service open")
First of all, make sure you're on the service. 3, try your SQL Server authentication can log in (if possible to see what, directly drifting past ~ you software no problem ~)
3.1 Let's see what you've chosen for authentication: Right-click the instance-----------Select SQL Server+windows authentication Mode
3.2 Not yet. Restart the service again to see, if not yet to expand Security, choose the login name, to see if your user is disabled, if there is a red arrow or small icon is disabled, right-click User----------
Most of the login problems are solved here, if there are other problems, you can use a powerful search engine
4, about the password to forget the description (in fact, this is the simplest, security-and login-and right-click on the user-name---and the password directly)
Remember to log in as Windows and then change Oh ~ —————————————————————— Theme (when extended) —————————————————————
A small problem in the database opening process has been troubling the novice, is to prevent the save
Solutions
The artifact on this issue is: Longman Dictionary of contemporary 中文版 5th Edition.rar (Longman Dictionary of Contemporary English offline version)
"SQL" SQL Server login FAQ