Solved

Permissions for access services on SharePoint

Posted on 2013-01-14
1
584 Views
Last Modified: 2013-01-29
I am trying to publish access database to SharePoint. It publishes OK but I get an error when I try to browse it. This is what I found in ULS logs:

Access Services: An unexpected error occurred. Exception message: Cannot open database "WSS_Content_BlahBlah" requested by the login. The login failed.  Login failed for user 'domain\SP_services'.

The database above is the one where I published the access database. Should I manually give access to this database for SP_services account or there is some other misconfiguration in my environment?
0
Comment
Question by:MisUszatek
[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
1 Comment
 
LVL 15

Accepted Solution

by:
sharepointguru14 earned 400 total points
ID: 38776915
yes sounds like you need to give the SP_services account read access to the database.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

When installing SharePoint 2010 RTM I came across a strange error, I was getting timeouts during the installation. I searched the web and found the best solution to be found here (http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010genera…
Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

751 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