Solved

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

Posted on 2010-11-17
19
1,633 Views
Last Modified: 2012-05-10
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
0
Comment
Question by:AccessYourBiz_Com
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 11
  • 8
19 Comments
 
LVL 38

Expert Comment

by:Justin Smith
ID: 34157993
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
 
LVL 3

Author Comment

by:AccessYourBiz_Com
ID: 34158618
It says Sharepoint Server with Enterprise Client Access License
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 34158641
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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 3

Author Comment

by:AccessYourBiz_Com
ID: 34158808
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
 
LVL 38

Accepted Solution

by:
Justin Smith earned 500 total points
ID: 34158826
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
 
LVL 3

Author Comment

by:AccessYourBiz_Com
ID: 34158879
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
 
LVL 38

Expert Comment

by:Justin Smith
ID: 34158905
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
 
LVL 3

Author Comment

by:AccessYourBiz_Com
ID: 34159146
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
 
LVL 3

Author Comment

by:AccessYourBiz_Com
ID: 34159197
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
 
LVL 38

Expert Comment

by:Justin Smith
ID: 34159207
Are you installing on a domain controller?
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 34159231
AFter you enter your key, you are choosing Server Farm - right?
0
 
LVL 3

Author Comment

by:AccessYourBiz_Com
ID: 34159261
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
 
LVL 38

Expert Comment

by:Justin Smith
ID: 34159266
before going further...after you put your key in....did you choose Server Farm or Standalone?
0
 
LVL 3

Author Comment

by:AccessYourBiz_Com
ID: 34159423
During the install options the Advanced button is greyed out. See below
Install Options
Do I need to go back and change something?
0
 
LVL 3

Author Comment

by:AccessYourBiz_Com
ID: 34159549
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
 
LVL 3

Author Comment

by:AccessYourBiz_Com
ID: 34159682
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
 
LVL 3

Author Closing Comment

by:AccessYourBiz_Com
ID: 34159694
Thanks Dude!!! You are the man!!
0
 
LVL 38

Expert Comment

by:Justin Smith
ID: 34160981
glad it worked out
0
 
LVL 3

Author Comment

by:AccessYourBiz_Com
ID: 34165419
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

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question