·   Wiki Home
 ·   Wiki Help
 ·   Categories
 ·   Title List
 ·   Uncategorized Pages
 ·   Random Page
 ·   Recent Changes
 ·   RSS
 ·   Atom
 ·   What Links Here

Active Members:



Create or Find Page:


View Login Failed for User Not Associated with a trusted SQL Server Connection


Login Failed for User; Reason: Not Associated with a Trusted SQL Server Connection

Login failed for user "USERNAME-HERE." Reason: Not associated with a  trusted SQL Server connection.

This error most commonly occurs when using SQL authentication, rather than Windows Authentication. There are a few reasons to use SQL authentication rather than Windows:

  • Client is not runnig a domain
  • Network contains PC’s running Windows98
To enable both authentication protocols:

  1. Go to Enterprise Manager.
  2. Right Click on Server Name
  3. Select Properties
  4. Go to Security Tab
  5. Set authentication to SQL Server and Windows