KB Issue

Connecting to SQL Server, using the Management Studio, without the SQL Server Service running, will cause the error:40.

Issue Details

Make sure that SQL Server (InstanceName) is running; if not, you may encounter this error.

Server Related Network Issue

TITLE: Connect to Server

--------------------------

Cannot connect to server-name\instance-name.

--------------------------

ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

--------------------------

BUTTONS:
OK
------------------------------

Recreate Issue

Stop the following services from running.
SQL Server (Instance Name)
SQL Server Agent (Instance Name)

Resolve Issue

Make sure that SQL Server (InstanceName) is running.
Go to

[Control Panel] ? [Administrator Tools] ? [Services]
Scroll Down and [Start] the following Services
SQL Server (InstanceName)
SQL Server Agent (InstanceName)