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
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.
