Default SQL Server Login for AVEVA Historian Services

Some components of the AVEVA Historian require a SQL Server login ID to access the master, Runtime, and Holding databases. By default, the historian uses the ArchestrA user account to log on to the Microsoft SQL Server, using Windows authentication.

For Microsoft SQL Server, if the Windows user account is an administrative account on the local computer, it will map the account to the sysadmin fixed server role. (This user will be granted the same permissions as the sa SQL Server user account.) Because the ArchestrA user account is always a local administrative account, it will always have administrative permissions (sysadmin) within the SQL Server.