[Fix] - Error 1326 Cannot connect to Database Server Error 40

Wikitechy | 953 Views | sql server | 08 Jun 2016

 

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.
  • Windows Firewall is off.

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 1.1 (16 bit)
  • SQL Server 4.2A (16 bit)
  • SQL Server 4.2B (16 bit)
  • SQL Server 4.21a
  • SQL Server 6.0
  • SQL Server 6.5
  • SQL Server 7.0
  • SQL Server 7.0 OLAP Tools
  • SQL Server 2000
  • SQL Server 2000 64-bit Edition
  • SQL Server 2005
  • SQL Server 2008
  • Azure SQL DB
  • SQL Server 2008 R2
  • SQL Server 2012
  • SQL Server 2014
  • SQL Server 2016

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




Workshop

Bug Bounty
IOT Hackathon
Webinar

Join our Community

Advertise