Current Branch version 2006
Site was working just fine before the holidays.
Came back and admin console would not connect.
Look at SMSProv.log and can see the following entries:
Unknown SQL Error! SMS Provider 29/12/2020 16:06:57 16084 (0x3ED4)
~~ Unknown SQL Error! ThreadID : 16084 , DbError: 50000 , Sev: 16~~ SMS Provider 29/12/2020 16:06:57 16084 (0x3ED4)
~~..\sspobjectquery.cpp(5028) : Error waiting for query to return.~ SQL Error: Unknown SQL Error!~~ SMS Provider 29/12/2020 16:06:57 16084 (0x3ED4)
~~Error waiting for query to return. ** Unknown SQL Error!~~* SMS Provider 29/12/2020 16:06:57 16084 (0x3ED4)
Results returned : 0 of -1 SMS Provider 29/12/2020 16:06:57 16084 (0x3ED4)
CSspClassManager::SQL query failed and returned quickly so sleeping for 20 seconds... SMS Provider 29/12/2020 16:06:57 16084 (0x3ED4)
A quick google gives this page and although it isn't exactly the same, it does state the the DB owner should be SA, which it is not.
https://docs.microsoft.com/en-us/troubleshoot/mem/configmgr/cannot-create-software-update-package
What could have caused this error? and how to resolve?
