安装完SQL SERVER 2005 EXPRESS EDITION 后，又安装了SQL SERVER MANAGEMENT STUDIO EXPRESS , 运行SQL SERVER MANAGEMNET STUDIO EXPRESS来连接本地数据库，但连不上，提示如下：
an error has occurred while establishing a connection to the server,when connecting to sql server 2005,this failure may be caused by the fact that under the default setting sql server does not allow remote connections,(provider:name pipes provider,error;40-could not open a connection to sql server)(microsoft sql server,错误2)请大家指点什么原因，谢谢。
an error has occurred while establishing a connection to the server,when connecting to sql server 2005,this failure may be caused by the fact that under the default setting sql server does not allow remote connections,(provider:name pipes provider,error;40-could not open a connection to sql server)(microsoft sql server,错误2)请大家指点什么原因，谢谢。
2、如果是远端？ 确认是否1433端口打开，另外是否可ping到远端主机
3、登录用户是否有权限
--》》
没明白你怎么安装的，
登录的时候，服务器名称：本机机器名/实例名称 或者是 .
Try