Shulou(Shulou.com)05/31 Report--

This article will explain in detail the solution to the problem that the SQL Server evaluation period has passed. The content of the article is of high quality, so the editor will share it with you for reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

However, when I opened the system I tapped before, I always reported an error and could not proceed. After inspection, it was found that there was a problem with my own database and could not connect to the database. Open Sql Server2008 and always report an error message like this:

When the problem arises, it has to be solved, so we start to look for information on the Internet. Really found the relevant solution, follow the steps step by step, but still can not be repaired. This makes me worried, because installing SQL server is a very troublesome thing, but also uninstall the previous clean, some people reinstall the system because of dirty unloading. Fortunately, a solution was found after a multi-party search.

Solution:

Open the configuration tool-- sql server installation Center

Select maintenance-version upgrade

According to the prompt to operate, when you need to enter a key, you can find a lot of keys on the Internet, others just click on the next step, and finally you will be prompted to upgrade successfully. In this way the problem can be solved. If the above steps still cannot be solved, then you need to modify the information in the registry: change the CommonFiles value in HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Microsoft SQL Server/100/ConfigurationState to 3.

After the modification, follow the above steps (at this time, you can see if you can open it, if not, follow the steps). After taking this step, my problem was solved successfully, and I was able to open SQL server, but the problem followed:

This problem has been encountered before and has been solved for others, which is relatively easy. Still open the configuration tool-- SQL server configuration Manager

Check whether the status of Named Pipes and TCP/IP in the protocol of MSSQLSERVER is enabled, if not, enable it manually.

Then open the SQL Server service, but I have another problem:

There should be a lot of items here, but I don't know why the remote procedure call failed. I have no choice but to search the Internet for information again. Many people have asked similar questions, some said that it can only be reinstalled, and some said that the system can be installed directly. Look at other people are asking questions, and no one can give a solution, to tell you the truth, the heart was half cold at that time. However, with patience, one solution is to uninstall one of the software in SQL server.

With the idea that I would reinstall if I didn't succeed, I unloaded it according to the instructions. The exciting thing is that after uninstalling it, it really succeeded. At this point, check whether SQLserver (MSSQLSERVER) is started, if not, you still need to start it manually.

Finally, the problem was solved satisfactorily. Although I spent a lot of time and energy, I also learned a lot from it.

The solution to the problem that the SQL Server evaluation period has passed is shared here. I hope the above content can be of some help to you and can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.