Note to self 
:
Whenever you want to create a SharePoint Site bases on a Web Database template, you have to make sure you did the following:
- Created a Access Service Application
(Central Administration – Manage Service Applications – New – Access Services) - Started the Access Database Service
(Central Administration – Manage Services on Server)
If you don’t you will receive an error like this:
Preparing Site …
Someone has recently made changes to this site and the site is being updated. If the site remains offline for an extended period of time, contact a site owner.
Wait a moment and refresh your browser
Don’t bother waiting…
After you did all of this, open up the SharePoint 2010 Management Shell, and give the following command:
enable-spSessionStateService –DataBaseName <SomeNewDatabaseName>
This will create a session state database and turns on the session state service.
I get an error when creating a Projects web database. The top level menu appears but a Red X apperars with the words “An Error Has Occured. Click here to try again.” When I click there, nothing happens. Any ideas?
I’m having the same problem as AG Bulling. Can’t find a solution anywhere. Any ideas?
Hi Mark,
Hmmm…. I just followed your steps meticulously, and took screenshots to show each step was successfully executed.
However, now I have a bigger problem:
1. The Projects Web Database site template still does NOT work; and
2. I can NOT create ANY site ANYWHERE in my entire server farm.
Any suggestions on how best to back-out of this boondoggle?
Thanks
-MV
When I goto: Central Administration – Manage Service Applications – New –
There isn’t a Access Application Services listed.
I am sure I have Enterprise edition with the correct license entered.
I have checked to make sure enterprise features are turned on.
Although I only have the following services listed in my Central Administration/Manager Services:
Application Registry Service Started Stop
Business Data Connectivity Service Started Stop
Central Administration Started Stop
Claims to Windows Token Service Started Stop
Document Conversions Launcher Service Stopped Start
Document Conversions Load Balancer Service Stopped Start
Microsoft SharePoint Foundation Incoming E-Mail Started Stop
Microsoft SharePoint Foundation Sandboxed Code Service Started Stop
Microsoft SharePoint Foundation Subscription Settings Service Started Stop
Microsoft SharePoint Foundation Web Application Started Stop
Microsoft SharePoint Foundation Workflow Timer Service Started Stop
PerformancePoint Service Started Stop
SharePoint Foundation Search Stopped Start
User Profile Service Started Stop
User Profile Synchronization Service Started Stop
Any ideas?
Mark Vogt – I am having the same issue – were you ever able to get this resolved?
Awesome post, realy helped me a great deal of time……
Mark Vogt and Libiggy this problem is observed when you have multiple Access service applications set and you have already ran the above command a couple of times. The best way to could get this issue resolved is by deleting the additional access service application then detaching the content database of the web application that is hiosting the site, deleting the existing Web application and creating a new one and then reattaching the content database once again.
If this site is production site and is on port 80 then you can create the new web application on the same port number or have a host header if you already had one….
Once provisioned make sure to associate the “Access Service Application” with your web applications default proxy group.
CA -> Application Management -> Configure Service Application Associations.
Click the Application Proxy Group link for your web application.
check “Access Services”
You need to turn on the service, create the service applications (both Access and State) and then create your new site template. The site template has to be created after everything else.
You have to create the services and start them as well as the DB before you create the new site. Once you have all of those up and running then go into SharePoint and create the new site.