Knowledgebase
Act.com
Deutsch Français

Error: "Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection." When Attempting to Use SecurityCmdLnApp.exe

  • Updated
You are attempting to execute SecurityCmdLnApp.exe from the command prompt to connect ACT! to the ACT7 SQL Server® instance when you receive the following error message: Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection."

This error can occur if the ACT7 SQL Server has been installed and manually configured to operate in Windows Authentication Mode (Windows® Authentication) instead of Mixed Mode (Windows Authentication and SQL Server Authentication).



You can work around this issue by changing a specific Windows registry key, which will change the Authentication Mode of the ACT7 SQL instance from "Windows Authentication Mode " to "Mixed Mode ". Please use the following steps:

Note: The following information is provided as a convenience. Sage does not provide support for Microsoft® Products. For more information on this topic, go to Microsoft.com.
  1. Stop the ACT7 SQL Server instance:
    1. Click the Windows Start button, and then click Run. The Run dialog box appears.
    2. Type services.msc into the Open field, and then click OK. The Services panel appears.
    3. Locate the SQL Server (ACT7) service.
    4. Right-click the SQL Server (ACT7) service from the Name column, and then click Stop.
  2. Click Start and select Run.
  3. The Run dialog box appears. In the Select field, type regedit.

    4. Caution: We strongly recommend that you back up the system registry before making any changes. Incorrect changes to the registry could result in permanent data loss or corrupted files. Please make sure you modify only the keys specified. For detailed information on backing up the Windows Registry, click the link below:

    Title: How to Backup the Windows® Registry
    Answer ID: How to back up the Windows Registry

  4. Navigate to the following registry key:
      32-bit Computers: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer
      64-bit Computers: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer

    Note: If you have multiple instances of SQL Server installed, the registry key may be different. You can verify by checking each MSSQL.x root key and locating the one which has ACT7 in the Name column on the right pane.



  5. Locate the LoginMode REG_DWORD entry on the right pane.



  6. Right click on the LoginMode entry and select Modify.
    • For the LoginMode value – 1 specifies Windows mode and 2 specifies Mixed mode.
    Change the Decimal value from 1 to 2 and press OK.



  7. Close the Windows Registry.
  8. Restart the ACT7 SQL Server Instance:
    1. Return to the Services panel.
    2. Locate the SQL Server (ACT7) service.
    3. Right-click the SQL Server (ACT7) service from the Name column, and then click Start.
You should now be able to successfully use SecurityCmdLnApp.exe from the command prompt to connect ACT! to the ACT7 SQL Server instance.

If you would like to discuss the content of this article with other ACT! users, please visit the ACT! Online Community. The ACT! Online Community is moderated by Sage and provides the opportunity to give and receive feedback from other ACT! users. To find posts on a specific topic, you can use the Community's built-in search feature.

Related articles

©2020 Act! LLC. All rights reserved. All Act! product and service names mentioned herein are registered trademarks or trademarks of Act! LLC, or its affiliated entities. All other trademarks are property of their respective owners.