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! Dan -----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 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? TIA, Arthur _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com