finally the holiday, at the same time we also ushered in the improvement of the class school days, you can learn the computer. Because the previous period of time has been reviewing the knowledge of specialized courses, relatively speaking, the computer study shelved for some time. Nowadays, we must intensify our study.
However, when you open the system before knocking, always error, unable to proceed. After the inspection found that the original database has a problem, unable to connect to the database. Open SQL Server2008 and always report such an error message:
The problem arose, it had to be solved, and began to search the Internet for information. Really found the relevant solution, follow the step by step, but still can't repair. This can make me worry, because it is a very troublesome to install SQL Server, but also to clean up the previous uninstall, some people because the uninstall is not clean and reinstall the system. But fortunately, after a multi-party search to find a solution.
Workaround: Open the Configuration Tool--sql Server Installation Center
Select Maintenance--Version Upgrade
According to the prompt to operate, encountered the need to enter the key, you can search the Internet a lot of keys, the other just click next to the line, and finally will prompt the upgrade success. This will allow you to resolve the problem.
If the above steps are not resolved, then you need to modify the information in the registry:
Hkey_local_machine/software/microsoft/microsoft SQL server/100/configurationstate CommonFiles value changed to 3
After the modification, then follow the above steps (you can try to open the first, if not yet, follow the steps).
After this step, my problem was solved and I was able to open SQL Server, but the problem followed:
This problem has been encountered before, but also to help people solve, relatively easy point.
Still open Configuration Tool--sql Server Configuration Manager
Check whether the status of Named Pipes and TCP/IP in the MSSQLSERVER protocol is enabled, if not, to enable it manually
Then Open the SQL Server service, but I'm having a problem:
There should be a lot of things here, but there's no clue why the remote procedure call failed. No way, only to find information on the Internet again. A lot of people have asked similar questions, some say can only reinstall, also some say direct installation system. Looking at other people are asking questions, and no one can give a solution, to tell the truth, then the heart is cold half ah. However, it is good to find a way to endure, there is a solution is to uninstall a software in SQL Server
Holding the unsuccessful re-installation of the mind I follow the instructions to unload. The excitement was that after the uninstallation, it really worked. Then check that SQL Server (MSSQLSERVER) is started, if it does not still need to be started manually.
Finally, the problem was solved satisfactorily. Although it took a lot of time and energy, but also learned a lot of things from it. SQL Server can be said that we are often used at this stage of the software, each time will not be able to avoid the emergence of various problems, problems to solve problems, this is our growth and harvest of a process.
from this experience I understand that at present, all the problems we have encountered, including those we have not encountered the problem, in fact, others should have encountered, this is the gap between us and them. When we encounter more and more problems, it is precisely the accumulation of our knowledge to a certain degree of performance. Therefore, when encountering problems, do not lose heart, because there will always be a solution, if you really can not find a solution in any way, it means that your knowledge has reached a high level. However, now we are far from reach, that being so, then go down to work hard.
SQL Server evaluation period has gone wrong
