Why cannot I start SQL Server after I install the certificate?

Source: Internet
Author: User
Tags mssqlserver
Cause: the certificate cannot be found on SQL Server.

Method:
1. Install SQL Server SP3

SQL Server 2000 Service Pack 3A
Http://download.microsoft.com/download/d/d/e/dde427eb-0296-4eac-a47c-d11a66b03816/chs_sql2ksp3.exe

2. Set the MSSQLServer Service to use the Administrator account (or another administrator account)
My computer -- control panel -- Management Tools -- service -- Right-click MSSQLServer (proxy service: SQLServerAgent) -- properties -- login identity -- select "click to browse" -- select

Select the user you want-enter your administrator password in the password and Confirm Password.
Restart SQL Server

3. log on to the computer with the Administrator account or other Administrator Account (which must be consistent with the account used by the MSSQLServer service) and install the certificate on
MMC-> Certificate-> current user-> under my directory, the SQL server can find the certificate.

4. After completing the above steps, it is best to restart the system
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.