CODEWITHSUNDEEP
sql-server
kwram
kwram

Reputation: 11

Error in connecting to sql Server Management Studio2014

I have trouble with connecting to SQL Server. SQL shows me this error whenever I press Connect button:

**TITLE: Connect to Server

Cannot connect to DESKTOP-CAVOQPL. ------------------------------ 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2) The system cannot find the file specified**

Upvotes: 0

Views: 28

Answers (1)

ISHIDA
ISHIDA

Reputation: 4868

The problem was your service was not running. Open Run and type -services.msc and start SQL server. Also Right click on it and go to properties and set startuptype to automatic.

Upvotes: 1

Related Questions