I am the admin on an Azure DevOps Server 2022 instance where we manage about 15 collections. We recently updated to version 2022.2 and have been trying to get the CodeSearch feature working on our collections. I've completed the configuration process through the Configuration Center in the Azure DevOps Server Administration Console, the Code Search extension is installed on all our collections, and indexing was triggered manually through the Powershell scripts available at , in particular, the TriggerCollectionIndexing.ps1 script.

Throughout the process, running this script and others, I have been receiving several warnings and errors through Powershell about "Invoke-Sqlcmd", "SQLSERVER", "SQLPS", and others. I'm not entirely sure what these messages mean.

Currently, CodeSearch works on about half of our collections. The other half generates the following error message whenever I try to search:

But this is only for some of our collections. I've done the same process of manually triggering indexing for CodeSearch on every collection exactly the same way, using the aforementioned script. I'm running out of leads - I've tried uninstalling and reinstalling CodeSearch a few times with varying results - last time, Search didn't throw any errors on this collection when attempting search, but it failed to find hits in the code base that were in fact there, so it was non-functional, despite not generating errors.

I'm just throwing all of this out there, I'm not sure if anyone would be familiar with this sort of behavior of the software, or if any of it sounds like something you've experienced before. Taking a shot in the dark here because I'm quickly running out of ideas on what to try with this. Any ideas at all would be greatly appreciated!

UPDATE: These are the warnings that appear when running the TriggerCollectionIndexing.ps1 script on each of the collections - it's the same for each, regardless of whether Code Search is presently working on that collection or not:

Thank you