前提:环境都配置得没错,而且用VisualStudio也能连上数据库sq_menglei

但还是出现了连接不上数据库

在建立与服务器的连接时出错。在连接到 SQL Server 2005 时，在默认的设置下 SQL Server 不允许进行远程连接可能会导致此失败。 (provider: 命名管道提供程序, error: 40 - 无法打开到 SQL Server 的连接) 说明: 执行当前 Web 请求期间，出现未处理的异常。请检查堆栈跟踪信息，以了解有关该错误以及代码中导致错误的出处的详细信息。

异常详细信息: System.Data.SqlClient.SqlException: 在建立与服务器的连接时出错。在连接到 SQL Server 2005 时，在默认的设置下 SQL Server 不允许进行远程连接可能会导致此失败。 (provider: 命名管道提供程序, error: 40 - 无法打开到 SQL Server 的连接)

源错误:

执行当前 Web 请求期间生成了未处理的异常。可以使用下面的异常堆栈跟踪信息确定有关异常原因和发生位置的信息。

堆栈跟踪:

[SqlException (0x80131904): 在建立与服务器的连接时出错。在连接到 SQL Server 2005 时，在默认的设置下 SQL Server 不允许进行远程连接可能会导致此失败。 (provider: 命名管道提供程序, error: 40 - 无法打开到 SQL Server 的连接)]  System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +800131  System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +186  System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject) +737554  System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject) +114  System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart) +421  System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +181  System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +173  System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +357  System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +30  System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424  System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66  System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +494  System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82  System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105  System.Data.SqlClient.SqlConnection.Open() +111  System.Data.Linq.SqlClient.SqlConnectionManager.UseConnection(IConnectionUser user) +41  System.Data.Linq.SqlClient.SqlProvider.get_IsSqlCe() +34  System.Data.Linq.SqlClient.SqlProvider.InitializeProviderMode() +18  System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query) +260  System.Data.Linq.DataQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator() +93  System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) +369  System.Linq.Enumerable.ToList(IEnumerable`1 source) +54  ChAlumna.Data.MsSqlDB.NoteTags_Top(Int32 count) +1085 [MethodInvocationException: Invocation of method 'NoteTags_Top' in  ChAlumna.Data.MsSqlDB threw exception System.Data.SqlClient.SqlException : 在建立与服务器的连接时出错。在连接到 SQL Server 2005 时，在默认的设置下 SQL Server 不允许进行远程连接可能会导致此失败。 (provider: 命名管道提供程序, error: 40 - 无法打开到 SQL Server 的连接)]  NVelocity.Runtime.Parser.Node.ASTMethod.Execute(Object o, IInternalContextAdapter context) +1474  NVelocity.Runtime.Parser.Node.ASTReference.Execute(Object o, IInternalContextAdapter context) +584  NVelocity.Runtime.Parser.Node.ASTReference.Value(IInternalContextAdapter context) +19  NVelocity.Runtime.Parser.Node.ASTSetDirective.Render(IInternalContextAdapter context, TextWriter writer) +18  NVelocity.Runtime.Parser.Node.SimpleNode.Render(IInternalContextAdapter context, TextWriter writer) +55  NVelocity.Template.Merge(IContext context, TextWriter writer) +135  Castle.MonoRail.Framework.Views.NVelocity.NVelocityViewEngine.Process(IRailsEngineContext context, Controller controller, String viewName) +311  Castle.MonoRail.Framework.Services.DefaultViewEngineManager.Process(IRailsEngineContext context, Controller controller, String templateName) +178  Castle.MonoRail.Framework.ControllerLifecycleExecutor.ProcessView() +32  Castle.MonoRail.Framework.ControllerLifecycleExecutor.ProcessSelectedAction(IDictionary actionArgs) +625  Castle.MonoRail.Framework.MonoRailHttpHandler.Process(IRailsEngineContext context) +359  Castle.MonoRail.Framework.MonoRailHttpHandler.ProcessRequest(HttpContext context) +18  System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +358  System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

版本信息: Microsoft .NET Framework 版本:2.0.50727.1433; ASP.NET 版本:2.0.50727.1433

<?xml version="1.0"?>
<SystemConfig xmlnssi="http://www.w3.org/2001/XMLSchema-instance" xmlnssd="http://www.w3.org/2001/XMLSchema">
  <ConnectionString>Data Source=192.168.1.93;Initial Catalog=sq_menglei;User ID=sa;Pwd=sa;</ConnectionString>
  <DataBaseType>MsSqlServer</DataBaseType>
  <Path>/</Path>
  <ControllerAssemblies>
    <string>ChAlumna</string>
    <string>TrainController</string>
  </ControllerAssemblies>
</SystemConfig>

192.168.1.93

连接字符串确定正确么,是Express还是企版