Beyond password issues, what other factors can trigger SQL Server error 18456?

Responsive Ad Header

Question

Grade: Education Subject: Support
Beyond password issues, what other factors can trigger SQL Server error 18456?
Asked by:
78 Viewed 78 Answers

Answer (78)

Best Answer
(313)
Other causes include the SQL Server instance being unavailable (e.g., stopped), network connectivity issues preventing connection to the instance, and the login attempting to connect from an IP address that is blocked by the firewall. Also, an incorrect database name in the connection string can cause the error.