How do I configure SQL access to allow the user of Local System that runs the Core Accounting Service (CAS) to connect to the database using Windows Authentication?
Since the release of Equitrac 6.1 the Equitrac Services can be ran under Local System instead of a domain user account.
When making the change to allow the use of Local System, the database permissions need to be set dependent on whether the SQL is local or remote to the CAS.
Using a local SQL database:
If the SQL is local then the account that needs rights to the database is the Local System account: Make this SQL owner (or DataReader/Datawriter access) to the eqcas database.
The account to give SQL owner permissions to the CAS database is the NT Authority\SYSTEM account
Using a remote SQL server:
If the SQL is remote then the Computer account requires ownership to the eqcas database.
This is in the form Domain\Computername$ (don't forget the dollar!). Make this SQL owner (or DataReader/Datawriter access) to the eqcas database and then everything will work perfectly