asp.net-mvc-3 – 与SQL Server建立连接时发生与网络相关或实例
发布时间:2020-12-15 19:26:34 所属栏目:asp.Net 来源:网络整理
导读:我正在使用ASP.Net MVC 3(实体框架)与Sql server 2008.连接字符串在web.config中很好.但有时我从我的应用程序得到以下异常: System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection
我正在使用ASP.Net MVC 3(实体框架)与Sql server 2008.连接字符串在web.config中很好.但有时我从我的应用程序得到以下异常:
System.Data.SqlClient.SqlException: A network-related 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 remote connections. (provider: Named Pipes Provider,error: 40 - Could not open a connection to SQL Server) Generated: Wed,02 May 2012 05:05:21 GMT System.Data.EntityException: The underlying provider failed on Open. ---> System.Data.SqlClient.SqlException: A network-related 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 remote connections. (provider: Named Pipes Provider,error: 40 - Could not open a connection to SQL Server) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception,Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo,SqlInternalConnectionTds connHandler,Boolean ignoreSniOpenTimeout,Int64 timerExpire,Boolean encrypt,Boolean trustServerCert,Boolean integratedSecurity) at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo,String newPassword,TimeoutTimer timeout,SqlConnection owningObject) at System.Data.SqlClient.SqlInternalConnectionTds.LoginWithFailover(Boolean useFailoverHost,ServerInfo primaryServerInfo,String failoverHost,Boolean redirectedUserInstance,SqlConnection owningObject,SqlConnectionString connectionOptions,TimeoutTimer timeout) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject,Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity,Object providerInfo,Boolean redirectedUserInstance) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options,Object poolGroupProviderInfo,DbConnectionPool pool,DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection,DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection,DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition,DbConnection storeConnectionToOpen,DbConnection originalConnection,String exceptionCode,String attemptedOperation,Boolean& closeStoreConnectionOnFailure) --- End of inner exception stack trace --- at System.Data.EntityClient.EntityConnection.OpenStoreConnectionIf(Boolean openCondition,Boolean& closeStoreConnectionOnFailure) at System.Data.EntityClient.EntityConnection.Open() at System.Data.Objects.ObjectContext.EnsureConnection() at System.Data.Objects.ObjectQuery`1.GetResults(Nullable`1 forMergeOption) at System.Data.Objects.ObjectQuery`1.System.Collections.Generic.IEnumerable<T>.GetEnumerator() at System.Linq.Enumerable.SingleOrDefault[TSource](IEnumerable`1 source) at System.Data.Objects.ELinq.ObjectQueryProvider.<GetElementFunction>b__2[TResult](IEnumerable`1 sequence) at System.Data.Objects.ELinq.ObjectQueryProvider.ExecuteSingle[TResult](IEnumerable`1 query,Expression queryRoot) at System.Data.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute[S](Expression expression) at System.Linq.Queryable.SingleOrDefault[TSource](IQueryable`1 source) at MyApp.Data.UserRepository.GetUserDetails(String username) at MyApp.Core.Services.SiteService.GetUserDetails(String username,Int64 userId) at MyApp.PublicSite.Web.Controllers.BaseController.Initialize(RequestContext requestContext) at System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext) at MyApp.PublicSite.Web.Controllers.BaseController.Execute(RequestContext requestContext) at System.Web.Mvc.ControllerBase.System.Web.Mvc.IController.Execute(RequestContext requestContext) at System.Web.Mvc.MvcHandler.<>c__DisplayClass6.<>c__DisplayClassb.<BeginProcessRequest>b__5() at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass1.<MakeVoidDelegate>b__0() at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass8`1.<BeginSynchronous>b__7(IAsyncResult _) at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`1.End() at System.Web.Mvc.MvcHandler.<>c__DisplayClasse.<EndProcessRequest>b__d() at System.Web.Mvc.SecurityUtil.<GetCallInAppTrustThunk>b__0(Action f) at System.Web.Mvc.SecurityUtil.ProcessInApplicationTrust(Action action) at System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) at System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step,Boolean& completedSynchronously) 连接字符串是: <connectionStrings> <add name="MyAppDBContainer" connectionString="metadata=res://*/MyAppDB.csdl|res://*/MyAppDB.ssdl|res://*/MyAppDB.msl;provider=System.Data.SqlClient;provider connection string="data source=SERVERNAME;initial catalog=MyAppDB;persist security info=True;user id=USERID;Password=PASSWORD;multipleactiveresultsets=True;App=EntityFramework"" providerName="System.Data.EntityClient" /> </connectionStrings> 这个异常是随机发生的,不能每次得到/再生.任何可能的设置,我可能会在这里丢失?请建议. 解决方法
鉴于有时/主要工作(正如你所说):
>连接字符串OK 唯一的原因可能是您的服务器(您的代码)和SQL Server之间的网络丢失,或者SQL Server由于某些原因而关闭. (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |
相关内容
- ASP.NETCore使用AutoFac依赖注入
- asp.net – HttpRequest,HttpWebRequest和WebRequest之间的
- 使用CodeMirror在浏览器中实现编辑器的代码高亮效果
- asp.net-mvc-3 – asp.net mvc 3中的自定义错误页面
- asp.net – 跨安全和非安全共享身份验证
- asp.net-mvc – 可以在桌面应用程序开发中使用MVC设计模式/
- asp.net-mvc – 仅允许来自同一网络服务器的请求的操作
- asp.net-mvc – ASP.NET MVC / IIS 7.5:500内部服务器仅针
- asp.net-mvc – 控制台应用程序CSHTML智能感知和绑定?
- asp.net-mvc – MVC中的模型含义
推荐文章
站长推荐
- asp.net – Http Handler正在iis express中工作,
- asp.net – Transfer-Encoding:Chunked cause 4
- asp.net-mvc – 如何接受电子邮件地址作为路由值
- asp.net signalR 专题—— 第三篇 如何从外部线程
- asp.net-mvc – 具有MasterPage的视图上的多个An
- asp.net – Chrome浏览器不显示HTTP处理程序生成
- 在asp.net中减少ViewState大小的策略
- 是*不*使用asp.net成员资格提供程序一个坏主意?
- asp.net-mvc – SSL握手问题? (当时:网页挂起,
- asp.net-mvc – 使用邮政MVC与布局解析标题作为邮
热点阅读