Tips for finding Knowledge Articles

  • - Enter just a few key words related to your question or problem
  • - Add Key words to refine your search as necessary
  • - Do not use punctuation
  • - Search is not case sensitive
  • - Avoid non-descriptive filler words like "how", "the", "what", etc.
  • - If you do not find what you are looking for the first time,reduce the number of key words you enter and try searching again.
  • - Minimum supported Internet Explorer version is IE9
Home  >
article

KB-36651: Changing the Collector Service Account from Windows Authentication to SQL Server Authentication

Auditing and Monitoring Service ,  

25 June,20 at 01:56 PM

Question:  

Is it possible to change the Centrify Collector Service Account to use a SQL Server Authentication instead of the default Windows Authentication (NT Authority\System)?


Answer:  Yes, it is possible.  Below are the steps on how to change the service account of the Collector to be a SQL Server Account.

1. Go to Centrify Audit Manager, expand the Installation, Audit Stores, <Name of the Audit Store>, Databases.

User-added image


2. In the right pane, right click on the the active database, choose properties and go to the advanced tab.

User-added image


3. In the top section "Allowed incoming Collectors", click Add.

User-added image


4. Select the SQL server authentication radio box.

User-added image


5. Either manually add the SQL server account, browse to a SQL Server Account, or create a new SQL account by providing a login name and password. Once that is done click OK and then OK to get back to the advanced tab.

User-added image


6. The newly added SQL Authentication account now shows in the "Allowed Incoming Collectors" section. And then click OK to close the properties window.

User-added image


7. Then go the machine where the Collector is installed and open up the Centrify DirectAudit Collector Control Panel and click on the configure button.

User-added image


8. When it gets to the Authentication Type page, choose the SQL Server Authentication radio button and put in the credential for the SQL Server login account created/set in step 5.

User-added image


9. If you hit test connection, it should verify if everything has been set correctly.

User-added image

10. And go through the rest of the prompts to finish the configuration.  The collector now is using the SQL Server Authentication.

Still have questions? Click here to log a technical support case, or collaborate with your peers in Centrify's Online Community.