How to publishing access DB to https SharePoint2010 site with self-signed certificate
- by ybbest
If you are having troubles (shown below) when you publish your access database to https SharePoint2010 site with self-signed certificate.
Problem:
First you are getting a warning see the screenshot below:
And then getting the error message:
Solution:
The error “The name of the security certificate is invalid or does not match the name of the site” comes when the ‘common name’ in the certificate doesn’t match the address you provided in browser to access the site. To fix the problem , you need to use script to generate the certificate rather than using the IIS UI, this is because it will default the common name to the server name and you will have the above problem when using that certificate to a different host-name web application.
You can use SelfSSl.exe (IIS 6.0 only), you have to specify common name(cn), for example as:
selfssl.exe /T /N:cn=testsharepoint.com /K:1024
/V:7 /S:1 /P:443
OR you can use makecert (IIS7.0 and above)
makecert -r -pe -n 'CN=my.domain.here' -b 01/01/2000
-e 01/01/2036 -eku 1.3.6.1.5.5.7.3.1 -ss my
-sr localMachine -sky exchange
-sp "Microsoft RSA SChannel Cryptographic Provider" -sy 12
After you have created the certificate, you then need to add that self-signed certificate to your IIS web site and to the Trusted Root Certification Authorities. (To get to there, Key-in Windows + R and Type mmc.exe and add the certifications console)
I have compiled the solution from the questions I have asked in sharepointstackexchange
