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”
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
