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
InfoPath alternatives for form designing SharePoint

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.

Similar SharePoint 2013 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 →

Leave a Reply