Solved

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

Posted on 2010-11-17
19
1,562 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
 
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
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
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…

707 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now