The Auditing and Reporting module (ARM) fails to connect to the SQL Server Express installation with a "the login failed" error


THE INFORMATION IN THIS ARTICLE APPLIES TO:

  • EFT Server, version 6.3 and later

SYMPTOM

The Auditing and Reporting module (ARM) fails to connect to the SQL Server Express installation with a "the login failed" error when the service is configured to use a domain login.

RESOLUTION

Install SQL Server Management Studio Express (or use Management Studio from another location) to add the desired login for the EFT Server database.

MORE INFORMATION

Security is more strict for SQL Server Express 2008. If you want to change the login that the EFT Server service is running as, then you have to install Management Studio Express and use that to add a login for EFTDB.