Hi Community,
This error appears very similar to a thread created by Vlad:
need-help-with-user-profile. However, just built a new all in one dev SharePoint 2013 April 2014 CU / SQLServer 2014 farm using SPAutoInstaller. Apart from needing to add Read permissions in AD to Authenticated Users for most the managed service accounts, all seemed to go too well.
Anyway, I tried to create the first Team site and it gets created however you can’t access it because
If I filter on correlation ID in ULS Viewer I see some odd DB related errors
System.Data.SqlClient.SqlException (0x80131904): The EXECUTE permission was denied on the object ‘Admin_GetPartitionProperties’, database ‘AutoSPInstallerDev_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)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
System.Data.SqlClient.SqlException (0x80131904): The EXECUTE permission was denied on the object ‘profile_GetUserProfileData’, database ‘AutoSPInstallerDev_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)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
This is looking like a permission issues – anyone see this before
Daniel
?width=700
