Hey Guys, I need some help with the User Profile and My Sites. Â Basically, Â when in another Web Application he clicks on : Â “My parameters
Then it gets this: (Unexpected Error)
Here are the strange logs:
System.Data.SqlClient.SqlException (0x80131904): The EXECUTE permission was denied on the object ‘Admin_GetPartitionProperties’, database ‘SP2013_DEV_Service_UPS_Profile’, 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 ‘SP2013_DEV_Service_UPS_Profile’, schema ‘dbo’.’ Â Â Source: ‘.Net SqlClient Data Provider’ Number: 229 State: 5 Class: 14 Procedure: ‘Admin_GetPartitionProperties’ LineNumber: 1 Server: ‘SV_SQL2012\SP2013TEST,58761’
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 ‘SP2013_DEV_Service_UPS_Profile’, schema ‘dbo’.
Error update user’s language settings from provider ‘User Profile User Settings Provider’
?width=750
This post helped me save some time.
In an environment with a single Web Application and Host Named Site Collections, I could not set “My Site settings” settings. The error was: “Could not load the current My Site settings” upon opening the My site settings page.
I had to add the WebAppPool domain user in the SPSearchDBAdmin database role of the Search Service Application Database.
