Link to home
Start Free TrialLog in
Avatar of rsp_it
rsp_it

asked on

Recently my search function stopped working on my Share Point 2013 environment

Recently my search function stopped working on my Share Point 2013 environment further how to fix this issue please find following error message.

error
The administration component for application Search Service Application failed with exception System.Data.SqlClient.SqlException (0x80131904): Cannot open database "Search_Service_Application_DB_3831518a2de44da4b704d12b184bac35" requested by the login. The login failed.
Login failed for user 'xxx\SharePortalAdmin'.
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
   at System.Data.SqlClient.SqlConnection.Open()
   at Microsoft.Office.Server.Data.SqlSession.OpenConnection()
   at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, CommandBehavior behavior, SqlQueryData monitoringData, Boolean retryForDeadLock)
   at Microsoft.Office.Server.Data.SqlSession.ExecuteReader(SqlCommand command, Boolean retryForDeadLock)
   at Microsoft.Office.Server.Search.Administration.SearchApi.Database.ExecuteReader(SqlCommand command)
   at Microsoft.Office.Server.Search.Administration.SearchApi.GetTopology()
   at Microsoft.Office.Server.Search.Administration.SearchApi.GetAdminComponent()
   at Microsoft.Office.Server.Search.Administration.AdminComponent.Refresh()
   at Microsoft.Office.Server.Search.Administration.SearchComponent.EnsureRefresh()
   at Microsoft.Office.Server.Search.Administration.SearchServiceApplication.get_AdminComponent()
   at Microsoft.Office.Server.Search.Administration.SearchServiceInstance.Synchronize()
ClientConnectionId:ae0590ee-4ec0-41cd-afd0-ba34b26b927e
Error Number:4060,State:1,Class:11
event-error.png
Avatar of Walter Curtis
Walter Curtis
Flag of United States of America image
First step is to confirm that the account you are using for search is not disabled or locked out.

Good luck...
Avatar of rsp_it
rsp_it

ASKER

hi Walter ,

Thanks for your replay i check my share portal admin user accounts disabled , after i enable the account  still i get event viewer getting error message ,still i facing same issue ,

 research feature didn’t work on SharePotral. Please help to troubleshoot and fix the issue please find attached screen shots

Thanks & regrads
Ashok
error-in-central-administration.jpg
Untitled.jpg
event-viwer-error.jpg
Avatar of Walter Curtis
Walter Curtis
Flag of United States of America image
After you enable the accounts, you will need to do an app pool recycle or an IIS reset.

Good luck...
Avatar of rsp_it
rsp_it

ASKER

hi Walter ,

after we reset  app pool recycle still same issue. please find event error message.

Application Server Administration job failed for service instance Microsoft.Office.Server.Search.Administration.SearchServiceInstance (91641131-b4a4-4638-ab19-aa21228e5081).

Reason: The device is not ready.  

Technical Support Details:
System.IO.FileNotFoundException: The device is not ready.  
   at Microsoft.Office.Server.Search.Administration.SearchServiceInstance.Synchronize()
   at Microsoft.Office.Server.Administration.ApplicationServerJob.ProvisionLocalSharedServiceInstances(Boolean isAdministrationServiceJob)
error.jpg
error1.jpg
Avatar of Walter Curtis
Walter Curtis
Flag of United States of America image
Have updates to SharePoint or SQL been performed recently?
Avatar of rsp_it
rsp_it

ASKER

we not do any update recently
Avatar of Walter Curtis
Walter Curtis
Flag of United States of America image
You may have to remove search and install in new.

Good luck...
Avatar of rsp_it
rsp_it

ASKER

if i remove search feature , before we take any backup to restore existing setting .
this changes affect my current share point  ?
Avatar of stacy simpkins
stacy simpkins
Flag of United States of America image
Hi rsp_it, did you get this one fixed?  it's been awhile so figured would ask before rambling on about search.
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.