If you receive the following error:
“Microsoft
OLE DB Provider for SQL Server Login failed for user ‘sa’. Reason: Not
associated with a trusted SQL Server connection.”
This is because the SQL server needs to be changed to mixed mode security - not trusted connections only.
To make this change, go to Enterprise Manager, go to the server you are running
Helm on, and right-click - then choose Properties. Go to the Security tab and
you’ll see that Authentication is set to Windows only. Change this to
SQL Server and Windows.
“Microsoft
OLE DB Provider for SQL Server Login failed for user ‘sa’. Reason: Not
associated with a trusted SQL Server connection.”
This is because the SQL server needs to be changed to mixed mode security - not trusted connections only.
To make this change, go to Enterprise Manager, go to the server you are running
Helm on, and right-click - then choose Properties. Go to the Security tab and
you’ll see that Authentication is set to Windows only. Change this to
SQL Server and Windows.