SQL SERVER – Fix : Error : An error has occurred while establishing a connect to the server. Solution with Images.

While reviewing my my blog search engine terms I find Error 40 is the most common error searched. I have previously wrote blog about how to fix this error here : SQL SERVER – Fix : Error : 40 – could not open a connection to SQL server.

Today I have added few screen shot of that error and their solution to help readers who need additional help to understand my post.

Error Screen:
SQL SERVER - Fix : Error : An error has occurred while establishing a connect to the server. Solution with Images. SQLSERVER_Error40

Solution Part 1: Enable SQL Server Service
SQL SERVER - Fix : Error : An error has occurred while establishing a connect to the server. Solution with Images. SQLSERVER_Error40_solution

Solution Part 2: Enable TCP/IP Protocol
SQL SERVER - Fix : Error : An error has occurred while establishing a connect to the server. Solution with Images. SQLSERVER_Error40_solution2

Reference : Pinal Dave (https://blog.sqlauthority.com)

Computer Network, SQL Error Messages
Previous Post
SQL SERVER – Fix : Error : Msg 9514 Xml data type is not supported in distributed queries. Remote object ‘OPENROWSET’ has xml column(s)
Next Post
SQL SERVER – Retrieve – Select Only Date Part From DateTime – Best Practice

Related Posts

13 Comments. Leave new

  • I’d recently installed SQL Server 2005 Developer Edition after uninstalling SQL Server 2005 Express Edition. To use the implementation and maintenance features of the Developer Editions. After installing SQL Server 2005 Developer Edition my ASP.NET web page created in Visual Studio 2005 will not connect to or write to SQL Server 2005 Developer Edition SQL Managemnt Studio. I get the following error after submitting the information inputed into the website page to be written to the database: “An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified)nill “… I have tried manually changing runat server connection string inside the web.config page in Visual Studio 2005 from SQLEXPRESS to MSSQLServer. I still get the same error. What can I do to have my web application make the connection with the new SQL Server 2005 Developer Edition?

    Reply
  • I am searching on this error because I am getting the error AND my sqlserver is set up as your instructions suggest. Any other clues?

    Reply
  • Dotnet.Newbie
    March 30, 2008 6:18 pm

    Hi
    Suppose i developed a EXE application in vb.net.
    How do i config or run time configuration of sql server connections for every user/client using that exe application.
    Is there any config file or run time config for every exe application ?
    Pls reply in details
    I am getting error every time i run application(Exe) file for every user.

    reply
    regards
    Dotnetnewbie

    Reply
  • Thanks man…worked for me. ;)

    Reply
  • Thanks! It was a part of solution of my problem.

    Reply
  • Hello All,

    i am using windows 2003 enterprise edition operating system and i want to install ms sql server 2005 enterprise edition but i am unable to install properly please provide document how can install step by step ms sql server 2005 enterprise edition
    which is show image of installation step by step)

    Thanks
    Faruque Alam

    Reply
  • @Faruque alam,

    Please refer to this link…

    if the link does not work, then go to google.com and type “sql server 2005 installation steps”

    follow 5th link.

    Hope this helps.
    Imran.

    Reply
  • it is not completed
    it again shows error

    —————————
    SQL Server Configuration Manager
    —————————
    The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details.
    —————————
    OK
    —————————

    Reply
  • error

    —————————
    SQL Server Configuration Manager
    —————————
    The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details.
    —————————
    OK
    —————————
    so its not solved….

    Reply
  • @mayu: please disable VIA everywhere and the try to restart the MSSQLSERVER Service.hopefully it will run.

    Reply
  • Disabling your firewall solved the problem :)

    Reply
    • Hi am karteek muthyala
      Recently i found the same error on one of the sql sever version 2012. When i checked the error..i verified below points and working fine..
      1. SQL services are running fine
      2.No reboot, no restart happenned
      3.Port number and other properties on sql services are absolutely fine.
      4. Not eveb single error message triggered on eventlogs and errorlogs.

      The connection string alsp absolutely fine

      The error triggered only couple of hour’s..during the time appicaiton was not able to connect..at the sam time sql services are running fine but unable to connect from database engine.

      Finally raised the MS case but unfortunately they didn’t find any thing. Finally they concluded like its a generic issue.

      Any one suggest on this?

      Reply
      • Generally Microsoft engineer take memory dump of SQL to understand what is happening in SQL at that time.

Leave a Reply