Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2010-11-17
19
Medium Priority
?
1,686 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
  • 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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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 2000 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
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…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

782 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