I received an error when attempting to add a user with the BES Administration tool. Now it appears in red and the Details state that “This user is not in the database.”
My only options for this user are “Repair User” or “Remove User”.
The repair option gives me a window which states that the user exists in the masthead but not in the database and prompts to enter a password for this user to access the database. This fails with the error: Database error: ‘jsmith’ is not a valid login or you do not have permission.
If I attempt to remove the user I get the error: Unable to find user ‘jsmith’ in users table.
I’ve verified I’m using the site administrator password and the site license.pvk file.
Are you logged into the BES Admin tool with a user with full database privileges? The error you mentioned indicates that you can’t create the database user (which requires special db privileges… you can use the ‘sa’ user to be sure that you have the right privileges).
I am logged on with an ID that has full database access. I was also able to successfully create another ID. Now for the ID that I am having problems a folder which should contain the private keys does not exist.
I worked with rmannik to address this issue. It has to do with SQL 2005’s password complexity rules and the way it’s enforced during SQL login creation when BESAdmin attempts to create users. Repairing the user and typing in a suitably complex password (usually 8+ characters with lower, upper, numbers, and symbols tends to work, though this depends entirely on the rules defined by the organization) works to address the issue. Also note that this behavior is improved in version 7.
I am also getting this error message. I don’t beleive my issue is password complexity becuase, for example, I tried Feb12345678! and it did not work. I’ve looked at the link http://support.bigfix.com/cgi-bin/kbdirect.pl?id=405 but it didn’t help much. My sql account BigFixAdmin and my domain account that I am logging into the box with both have db_owner and db_securityadmin on the master, BFEnterprise, and BESReporting.
It worked 3 weeks ago and nothing has changed that I know of.