[dba-SQLServer] Problems finding SQL Server

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






More information about the dba-SQLServer mailing list