Cannot open database “server_search“ requested by the login. The login failed. Login failed for user

Cannot open database “server_search“ requested by the login. The login failed. Login failed for user.  

                            

Issue: While we click the Search service Application or click on Content sources, we see the error” Cannot open database “sever_search“ requested by the login. The login failed. Login failed for user”

Solution: Ensure to check the below settings to get rid of the error.

·        Ensure SQL database and services are running.

·        Ensure The SharePoint Search Account does have the required permissions to the SQL Server database.

·        Ensure the Search Service account has Admin privileges in Search service application. 

                         

·        Ensure there is enough disk space on drives on the DB servers.

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!