Errors were encountered during the configuration of the Search Service Application. System.Data.SqlClient.SqlException (0x80131904):Windows NT user or group

Errors were encountered during the configuration of the Search Service Application. System.Data.SqlClient.SqlException (0x80131904):Windows NT user or group

In this post, we will discuss how to resolve the error which comes while configuring search in SharePoint 2013. Recently while configuring search I got the error as:

Errors were encountered during the configuration of the Search Service Application.
System.Data.SqlClient.SqlException (0x80131904): Windows NT user or group ‘ENJOYSHAREPOINT\Administrator’ not found. Check the name again. 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) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Office.Server.Data.SqlSession.ExecuteNonQuery(SqlCommand command) at Microsoft.Office.Server.Data.SqlServerManager.GrantLogin(String user) at Microsoft.Office.Server.Search.Administration.SearchDatabase.GrantAccess(String username, String role) at Microsoft.Office.Server.Search.Administration.SearchDatabase.SynchronizeAccessRules(SearchServiceApplication searchApp) at Microsoft.Office.Server.Search.Administration.SearchServiceApplication.SynchronizeDatabases() at Microsoft.Office.Server.Search.Administration.SearchServiceApplication.Provision() at Microsoft.Office.Server.Search.Administration.SearchAdminUtils.UpdateIgnoreSPUpdatedConcurrencyException(String description, SearchAdminUtilsUpdateDelegate updateDelegate, SearchAdminUtilsRefreshObjectDelegate refreshObjectDelegate) at Microsoft.Office.Server.Search.Administration.SearchConfigWizard.CreateSearchApp() at Microsoft.Office.Server.Search.Administration.SearchConfigWizard.ProvisionSearchServiceApplication() at Microsoft.Office.Server.Search.Administration.SearchConfigurationJobDefinition.ExecuteTimerJob() ClientConnectionId:8bea8a5a-9ee5-40e8-ab30-e6fbdeace717 Error Number:15401,State:1,Class:11
5/7/2016 4:59:07 AM

Also you can read:
– SharePoint 2013 Get current user group collection through Rest api

– SQL Server 2014 step by step installation guide

– Install workflow manager sharepoint 2013 step by step

The problem was there with the user account which I was using. The account which I was using is:

EnjoySharePoint\Administrator

So when I checked in SQL server (Open SQL Server management studio -> Security -> Logins) and see the account was different WIN-PFCP2DGT8DI\Administrator

Errors were encountered during the configuration of the Search Service Application. System.Data.SqlClient.SqlException (0x80131904):Windows NT user or group
Errors were encountered during the configuration of the Search Service Application. System.Data.SqlClient.SqlException (0x80131904):Windows NT user or group

I rename the account in SQL Server (Open SQL Server management studio -> Security -> Logins). Right click on the account and rename account like EnjoySharePoint\Administrator.

Errors were encountered during the configuration of the Search Service Application. System.Data.SqlClient.SqlException (0x80131904):Windows NT user or group
Errors were encountered during the configuration of the Search Service Application. System.Data.SqlClient.SqlException (0x80131904):Windows NT user or group

After that, the error did not come. Hope this will be helpful.


You May Also like the Following SharePoint Online Tutorials:

About Bijay Kumar

I am Bijay from Odisha, India. Currently working in my own venture TSInfo Technologies in Bangalore, India. I am Microsoft Office Servers and Services (SharePoint) MVP (5 times). I works in SharePoint 2016/2013/2010, SharePoint Online Office 365 etc. Check out My MVP Profile.. I also run popular SharePoint web site SharePointSky.com

View all posts by Bijay Kumar →