How to fix connection error after installing Sql server

Question

I had the following error message in Visual Studio when I am trying to connect to SQL Server:

I got this message

> 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)

This occurred when I was trying to setup SQL Management studio, but as always I face problems setting it up. Now I can't use either of them.

How do I fix this up?

Hm. Bad Pizza when programming. See, I program and I had a pizza that tasted terribly. Why? Same with your thing - the error CLEARLY points to "visual studio has ZERO relevance". Please spend more than 1 second thinking of a subject line. — TomTom, Jan 06 '13 at 10:34

score 2 · Answer 1 · answered Jan 04 '13 at 23:54

2

Usually that means you either typed the server name incorrectly, or that the server does not have the SQL Server service running. Check those two things.

answered Jan 04 '13 at 23:54

Joe Enos

39,478
11
80
136

1

Or that the firewall blocks such connections. – TomTom Jan 06 '13 at 10:33

score 2 · Answer 2 · edited May 23 '17 at 11:59

2

This is a quite common issue. Take a look at existing answers on Stack Overflow, for example, How do I fix the error 'Named Pipes Provider, error 40 - Could not open a connection to' SQL Server'?.

edited May 23 '17 at 11:59

Community

1
1

answered Jan 04 '13 at 23:55

Sebastian K

6,235
1
43
67

How to fix connection error after installing Sql server

2 Answers2