Errors were encountered during the configuration of the Search Service ApplicationSystem.Data.SqlCli

%3CLINGO-SUB%20id%3D%22lingo-sub-358759%22%20slang%3D%22en-US%22%3EErrors%20were%20encountered%20during%20the%20configuration%20of%20the%20Search%20Service%20ApplicationSystem.Data.SqlCli%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-358759%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22container-fluid%20nopadding%22%3E%3CH2%20id%3D%22toc-hId-1678073125%22%20id%3D%22toc-hId-1678073125%22%3EERRORS%20WERE%20ENCOUNTERED%20DURING%20THE%20CONFIGURATION%20OF%20THE%20SEARCH%20SERVICE%20APPLICATIONSYSTEM.DATA.SQLCLIENT.SQLEXCEPTION%20(0X80131904)%3A%3C%2FH2%3E%3CDIV%20class%3D%22post-meta%22%3E%3CSPAN%3EBY%26nbsp%3B%3CA%20title%3D%22Posts%20by%20Emadadel2008%22%20href%3D%22http%3A%2F%2Femadadel.com%2Fauthor%2Femadadel2008%2F%22%20target%3D%22_blank%22%20rel%3D%22author%20noopener%20nofollow%20noreferrer%22%3EEMADADEL2008%3C%2FA%3E%2C%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3EMARCH%201%2C%202019%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22post-category%22%3E%3CA%20href%3D%22http%3A%2F%2Femadadel.com%2Fcategory%2Fsharepoint%2F%22%20target%3D%22_blank%22%20rel%3D%22category%20noopener%20tag%20nofollow%20noreferrer%22%3ESHAREPOINT%3C%2FA%3E%2C%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22http%3A%2F%2Femadadel.com%2Fcategory%2Funcategorized%2F%22%20target%3D%22_blank%22%20rel%3D%22category%20noopener%20tag%20nofollow%20noreferrer%22%3EUNCATEGORIZED%3C%2FA%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22inner-section%22%3E%3CDIV%20class%3D%22container-fluid%20nopadding%22%3E%3CIMG%20src%3D%22http%3A%2F%2Femadadel.com%2Fwp-content%2Fuploads%2F2019%2F03%2Ffff.png%22%20border%3D%220%22%20alt%3D%22%22%20width%3D%221019%22%20height%3D%22689%22%20%2F%3E%3CHR%20%2F%3E%3CH2%20id%3D%22toc-hId--874083836%22%20id%3D%22toc-hId--874083836%22%3EWhile%20Creating%20Search%20Service%20Application%20I%20got%20the%20below%20error.%3C%2FH2%3E%3CHR%20%2F%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CIMG%20src%3D%22http%3A%2F%2Femadadel.com%2Fwp-content%2Fuploads%2F2019%2F03%2Ffff.png%22%20border%3D%220%22%20alt%3D%22%22%20%2F%3E%3CHR%20%2F%3E%3CBLOCKQUOTE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EErrors%20were%20encountered%20during%20the%20configuration%20of%20the%20Search%20Service%20Application.%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3ESystem.Data.SqlClient.SqlException%20(0x80131904)%3A%20Windows%20NT%20user%20or%20group%20%E2%80%98RITSOL%5CAdministrator%E2%80%99%20not%20found.%20Check%20the%20name%20again.%20at%20System.Data.SqlClient.SqlConnection.OnError(SqlException%20exception%2C%20Boolean%20breakConnection%2C%20Action1%20wrapCloseInAction)%20at%20System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject%20stateObj%2C%20Boolean%20callerHasConnectionLock%2C%20Boolean%20asyncClose)%20at%20System.Data.SqlClient.TdsParser.TryRun(RunBehavior%20runBehavior%2C%20SqlCommand%20cmdHandler%2C%20SqlDataReader%20dataStream%2C%20BulkCopySimpleResultSet%20bulkCopyHandler%2C%20TdsParserStateObject%20stateObj%2C%20Boolean%26amp%3B%20dataReady)%20at%20System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader%20ds%2C%20RunBehavior%20runBehavior%2C%20String%20resetOptionsString%2C%20Boolean%20isInternal%2C%20Boolean%20forDescribeParameterEncryption)%20at%20System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior%20cmdBehavior%2C%20RunBehavior%20runBehavior%2C%20Boolean%20returnStream%2C%20Boolean%20async%2C%20Int32%20timeout%2C%20Task%26amp%3B%20task%2C%20Boolean%20asyncWrite%2C%20Boolean%20inRetry%2C%20SqlDataReader%20ds%2C%20Boolean%20describeParameterEncryptionRequest)%20at%20System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior%20cmdBehavior%2C%20RunBehavior%20runBehavior%2C%20Boolean%20returnStream%2C%20String%20method%2C%20TaskCompletionSource1%20completion%2C%20Int32%20timeout%2C%20Task%26amp%3B%20task%2C%20Boolean%26amp%3B%20usedCache%2C%20Boolean%20asyncWrite%2C%20Boolean%20inRetry)%20at%20System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource%601%20completion%2C%20String%20methodName%2C%20Boolean%20sendToPipe%2C%20Int32%20timeout%2C%20Boolean%26amp%3B%20usedCache%2C%20Boolean%20asyncWrite%2C%20Boolean%20inRetry)%20at%20System.Data.SqlClient.SqlCommand.ExecuteNonQuery()%20at%20Microsoft.Office.Server.Data.SqlSession.ExecuteNonQuery(SqlCommand%20command%2C%20SqlInfoMessageEventHandler%20handler)%20at%20Microsoft.Office.Server.Data.SqlSession.ExecuteNonQuery(SqlCommand%20command)%20at%20Microsoft.Office.Server.Data.SqlServerManager.GrantLogin(String%20user)%20at%20Microsoft.Office.Server.Search.Administration.SearchDatabase.EnsureServiceAccountExist(SPProcessIdentity%20account)%20at%20Microsoft.Office.Server.Search.Administration.SearchDatabase.SynchronizeAccessRules(SearchServiceApplication%20searchApp)%20at%20Microsoft.Office.Server.Search.Administration.SearchServiceApplication.SynchronizeDatabases()%20at%20Microsoft.Office.Server.Search.Administration.SearchServiceApplication.Provision()%20at%20Microsoft.Office.Server.Search.Administration.SearchAdminUtils.UpdateIgnoreSPUpdatedConcurrencyException(String%20description%2C%20SearchAdminUtilsUpdateDelegate%20updateDelegate%2C%20SearchAdminUtilsRefreshObjectDelegate%20refreshObjectDelegate)%20at%20Microsoft.Office.Server.Search.Administration.SearchConfigWizard.CreateSearchApp()%20at%20Microsoft.Office.Server.Search.Administration.SearchConfigWizard.ProvisionSearchServiceApplication()%20at%20Microsoft.Office.Server.Search.Administration.SearchConfigurationJobDefinition.ExecuteTimerJob()%20ClientConnectionId%3Aed1296ba-ab20-4bb2-8288-de2e036ab81f%20Error%20Number%3A15401%2CState%3A1%2CClass%3A11%3CBR%20%2F%3E2%2F27%2F2019%208%3A05%3A00%20PM%3C%2FP%3E%3C%2FBLOCKQUOTE%3E%3CHR%20%2F%3E%3CH2%20id%3D%22toc-hId-868726499%22%20id%3D%22toc-hId-868726499%22%3EThis%20error%20happen%20when%20you%20install%20SQL%20with%20before%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3Ejoined%20domain%3C%2FSTRONG%3E%3C%2FH2%3E%3CP%20class%3D%22has-medium-font-size%22%3EBefore%20joined%20domain%20my%20account%20is%20%E2%80%9C%3CSTRONG%3EHWC-HEP-3563120%5CAdministrator%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FSTRONG%3E%E2%80%9C%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eand%20after%20it%20will%20be%20%E2%80%9C%3CSTRONG%3ERITSOL%5CAdministrator%3C%2FSTRONG%3E%E2%80%9D%3C%2FP%3E%3CHR%20%2F%3E%3CH2%20id%3D%22toc-hId--1683430462%22%20id%3D%22toc-hId--1683430462%22%3E%3CSTRONG%3EThe%20Solution%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eis%20just%20rename%20the%20account%20with%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSTRONG%3ERITSOL%5CAdministrator%3C%2FSTRONG%3E%3C%2FH2%3E%3CHR%20%2F%3E%3CP%3ELogged%20into%20SQL%20Server%20Management%20Studio%3C%2FP%3E%3CP%3ENavigated%20to%20the%20Security%20folder%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CIMG%20src%3D%22http%3A%2F%2Femadadel.com%2Fwp-content%2Fuploads%2F2019%2F03%2Fccccc.png%22%20border%3D%220%22%20alt%3D%22%22%20%2F%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3ENote%3A%20Also%20make%20sure%20that%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3ERITSOL%5CAdministrator%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Ehas%20the%20following%20roles%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CIMG%20src%3D%22http%3A%2F%2Femadadel.com%2Fwp-content%2Fuploads%2F2019%2F03%2Funtitled31.png%22%20border%3D%220%22%20alt%3D%22%22%20%2F%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20Also%20Checked%20SharepointServerSearch%20status%26nbsp%3B%26nbsp%3Bhas%20been%20started%20in%20Central%20Administration%E2%80%93%26gt%3B%20Services%20on%20Server%20.%3C%2FP%3E%3CIMG%20src%3D%22http%3A%2F%2Femadadel.com%2Fwp-content%2Fuploads%2F2019%2F03%2Funtitled28.png%22%20border%3D%220%22%20alt%3D%22%22%20%2F%3E%3CH2%20id%3D%22toc-hId-59379873%22%20id%3D%22toc-hId-59379873%22%3E%26nbsp%3B%3C%2FH2%3E%3CH2%20id%3D%22toc-hId-1802190208%22%20id%3D%22toc-hId-1802190208%22%3Enow%20we%20can%20create%20%E2%80%9CSearch%20Service%20Application%20%E2%80%9D%20in%20central%20administration%3C%2FH2%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CIMG%20src%3D%22http%3A%2F%2Femadadel.com%2Fwp-content%2Fuploads%2F2019%2F03%2FCapture.png%22%20border%3D%220%22%20alt%3D%22%22%20%2F%3E%3CHR%20%2F%3E%3CH2%20id%3D%22toc-hId--749966753%22%20id%3D%22toc-hId--749966753%22%3Esearch%20service%20application%20was%20created%20successfully%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CIMG%20src%3D%22https%3A%2F%2Fs.w.org%2Fimages%2Fcore%2Femoji%2F11.2.0%2Fsvg%2F1f642.svg%22%20border%3D%220%22%20alt%3D%22%F0%9F%99%82%22%20%2F%3E%3C%2FH2%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

ERRORS WERE ENCOUNTERED DURING THE CONFIGURATION OF THE SEARCH SERVICE APPLICATIONSYSTEM.DATA.SQLCLIENT.SQLEXCEPTION (0X80131904):


While Creating Search Service Application I got the below error.


 


 

Errors were encountered during the configuration of the Search Service Application. 
System.Data.SqlClient.SqlException (0x80131904): Windows NT user or group ‘RITSOL\Administrator’ not found. Check the name again. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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, Boolean isInternal, Boolean forDescribeParameterEncryption) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Office.Server.Data.SqlSession.ExecuteNonQuery(SqlCommand command, SqlInfoMessageEventHandler handler) 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.EnsureServiceAccountExist(SPProcessIdentity account) 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:ed1296ba-ab20-4bb2-8288-de2e036ab81f Error Number:15401,State:1,Class:11
2/27/2019 8:05:00 PM


This error happen when you install SQL with before joined domain

Before joined domain my account is “HWC-HEP-3563120\Administrator  and after it will be “RITSOL\Administrator


The Solution is just rename the account with 
RITSOL\Administrator


Logged into SQL Server Management Studio

Navigated to the Security folder

 

 


Note: Also make sure that RITSOL\Administrator has the following roles

 

 

2. Also Checked SharepointServerSearch status  has been started in Central Administration–> Services on Server .

 

now we can create “Search Service Application ” in central administration

 


search service application was created successfully 🙂

0 Replies