Reply To: Unable to connect to the Configuration Manager database

Home Forums Callisto as a Service Unable to connect to the Configuration Manager database Reply To: Unable to connect to the Configuration Manager database

#347
CallistoAdmin
Keymaster

This problem ended up being SPN related, so if anyone else comes across this problem, this is an area to investigate.

We can check if this is possibly related to SPN by trying to connect to Callisto on the database server hosting the ConfigMgr DB. Use a web browser on the SQL Server desktop to browse to your Callisto tenant, download and run the controller, if this works then read on…

SQL Server registers itself an SPN in AD against the service account it is running under. If you have changed this account, or moved it form running with a service account to running as local system (which was what had happened in this case) the SPNs will be messed up and will need fixing.

Using a command prompt we can run setspn -L Computername to list the SPNs for our SQL Server. You should see an entry “MSSQLSvc/ServerName.doamin.com:1433” assuming you’re on the default port. If you don’t, we’re starting to get close to the problem.

At this point you should refer to https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/register-a-service-principal-name-for-kerberos-connections

Follow the guidance in this doc and you should be able to browse Callisto from any of your devices as long as user account running the Callisto.exe has read access to your database.