[dba-SQLServer] Problem Finding Database Engine

Hi Arthur

Have a look at surface area configuration/management and make sure enable remote connections is checked as well as all the required protocols.

Martin

Martin WP Reid
Information Services
The McClay Library
Queen's University of Belfast
10 College Park
Belfast BT7 1LP
Tel : 02890976174
Email : mwp.reid at qub.ac.uk
Sharepoint Training Portal
________________________________________
From: dba-sqlserver-bounces at databaseadvisors.com [dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence [accessd at shaw.ca]
Sent: 15 May 2011 20:10
To: 'Discussion concerning MS SQL Server'
Subject: Re: [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

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