After a SCCM database move to another drive on my server, I consecutively faced errors on my SCCM server:
Message ID: 620
Microsoft SQL Server reported SQL message 50000, severity 16: *** Unknown SQL Error!
This turned out to be a parameter that has to be set in the database.
If you run this query in SQL Server Management Studio on your SCCM database:
select name, collation_name, user_access_desc, is_read_only, state_desc, is_trustworthy_on, is_broker_enabled,is_honor_broker_priority_on from sys.databases
you should get
is_trustworthy_on = 1
is_broker_enabled = 1
is_honor_broker_priority_on = 1