| ERROR MESSAGE | POSSIBLE CAUSES |
|---|
| Error establishing socket. | - The host name cannot be resolved by the DNS server.
- Database server is not running on the host.
- The database port on the database server is inaccessible because of a firewall
|
| Login failed for user | Username or password is incorrect. |
| Cannot open database requested in login | - The database name is incorrect.
- The user doesn't have privileges to logon to the database
|
| Not Associated with a trusted SQL Server Connection | This occurs typically when Microsoft Sql Server installation is configured to use only Windows authentication and not SQL Server authentication. To solve the problem: Change the Authentication change the authentication mode to sql server authentication. |
| The TCP/IP port is disabled or not accepting connections | - Go to Microsoft SQL Server 2008 or 2005 > , 2012, 2014> Configuration Tools > SQL Server Configuration Manager
- In the SQL Server Configuration Manager select the node SQL Server Network Configuration > Protocols for MSSQLSERVER
- Right-click on the TCP/IP node and select Enable
- Restart the SQL Server (SQLEXPRESS) service (In Control Panel > Adminstrative Tools > Services, right-click on the SQL Server (SQLEXPRESS) service and select Restart)
Also, check that the firewall is not blocking the connection. |