Home > Access2010, SharePoint 2010 > How to publishing access DB to https SharePoint2010 site with self-signed certificate

How to publishing access DB to https SharePoint2010 site with self-signed certificate

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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: