无法连接SQL SERVER EXPRESS

[wohello]

通过SQL Server Management Studio无法连接SQL SERVER EXPRESS，出现 如下的提示：

Cannot connect to XXX\SQLEXPRESS.

------------------------------
ADDITIONAL INFORMATION:

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 settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

请哪位大侠告知如何解决这个问题啊？

[woko1985]

你连接的服务器名不对，查看你设定的服务器名后再在要连接的服务器地址上自己写上服务器名，他不会自动显示，此种情况一般发生在安装时更改了默认实例名

[csdyyr]

默认安装不允许远程连接。
MS SQL Server 2005-->配置工具-->SQL Server外围应用配置器-->...选择local and remote connections-->using both TCP/IP and named pipes

[wohello]

已经改了，但是还是连不上，
在服务中启动SQLEXPRESS的服务，失败！
提示如下：
Windows could not start the SQL Server (SQLEXPRESS) on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 3417.

[wohello]

我的机器是域登录的，难道SQLEXPRESS无法用域登录的用户来使用么？

[水族杰纶]

default settings SQL Server does not allow remote connections

[wbcn]

如果安装有Visual Studio Team System 版本，请确认SQL Server Express是否安装！

[linux_ch]

this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.