[dba-SQLServer] Problem Finding Database Engine

Hi Arthur:

Ran into a similar issue the other day after installing MS SQL 2008 64bit.
Unlike other MS SQL versions all connect protocols are turned off by
default; no TCP/IP, Named Pipes etc.

I spent the better part of a couple of hours to find the spot to turn
everything on. It may seem something stupid but it sure had me confused for
a bit. I just kept testing with the ODBC manager until the server lit up.

HTH
Jim



-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Arthur
Fuller
Sent: Sunday, May 15, 2011 8: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?

TIA,
Arthur
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com