Sharepoint Access Services did not respond, are not enabled or not compatible.

I have a new installation of Microsoft Sharepoint 2010 Enterprise with SQL Server R2 and Windows Server R2 on a, Intel Quad Core 8GB system.
When I attempt to use Microsoft Access 2010 to publish a Web Database I get an error that says.

HTTP://WIN-RPRAMDLF5F:44442:/BLANK/ did not repond. Either the server does not exist, Microsoft Access Services are not enabled on the server, or the server is using an older version of Microsoft Access Services that is not compatible with Access 2010.

Publish error  

Here is a screen shot that shows I have SharePoint Server Enterprise Site features activitated.
Enterprise features enabled
I have also read that I should see ACcess Services when I click "New" under the "Manage Service Applications" option from "Application Management" in CA. However it doesn't show that which may be part of the problem. See screen shots below. Any advice is greatly appreciated.

Notice Access Services is not listed.
New button doesn't show Access Services
LVL 3
AccessYourBiz_ComAsked:
Who is Participating?
 
Justin SmithConnect With a Mentor Sr. System EngineerCommented:
I'm guessing when you installed you chose Advcaned - Web Front End.  This doesn't install all necessary pieces.  You need to reinstall and choose Complete.
0
 
Justin SmithSr. System EngineerCommented:
In central admin if you go to Upgrade and Migration and click on Convert License Type - does it say you have an Enterprise license?
0
 
AccessYourBiz_ComAuthor Commented:
It says Sharepoint Server with Enterprise Client Access License
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
Justin SmithSr. System EngineerCommented:
Did you choose Advanced - Complete when you installed SP?

In the same section in Central Admin, click Enable Enterprise features.  Does it show that they are activated?
0
 
AccessYourBiz_ComAuthor Commented:
I am not sure if I chose "Advanced - Complete" when I installed it. Sorry.

When I clicked on "Enable Enterprise Features" everything was greyed out and the "Enterprise" was selected under the "Use these features" option.
 Enterprise features
0
 
AccessYourBiz_ComAuthor Commented:
Ok, do I have to uninstall first?
When I run setup it only gives me choice to Repair or Remove? How do I re-install?
0
 
Justin SmithSr. System EngineerCommented:
I would run config wizard, disconnect from farm.  then run the install and choose remove.

then run the install again, choose COMPLETE.  run the config wizard and connect to your previous farm.

or you can just run the install and choose remove (without disconnecting first).  you may have to go into sql and manually delete all the databases after.  then run the install again.
0
 
AccessYourBiz_ComAuthor Commented:
ok, I am doing the later now. it's a brand new install so i don't care about anything that is setup. I just hope the product key will work a second time.
0
 
AccessYourBiz_ComAuthor Commented:
I uninstalled it and ran the install again, it asked for the Product key, I entered that, then it asked for installation locations and I accepted defaults. Then the only option was to click "Install Now" button. Does that sound right? I thought I would get other options for Custom install or Complete Install.
0
 
Justin SmithSr. System EngineerCommented:
Are you installing on a domain controller?
0
 
Justin SmithSr. System EngineerCommented:
AFter you enter your key, you are choosing Server Farm - right?
0
 
AccessYourBiz_ComAuthor Commented:
It finished the installation and prompted me for the Configuration Wizard. I started that and chose New Server Farm...then it is asking me about the SQL database so I think I have to delete the old ones first, right?
0
 
Justin SmithSr. System EngineerCommented:
before going further...after you put your key in....did you choose Server Farm or Standalone?
0
 
AccessYourBiz_ComAuthor Commented:
During the install options the Advanced button is greyed out. See below
Install Options
Do I need to go back and change something?
0
 
AccessYourBiz_ComAuthor Commented:
Hey I think the reinstall looks gr8. For the first time I see Access Services in the configuration wizard. I will let you know when I'm done. Thanks so So SO MUCH for your help!!
0
 
AccessYourBiz_ComAuthor Commented:
Yo, ACH1LLES!!! You are the man!!

It works like a charm now! I cannot say enough how much I appreciate your help. I have been working on this for days. It's nice to finally have it configured properly.
0
 
AccessYourBiz_ComAuthor Commented:
Thanks Dude!!! You are the man!!
0
 
Justin SmithSr. System EngineerCommented:
glad it worked out
0
 
AccessYourBiz_ComAuthor Commented:
Hi ach1lles, I just posted a new question if you are interested.
http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/MS-SharePoint/Q_26624426.html
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.