Resolving The "Login Failed For User 'sa'..." Error.

1. Knowledge Base
2. Troubleshoot
3. General

• Getting Started
  • Basics
  • User Interface
  • Manager windows
  • List windows
  • Transaction windows
  • License and Users
  • Email
  • Getting Help
• Installation
  • Acctivate
  • Database Server
  • Mobile WMS Setup
  • Software Updates
  • Email Setup
  • Remote Access
• Configuration
  • Basics
  • Users
  • Company Info
  • Customers
  • Sales Orders
  • Inventory
  • Custom Fields
  • Email Message Templates
  • Services
• Inventory
  • Products
  • Costing
  • Prices and Units
  • Warehouses and Locations
  • Lot Numbers
  • Inventory Manager
  • Receipts
  • Assemblies
  • Kits and Assortments
  • Landed Cost
  • Transfers
  • Adjustments
  • Counts
  • Reports
• Purchasing
  • Purchase Orders
  • Purchase Order Manager
  • Purchase Invoices
  • Vendors
• Customers
  • Customers
  • Locations
  • Credit & Terms
  • Pricing
  • Broadcast Email
• Sales
  • Orders
  • Sales Order Manager
  • Picking
  • Drop Shipments
  • Sales Tax
  • Packaging
  • Shipping
  • Invoices
  • Payments
  • Credits
• Business Activities
  • Business Activities
  • Business Alerts
• QuickBooks
  • Basics
  • QuickBooks Online
  • QuickBooks Desktop
• Mobile WMS
  • Basics
  • Picking
  • Receiving
  • Counts
  • Assemblies
• Web Store Integrations
  • Basics
  • Templates and Options
• EDI
  • Basics
  • Orders - 850
  • Shipments - 856
  • Invoices - 810
  • Warehouse - 940/945
• Reports
  • Basics
  • Standard Reports
  • Crystal Reports
  • Excel
• Database
  • Basics
  • Backup & Restore
  • Microsoft SQL Server
  • Imports
• Troubleshoot
  • General
  • Installation
  • Inventory
  • Purchasing
  • Sales
  • Shipping
  • QuickBooks Desktop
  • QuickBooks Online
  • Mobile WMS
  • Web Store Integration
  • EDI
  • Reports
  • Database
  • Imports
  • Email
  • Integrations

April 14, 2025 Resolving the "Login failed for user 'sa'..." error.

If you're getting this error when using Acctivate, take these steps.

The following error may occur when starting Acctivate if SQL Server is configured to use Windows Authentication only:

Login failed for user ‘sa’. The user is not associated with a trusted SQL Server connection

The following instructions are for SQL Server 2022, but are very similar in other versions:

1. Run SQL Server Management Studio on the computer running SQL Server (Check this article if you don't see the application on your server.)
2. Make sure the Server name is correct (ie COMPUTERNAME\ACCTIVATE)
3. Select Windows Authentication from the Authentication drop-down, then click Connect to log in to SQL Server
4. Right-click on the server's name (ie COMPUTERNAME\ACCTIVATE) and choose Properties.
5. Click Security in the list on the left.
6. Select SQL Server and Windows Authentication mode on the right and click OK.
7. Click OK to close the warning about restarting SQL Server
8. Right-click on the server's name (ie COMPUTERNAME\ACCTIVATE) and choose Restart and click Yes to restart SQL Server.