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
Thanks, Vlad for adding the chat and resolution here. This may prove very useful information.
