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!
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!