Getting started with Access Services —Part1

In SharePoint2010, we can publish the access database to SharePoint and make the access database accessible to users using SharePoint site. Today, I’d like to show you how to publish the access database to SharePoint.

1. Open the access2010 and click New>>Sample templates

2. And then select Issues Web Database (you can select any web database here, I choose the Issues Web Database here)

3. The next step is to publish this access database to SharePoint, you can do so by going to File>>  Save & Publish>> Publish to Access Services

4. Finally, fill in the details of the SharePoint site and site name and publish the database to SharePoint2010.If you need to publish the access database to https SharePoint site, check my previous blog here.

5. You will see the “publish succeeded”

6. Navigate to the site you will see now your Access Database is available online.

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