0

Hi Community,
I installed SP2013 with SP1 on Windows Server 2012 R2. I installed Search Service Application and followed this process to remove the annoying GUID suffix on the DB names (https://technet.microsoft.com/en-us/library/jj219654.aspx). Everything seemed to go well except there is an error every hour in the Event Viewer, Windows Application Log stating:
SQL Database ‘Search_Service_Application_CrawlStoreDB_e97bd6d8327540b0a0cbceb8238b9a18’ on SQL Server instance <ServerName> not found. Additional error information from SQL Server is included below.

Cannot open database “Search_Service_Application_CrawlStoreDB_e97bd6d8327540b0a0cbceb8238b9a18” requested by the login. The login failed.
Login failed for user ‘<Domain>\spFarm’.

I took all the old DB’s offline and from Cent Admin Search Application Topology, All the newly named DB’s are listed. I’ve tried removing orphaned DB’s with the following commands from this discussion (http://blogs.technet.com/b/wbaer/archive/2013/12/18/how-to-rename-s…) but it didn’t seem to do anything.
Get-SPDatabase | Where{$_.Exists -eq $false}
Get-SPDatabase | Where{$_.Exists -eq $false} | ForEach {$_.Delete()}

I must be missing something. Any help to clear this error is appreciated.

Thanks!
Michael

(Visited 24 times, 1 visits today)
Add a Comment