[dba-SQLServer] Problems finding SQL Server

jwcolby jwcolby at colbyconsulting.com
Mon Jun 6 10:14:28 CDT 2011


Strange, I just received this email this am.

You may need to go into surface configuration and tell it to allow tcp-ip (in addition to or instead 
of named pipes) as well as to allow remote connection.  Google those two things.  I think by 
default, allow remote connection is disabled.

John W. Colby
www.ColbyConsulting.com

On 5/15/2011 11:10 AM, Arthur Fuller wrote:
> 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