Dan Waters
df.waters at comcast.net
Mon Jun 6 10:07:19 CDT 2011
Hi Arthur, Management Studio is considered to be a Remote application, and remote applications can only connect using TCP/IP, not Named Pipes. TCP/IP is disabled by default for new installations of SQL Server. I sent a thorough description of how to make the change a few weeks ago - it's probably in the archives. Or a search will find the instructions as well. 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:11 AM To: Dejan Sunderic; Joe Michel Subject: [dba-SQLServer] Problems finding SQL Server 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 I can however open _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com