"Problem" SQL database report invalid data certificate, need to reinstall

Source: Internet
Author: User
Tags management studio sql management studio visual studio 2010

The way things go:


Today open the SQL2014 database, did not run successfully, but give me a popup "invalid data certificate, need to reinstall!" Prompted What the situation. Why, should be the day before the VS caused. Because the upgrade of the vs2017, so the previous things did remove uninstall, may be I have some dependencies on the component to uninstall. Find out the reason is good to run.

Problem Analysis:
Invalid data certificate in this case there are two situations: first, the trial period is over. The second is that the key is invalid.
Database used for a long time we all know that SQL Management Studio relies on the Visual Studio 2010 (standalone) version. So we can go to the C:Program files file (x86) Microsoft Visual Studio 10.0 Common7 IDE and run devenv.exe if you find the same hint of error. Congratulations, you may have the same problem with me. (Note: Reminds me of the day before I uninstalled the VS2010 components and vs2013. Regret is no use or find a way to solve it)

Workaround:

Now that the problem is found, the solution is:

1. First go to Control Panel again: Use Add/Remove Programs to uninstall Visual Studio 2010 (standalone).

2. In Add/Remove Programs, click SQL 2012, and then click Uninstall/Change, and then select Repair. On the screen that selects the instance you want to repair, change the drop-down list
To "repair shared features only" and complete the wizard. This will reinstall the visual Studio 2010 (quarantine) file.

3. Your database may be ready to go here because the vs2010 dependency has been reinstalled. But there is no reason why not, here you need to find the path: C:Program files file (x86) Microsoft Visual Studio 10.0 Common7 IDE DDConfigCA.exe double-click to run, wait for the end.

4. It's good to re-enter the key input key.

"Problem" SQL database report invalid data certificate, need to reinstall

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.