Question / Issue |
|
Error connecting to SQL Server. Login failed. |
Answer / Solution |
|
Possible resolutions:
- The login is from an untrusted domain and cannot be used with Windows authentication.
- Insure computer is a member of the domain
- Use SQL Server authentication
- Ensure SQL instance is configured in Mixed Mode
- Instance/Properties
- Security
- Server authentication
- SQL Server and Windows Athentication mode
- Restart SQL server
- Enable SA and establish password
- Security
- Logins/sa/Properties
- General
- Password
- Confirm password
- Status
- Login: Enable
|