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

#345
CallistoAdmin
Keymaster

Hi Ross,
Sorry to hear you’re having problems. We can arrange a screenshare to troubleshoot if we need to, but in the first instance, check this:

The user account running the callisto.exe on your desktop has to have SQL read permissions to the ConfigMgr database. We’ve seen a lot of people getting mixed up between SQL permissions and ConfigMgr permissions, these aren’t the same thing.

Callisto, as with other reporting solutions, requires read access to the Configuration Manager database. If you need to grant these permissions to your users, the simplest thing to do is to create a group, in Active Directory, for example “Callisto Users” and grant this group rights to read the SQL DB using SQL Enterprise Manager and running this script, edit the bits in italics to reflect your domain and ConfigMgr DB name.

USE MASTER
CREATE LOGIN [domain\Callisto Users] FROM WINDOWS;

USE CM_DB1
CREATE USER [domain\Callisto Users];
ALTER ROLE db_datareader ADD MEMBER [domain\Callisto Users]

Assuming this isn’t the problem, then we’ll set up a screenshare, I’ll drop you a mail about that now.