Skip to Main Content
Spotfire Ideas Portal
Status To be Reviewed
Created by Guest
Created on Dec 22, 2023

Statistica support of Active Directory-based account authentication rather than SQL Local accounts

Instead of using a SQL local account, it is preferable to use Active Directory-based account authentication. A few reasons are:

1. Only Windows AD accounts need to be managed

2. SQL Account will have to have a password reset and the Statistica DSN will have to be updated. This could cause downtime



  • Attach files
  • Guest
    Reply
    |
    Feb 9, 2024

    *undisclosed password

  • Guest
    Reply
    |
    Feb 9, 2024

    Hi,

    I assume you refer to the repository connection?

    I think from a technical perspective this is already possible (I recall customers who did this) but it is simply not recommended since Enterprise users usually have alternative sql clients (Management Studio) and therefore could alter (since the repository connection needs write permissions) the repository content without Statistica audit log entries. This would likely break validation for pharmaceutical customers. Therefore a SQL account with disclosed password is recommended.

    Best regards,
    Sören