When I was using the database today, I suddenly found that SQL Server08 could not be connected. Problem:
So I searched for this problem on the Internet and found many similar questions. Since this problem was not encountered by a few people, it seems that this problem is worth studying.
There are many possibilities for this problem. First, provide a post to see if you can solve your problem:
Http://bbs.csdn.net/topics/390004720
If not. So there is good news and bad news. The bad news is that you have been fooled by many people. You even saw many netizens uninstalling and reinstalling 08, and even some people reinstalling the system...
I also encountered this problem. After analyzing it for a while, I felt that the solution may not be correct. So I used another method. The good news is that you can solve the problem with me.
* Note: only when your problem cannot be solved on the previous page or the method you tried cannot be solved can the problem be proved to be the same as mine. The method below will be effective.
1. First, we noticed that the connection was always selected (local), and there was no way to change it. In addition, no other plug-ins have been installed on the computer recently.
2. Check whether other plug-ins exist in the existing software. (You can see all the plug-ins on the computer by using the 360 Software Uninstall function)
3. enable SQL Server Configuration ,:
3. Check whether related services are enabled. The so-called service (the one pointed by the arrow) is the database entity you created. :
4. if you see the above interface, Jump directly to Step 6. If your interface window displays the Red Letter "No .. ", most of them are affected by the plug-in. In this case, you uninstall the plug-in with the following keywords in the 360 Software Uninstall:
(Microsoft SQL Server 2012 DB)
5. Run regedit after uninstalling and find HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft SQL Server \ 100 \ ConfigurationState. Change the value of CommonFiles to 3.
6. Start the SQL Server (XXX) service. XXX represents the database entity you created.
7. If you find that the service cannot be started, open management> service in the control panel, find the service pointed to by the following arrow, and click Start:
7. If it cannot be started, the error 17051 will be reported and the following will be enabled:
8. Select "maintenance"> "version upgrade" and click "Next" on the page. Note that during the upgrade, you will be asked to select the database entity you want to upgrade and select the previous XXX. Here I provide two keys for you:
Developer: PTTFM-X467G-P7RH2-3Q6CG-4DMYB
Enterprise: JD8Y6-HQG69-P9H84-XDTPG-34MBB
Generally, select the upgrade solution of the next Enterprise Edition.
9. After the upgrade is complete, restart the entity service following step 7, and then start the service following step 3. OK. Now try to connect to your database, it's amazing!
I'm LeiFeng who nerver told them name with good job.