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
Today we completely rebuilt our windows 2012R2 Vm from a snapshot. Then reinstalled the SQLServer 2014 .. Apart from it needing sp_install to have additional sysadmin privileges.. the reinstall of Sp2013 Sp1 + April 2014 CU was successful .
Hi Vlad
Back again – tho probably a bit early in Canada.
I have opened one of the ULS yesterday and searched for ystem.Data.SqlClient.SqlException (0x80131904): which occured at 07/22/2014 1709:18.68
In the event viewer there is no direct correlation in either time or error source .. The nearest is the above DCOM which relates to user sp_devAppPool
For various reasons we are rebuilding this dev farm so I will keep you posted as regards the issue. As aside the only thing weird that occurred when first ran the SPAutoInstaller script was a lot of managed accounts inc the appPool accounts, seemed to needed additional permissions on AD: http://leowu70.blogspot.co.uk/2011/06/error-new-spconfigurationdata… . The reason is I kept hitting “The Given Key is not in the Dictionary” errors . Not sure if this has any side effects pertinent to the errors in this post.
the error in the screenshot here above is different^
In the Event viewer for this error > System.Data.SqlClient.SqlException (0x80131904): The EXECUTE permission was denied on the object ‘profile_GetUserProfileData’, database ‘AutoSPInstallerDev_Profile’, schema ‘dbo’.
The error appears under what “User”?
Hey! In the event viewer, look what account has this error and give it “DBO” role in SQL on the AutoSPInstallerDev_Profile database!
