I had recently migrated my DBs from one volume to another volume due to space concerns, all was successful and life was good 🙂
However the other day, I wanted to create a new application and got the following “unknown” error.
The SMS Provider reported an error connecting to the ConfigMgr site database server. Verify that the SQL Server is online and that ConfigMgr site server computer account is an administrator on the ConfigMgr site database server.
SmsAdminUI.log would something unknown as well.
Description = “CSspConfigurationItem: SQL_ERROR”;
File = “e:\\qfe\\nts\\sms\\siteserver\\sdk_provider\\smsprov\\sspconfigurationitem.cpp”;
SQLMessage = “*** Unknown SQL Error!”;
Basically, after such a DB files location move the SQL TRUSTWORTHY setting gets reset and the dbowner may change.
I hope on the MSSQL and executed the following queries to save the day – well only the creation of new packages.
ALTER DATABASE CM_CIE SET TRUSTWORTHY ON;
EXEC sp_changedbowner ‘sa’;
Then tried to create a new application and voilà…