Using SQL Authentication
With this method, each server is given a login name and password, and is configured to accept the login names and passwords of all other servers in the deployment. Be aware that the password for this account is stored in clear-text under the HKLM branch of the registry on each server. To authenticate your servers using SQL authentication, follow these steps:
- Choose a single login name (for example, "besserverlogin"), and a single password to be used by all servers in your deployment for inter-server authentication.
- On the Master Server, use SQL Server Management Studio to create a SQL Server login with this name. Choose SQL Server Authentication as the authentication option and specify the password. Change the default database to BFEnterprise and grant it System Admin (sa) authority or the db_owner role for the BFEnterprise and master databases.
- On the Master Server, add the following string values under the
key:
HKLM\Software\BigFix\Enterprise Server\FillDB: (on 64-bit systems, the key is HKLM\Software\Wow6432Node\BigFix\Enterprise Server\FillDB:
ReplicationUser = <login name>
ReplicationPassword = <password>
- Restart the FillDB service.
Note: choose your authentication method on a deployment-wide
basis; you cannot mix domain-authenticated servers with SQL-authenticated
servers. Also, all IBM Endpoint Manager Servers
in your deployment must be running the same version of SQL Server.