SQL-Server Connection Error.cannot connect to computer\SQLEXPRESS.

Cannot connect to computer\SQLEXPRESS

some time we face this problem while establishing connection to sql-server 2005 or 2008.

The Error code like:

connect to server
cannot connect to computer\SQLEXPRESS.

Additional information:

A network-related or instance-specific error occurred while establishing a conection to SQL Server.
The server was not found or was not accesible.
(provider : Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error :2)

This error only occur when our sql services stopped by any reason.

The solution to resolve this problem just start the sql services on your computer by following ways.

There are two way we can start the sql services.

First open the  Control Panel >>> Administrative Tools >>> Services >>> Select SQL Server (ServerName) — > Start Services

open the control panel of compute.

cannot connect to computer\SQLEXPRESS
cannot connect to computer\SQLEXPRESS

Select Administrative tools option in control panel.

cannot connect to computer\SQLEXPRESS
cannot connect to computer\SQLEXPRESS

In administrative tools we have services option, open the services and find out the server name which is stopped.

cannot connect to computer\SQLEXPRESS
cannot connect to computer\SQLEXPRESS

Below slq figure we show how to start the sql services. just select services and right click on services, select start option to start the stopped services.

cannot connect to computer\SQLEXPRESS
cannot connect to computer\SQLEXPRESS

After doing this just open the SQL Server and you can successfully connected with your server.

 

The another method to start SQL Server Service is:

Click Start >>> Microsoft SQL Server >>> Configuration Tools >> SQL Server Surface Area Configuration –> Start Services

 

Select First option Surface Area Configuration for Services and Connections

cannot connect to computer\SQLEXPRESS
cannot connect to computer\SQLEXPRESS

Select your SQL Server and start the Services……

cannot connect to computer\SQLEXPRESS
cannot connect to computer\SQLEXPRESS

Below figure shows the sql server services has started….

cannot connect to computer\SQLEXPRESS
cannot connect to computer\SQLEXPRESS

I hope this sql server error post will help you to resolve your problem………..

Leave a Reply

Your email address will not be published. Required fields are marked *