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:

Solution Part 1: Enable SQL Server Service

Solution Part 2: Enable TCP/IP Protocol

Reference : Pinal Dave (http://blog.SQLAuthority.com)

About these ads

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

  1. 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?

    Like

  2. 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?

    Like

  3. 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

    Like

  4. 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

    Like

  5. 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
    —————————

    Like

  6. 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….

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s