SQL Server has passed the evaluation period and SQL Server has evaluated the problem.
At last, we had a holiday, and we also ushered in the day of upgrading the class to start school, you can study the computer in a down-to-earth manner. Since I have been reviewing professional courses for some time, I have put computer learning on hold for a while. Now, you must learn more.
However, when you open the system you have previously typed, an error is always reported and cannot be performed. After checking, it turns out that the database has a problem and cannot be connected to the database. When SQL Server2008 is enabled, the following error message is always reported:
When the problem occurs, you have to solve the problem, so you can search for information online. I have found a solution and followed the steps Step by step, but it still cannot be repaired. This can make me anxious, because installing SQL server is a very troublesome thing, but also to uninstall the previous clean, some people because the uninstallation is not clean and reinstall the system. But fortunately, after searching for multiple parties, we found a solution.
Solution: Open the configuration tool-SQL server Installation center.
Select maintenance-Version Upgrade
Follow the prompts to perform the operation. When you need to enter the key, you can find a lot of keys on the Internet. For other keys, you only need to click Next. The upgrade will be successful. In this way, the problem can be solved.
If the above steps still cannot be solved, you need to modify the information in the registry:
Change the value of CommonFiles in HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft SQL Server/100/ConfigurationState to 3.
After the modification, follow the steps above (you can first try to open it, if not, follow the steps ).
After this step is performed, my problem is solved successfully, and the SQL server can be opened, but the problem arises again:
This problem has been encountered before and solved by some people, which is relatively easy.
Still open the configuration tool-SQL server Configuration Manager
Check whether the statuses of Named Pipes and TCP/IP in the MSSQLSERVER protocol are enabled. If not, manually enable them.
Then open the SQL Server service, but I encountered another problem:
There should have been a lot of content here, but I don't know why the remote process call failed. No way. You can only search for information online again. Many people have asked similar questions. Some say they can only reinstall the system, and some say they can directly install the system. Looking at other people's questions, no one can give a solution. To tell the truth, my heart was cool. However, it's better to be able to work on it. One solution is to uninstall a software in SQL server.
I loaded my mind when I failed to do so. The exciting thing is that, after the uninstallation, it was actually successful. Then, check whether SQL server (MSSQLSERVER) is started. If not, manually start it.
Finally, the problem was solved successfully. Although I spent a lot of time and energy, I learned a lot from it. SQL Server can be said to be the software we often use at this stage. Every time we encounter various problems and solve them, this is a process of our growth and success.
From this experience, I understand all the problems we have encountered, including those we have not encountered. In fact, everyone else has encountered them, this is the gap between us and them. When we encounter more and more problems, it is also a manifestation of our accumulation of knowledge to a certain extent. Therefore, when you encounter a problem, never lose heart, because there will always be a solution; if the problem cannot be found in any way, it means that your knowledge has reached a high level. However, we are far from able to achieve this. In this case, we should work hard.
