[Fix] - Error 1326 Cannot connect to Database Server Error 40
Error :
- error : 1326 Cannot connect to Database Server
Scenario :
- The error occurs when trying to connect to a database from a website.
- Cannot connect to Database Server.
Fix 1 :
- Basic checks to be done for this error:
- Named pipe/TCP is enabled.
- Remote connections are allowed.
1.Try to ping your own computer from another computer.
2.Try disabling firewall / antivirus to arrive at successful pinging.
3.Under windows Firewall create an exception for port 1433 as follows:
Go to Control Panel -> Click on Windows Firewall -> Go to exception tab as shown below.
4.Click on Add Port... and enter the port number and name.
5.Click on Add Program -> Add C:\Program Files\Microsoft SQL Server\90\Shared location\SQLBrowser.exe in exception list.
6.Click ok and save the changes.
Fix 2 :
Go to control panel -> Open Local services window -> select MSSQLSERVER service and restart.
( Or )
Go to run -> services.msc -> right click on SQL Server name and select “Restart” as shown below:
Applies to sqlserver version :
- SQL Server 7.0 OLAP Tools
- SQL Server 2000 64-bit Edition
Related Error Tags :
- i get sql error 1326 when connect to other computer
- SQL Server 2008 R2 - Cannot Connect Remotely (Error 1326)
- Resolving could not open a connection to SQL Server errors
- Error (1326) in SQL Server 2008 R2
- How do I get this SQL Server ODBC Connection working?
- SQL Server 2008 - Connection Error 1326
- Sql Error 1326 : Cannot connect to Database server
- SQL SERVER - Fix : Error : 1326 Cannot connect to Database Server
- SQLServer 2008 on Win Server 2008 Can't connect to the server
- sql error 1326 logon failure
- error 1326 sql server 2014