Topics > Messages > FAQ ID # 42

FAQ ID # 42
Last Update : 2012/12/06
Print this FAQ

Question / Issue
Error connecting to SQL Server. Login failed.

Answer / Solution

Possible resolutions:

  1. The login is from an untrusted domain and cannot be used with Windows authentication.
    1. Insure computer is a member of the domain
  2. Use SQL Server authentication
    1. Ensure SQL instance is configured in Mixed Mode
      1. Instance/Properties
      2. Security
        1. Server authentication
          1. SQL Server and Windows Athentication mode
    2. Restart SQL server
    3. Enable SA and establish password
    4. Security
      1. Logins/sa/Properties
        1. General
          1. Password
          2. Confirm password
        2. Status
          1. Login: Enable


Direct Link to This FAQ
http://kb.hogandata.com/?f=42

Back to Top