Error "Login Failed For User SA. Reason: Not Associated With a Trusted SQL SQL Server Connection" When Connecting a Database in Store Operations

This article has been archived. It is offered "as is" and will no longer be updated.
TechKnowledge Content
Issue

Error - "Login failed for user sa. Reason: Not associated with a trusted SQL Server connection" occurs when attempting connect to a database in Store Operations..

Resolutions

Resolution 1

1. Launch Enterprise Manager, then right click on the server name and choose Properties.

2. Then click on the Security tab and verify that the radio button under Authentication is set to SQL Server and Windows.

3. If Windows only is chosen, change it to SQL Server and Windows and click OK.

4. Stop and start SQL service to refresh the new settings.

5. Attempt to connect to your database in Store Operations.

Resolution 2

1. Launch Enterprise Manager, then right click on the server name and choose Edit SQL Registration Properties.

2. Find the radio buttons labeled, Use Windows Authentication and Use SQL Server Authentication.

3. Click Use SQL Server Authentication if this option was not previously selected, then click OK.

4. Stop and start SQL service to refresh the new settings.

5. Attempt to connect to your database in Store Operations.

This article was TechKnowledge Document ID: 29965
Properties

Article ID: 869923 - Last Review: 11/02/2013 07:02:00 - Revision: 3.0

  • Microsoft Retail Management System Store Operations 1.3
  • Microsoft Retail Management System Store Operations 1.2
  • kbnosurvey kbarchive kbmbsmigrate KB869923
Feedback