User not able to connect to database

Question

Hi, 
 After providing the security officer rights to user, he tried to configure the Safeguard management center for his windows profile on the safeguard server, however he has received the below error while connecting to the database. 
 Would anyone help here please especially MichaelMcLannahan ? 
 Whether I have to assign the below rights to that user or not? 
 db_datareader 
 db_datawriter 
 public (default)

MichaelMcLannahan · Answer

Good morning - Sorry about the delay, stepped away from the PC for a few days! 
 
 Have you also allowed the user permission to access the domain as well as the security roles? There's two parts to the user assignment, the security role AND the domain/workgroup. Without access to the domain/workgroup it doesn't help if you have the security officer role. 
 1 - Check user is defined in Security Officers - (Note - I imported this user as when I was logged on, so they're "my" users, as in users authorised by me) These are imported users too (user logged onto a SafeGuard machine, it syncs creating their key/cert on the server, I then promote this user to a SO)

2 - Double check you've given this user permission to access the domain/workgroup. Without this step, the first is pointless! 
 
 Users and Computers - Select ROOT of the domain OR workgroup (you will complete this for each and every directory, so if you have workgroups AND domain - do both) 
 Select the Access tab. If this is NOT visible when you've selected the root, double check your own account has enough privileges. If in doubt - use MAINMSO account to log in with. 
 Here I've selected the WG on the left (domain is above it) Select the user and modify the permissions to allow them to access this domain/WG.

If the user is not there - expand the right hand cell to select the user and drag them into the main window. Modify accordingly.

Are they trying to access the domain or a workgroup? 
 Is this user a promoted security officer or a manually created one?