Solved

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

Posted on 2010-11-17
19
1,652 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
Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

 
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Suggested Courses

623 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