The solution to the problem with SQL Server evaluation period _MSSQL

Source: Internet
Author: User
Tags microsoft sql server mssqlserver

However, when you open the system before knocking, always error, unable to proceed. After checking, it turns out that there is a problem with your own database and cannot connect to the database. Turn on SQL Server2008 and always report this error:

The problem arises, you have to solve it, so start to find information on the Internet. Also really found the relevant solution, followed by step-by-step steps, but still can not repair. This can make me anxious, because the installation of SQL Server is a very troublesome thing, but also to uninstall before the clean, and some people because the uninstall is not clean and reload the system. Fortunately, the solution was found after multiple searches.

Workaround: Open the Configuration Tool--sql Server Installation Center

Select Maintenance--Version upgrade

According to the prompts to operate, when you need to enter a key, you can search the Internet a lot of keys, the other just click the next step on the line, and finally prompted the upgrade success. This solves the problem.
If the above steps are still unresolved, you will need to modify the information in the registry:
The Commonfiles value in hkey_local_machine/software/microsoft/microsoft SQL server/100/configurationstate is changed to 3.

After the modification, and then according to the above steps to operate (at this point you can try to open the first, if you are not able to 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 to point.
Still open Configuration Tool--sql Server Configuration Manager

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

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

There should have been a lot of content here, but we don't know 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, but also some said that the direct loading system. Look at others are asking questions, and no one can give a solution, to tell the truth, at that time the heart is cold half ah. However, it is good to have patience to find a way, one solution is to uninstall a software in SQL Server


I took the hint and unloaded it with the idea of reloading without success. The exciting is that after unloading, and really successful. Then check to see if SQL Server (MSSQLSERVER) is started, if it does not still need to be started manually.

Finally, the problem was solved satisfactorily. Although spent a lot of time and energy, but also learned a lot of things. SQL Server can be said that we often use the software at this stage, each time will not be able to avoid all kinds of problems, encounter problems to solve problems, this is our growth and harvest a process.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.