[dba-SQLServer] Problem Finding Database Engine

Dan Waters df.waters at comcast.net
Sun May 15 14:25:44 CDT 2011

Hi Arthur,

I've always connected via TCP/IP.  IIRC, Management Studio is a remote
connection to SQL Server, even on the same PC.  Because only TCP/IP handles
remote requests, that's what must be used to be able to connect with
Management Studio (and probably Visual Studio as well).

Under administrative, go to the Computer Management control panel.  At the
bottom open up Services and Applications.  Then you'll see SQL Server
Configuration Manager.

Now you'll see SQL Server Network Configuration - open that and then open
Protocols for SQL Server.  You'll see the list of protocols - enable TCP/IP
and disable the others.

You may also see SQL Native Client 10.0 Configuration.  Open that and then
open Client Protocols.  Again you'll see the list of protocols - enable
TCP/IP and disable the others.

Hope that works!

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Arthur
Sent: Sunday, May 15, 2011 10:38 AM
To: Discussion concerning MS SQL Server
Subject: [dba-SQLServer] Problem Finding Database Engine

Lately I've been rebuilding my main box. It's running Windows 7 Ultimate
64-bit, and SQL 2008 Enterprise 64-bit.The SQL installation seemed to go
perfectly, but when I try to run Management Studio I am unable to connect. I
get a message saying "a network 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 remove connections. (provider:Named Pipes Provider,
error: 40 - Could not open a connection to SQL Server, error: 2).
This was from trying to connect to Database Engine. However I am able to
connect to Analysis Services (which happens to contain no databases at the
moment, but at least I can connect).

Any idea what might be wrong and how I can fix it?

dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com

More information about the dba-SQLServer mailing list