Solved

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

Posted on 2010-11-17
19
1,597 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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

770 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