Pages

Monday, July 1, 2013

User does not have permission to perform this action in SharePoint


I was trying to configure search service application in SharePoint 2013 and I got the below error message
“Errors were encountered during the configuration of the Search Service Application.
System.Data.Sqlclient.SqlException (0x80131904): User does not have permission to perform this action. at
System.Data.SqlClient.Sqlconnection.On Error(Sql Exception exception. Boolean breakconnection, Actio&1
wrapcloselnAction) at System.Data.Sqlclient.TdsParser.ThrowExceptionAndWarning(TdsParserstateobject stateObj.
Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClientTdsParser.TryRun(Runßehavior
runßehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler,
TdsParserStateObject stateObj. Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader
(SqlDataReader ds, Runßehavior runßehavior, String resetOptionsString) at
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(Commandßehavior cmdBehavior, Runßehavior
runßehavior, Boolean returnStream, Boolean async. 1nt32 timeout, Task& task Boolean asyncWrite) at
System.Data.SqlClient.SqlCom mand.RunExecuteReader(Com mand Behavior cmd Behavior, Run Behavior run Behavior,
Boolean returnStream, String method, TaskCompletionSource’1 completion, 1nt32 timeout Task& task, Boolean
asyncWrite) at System.Data.SqlClient.Sqlcommand.InternalExecuteNonQuery(TaskCom pletionSourc&1 completion.
String methodName, Boolean sendToPipe. 1nt32 timeout Boolean asyncWrite) at
System.Data.SqlClient.SqlCommand.ExecuteNonQueryO at”

Resolution:

                        For fixing the permission issue

 

1.       First we make sure that SharePoint farm account in the SharePoint farm admin groups.

2.       Second make sure that SharePoint farm account in the WSS_WPG groups

3.       Make sure SharePoint admin account in the SQL has the below roles

3a. DB creator

3b. SecurityAdmin

 

      For my case, I have found the SharePoint admin account not added in the SQL security admin role in SQL and once I added the SecurityAdmin role in SQL, I was able to create the Search Service application in SharePoint 2013