• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 614
  • Last Modified:

Permissions for access services on SharePoint

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
MisUszatek
Asked:
MisUszatek
1 Solution
 
sharepointguru14Commented:
yes sounds like you need to give the SP_services account read access to the database.
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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now