An unexpected error has occurred when a user clicks on My Settings to access MySites

An unexpected error has occurred when a user clicks on My Settings to access MySites

I was recently hit by an error that when a user clicked on “My Settings” under his username to access his MySite, he had an Unexpected Error!

An unexpected error has occurred My Settings

An unexpected error has occurred My Settings

With nothing in Event Viewer, I checked the ULS log and found this:

System.Data.SqlClient.SqlException (0x80131904): The EXECUTE permission was denied on the object 'Admin_GetPartitionProperties', database 'Profile DB', schema 'dbo'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

SqlError: 'The EXECUTE permission was denied on the object 'Admin_GetPartitionProperties', database 'Profile DB', schema 'dbo'.'    Source: '.Net SqlClient Data Provider' Number: 229 State: 5 Class: 14 Procedure: 'Admin_GetPartitionProperties' LineNumber: 1 Server: SPSQL\SharePoint1

Failure checking user access permissions for User Profile Application Proxy 'User Profile Service Application'. Exception: System.Data.SqlClient.SqlException (0x80131904): The EXECUTE permission was denied on the object 'Admin_GetPartitionProperties', database 'Profile DB', schema 'dbo'.

Following that, I found out that the account running the Web Application Pool where I had the problem didn’t have access to the User Profile Service Application “Profile” Database. I gave it the “SpDataAcces” role like in the following screenshot:


Immediately after, my top suite bar changed! The “My Settings” changed for “About Me” and I also had all the “Newsfeed SkyDrive Sites” elements added. I was then able to access MySite without problems!


That fixed my problem and I hope it will help you fix yours as well!

Leave  a comment and don’t forget to like the page on Facebook here and to follow me on Google+ here and on Twitter here  for the latest news and technical articles on SharePoint.  Also, don’t forget to check out SharePoint Community.Net for more great SharePoint Content

No ratings yet.

Please rate this

 
Comments

I got the same Problem with a fresh sharepoint-installation (through autospinstaller)
Is there a way to set SPDataAccess role for the webapplicationpool-account through the API (which is recommended anyway)
I use GrantAccessToProcessIdentity for ContentDBs but this would not work for ServiceDBs.

How did you make your screenshots? I like them!

I use this tool called Snagit (https://www.techsmith.com/snagit.html ) it’s awesome for screenshots!

Leave a Reply