我使用 Visual Studio 2013 Web Express 创建了一个 MVC Web 应用程序。我已在 Azure 中为我的计算机启用了防火墙规则,并且我可以从本地计算机连接并远程调试我的网站。我让用户 SQL Server 对象资源管理器确认我正在连接到 Azure DB 并且该应用程序运行正常。
但是,当我将应用程序部署到 Azure 时,出现以下连接错误。我已检查以确保该网站具有 Azure DB 作为链接资源。我已使用 FTP 连接到网站并确认 web.config 中的连接字符串正确。
“/”应用程序中的服务器错误。
用户“MyUserName”登录失败。本次会议已被分配
跟踪 ID 为“xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx”。提供这个
当您需要帮助时,可通过 ID 联系客户支持。
描述:执行期间发生未处理的异常。
当前的网络请求。请查看堆栈跟踪以了解更多信息
有关错误及其在代码中的来源的信息。
异常详细信息:System.Data.SqlClient.SqlException:登录失败
对于用户“MyUserName”。此会话已分配一个跟踪 ID:
'xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx'。将此跟踪 ID 提供给
当您需要帮助时的客户支持。
来源错误:
执行期间产生未处理的异常
当前的网络请求。有关原产地和地点的信息
可以使用下面的异常堆栈跟踪来识别异常。
堆栈跟踪:
[SqlException (0x80131904): Login failed for user 'MyUserName'.
This session has been assigned a tracing ID of 'xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx'. Provide this tracing ID to
当您需要帮助时的客户支持。]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
异常、布尔中断连接、操作1 wrapCloseInAction)
+5341687
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +546
System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject
stateObj, Boolean& dataReady) +1693
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject
stateObj) +69
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean
enlistOK) +30
System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo
serverInfo, String newPassword, SecureString newSecurePassword,
Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean
withFailover) +317
System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo
serverInfo, String newPassword, SecureString newSecurePassword,
Boolean redirectedUserInstance, SqlConnectionString connectionOptions,
SqlCredential credential, TimeoutTimer timeout) +892
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer
timeout, SqlConnectionString connectionOptions, SqlCredential
credential, String newPassword, SecureString newSecurePassword,
Boolean redirectedUserInstance) +311
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity
identity, SqlConnectionString connectionOptions, SqlCredential
credential, Object providerInfo, String newPassword, SecureString
newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString
userConnectionOptions, SessionData reconnectSessionData) +646
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions
options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo,
DbConnectionPool pool, DbConnection owningConnection,
DbConnectionOptions userOptions) +278
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool
pool, DbConnection owningObject, DbConnectionOptions options,
DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) +38
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject, DbConnectionOptions userOptions, DbConnectionInternal
oldConnection) +732
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
owningObject, DbConnectionOptions userOptions, DbConnectionInternal
oldConnection) +85
System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection
owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean
allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions
userOptions, DbConnectionInternal& connection) +1057
System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection
owningObject, TaskCompletionSource
1 次重试,DbConnectionOptions
userOptions、DbConnectionInternal& 连接)+78
System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection
拥有连接、任务完成源1 retry, DbConnectionOptions
userOptions, DbConnectionInternal oldConnection, DbConnectionInternal&
connection) +196
System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection
outerConnection, DbConnectionFactory connectionFactory,
TaskCompletionSource
1次重试,DbConnectionOptions userOptions) +146
System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection
外部连接、DbConnectionFactory 连接工厂、
任务完成源1 retry, DbConnectionOptions userOptions) +16
System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource
1
重试)+94
System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1
retry) +110
System.Data.SqlClient.SqlConnection.Open() +96
System.Data.Entity.SqlServer.<>c__DisplayClass2f.<UsingConnection>b__2d()
+73
System.Data.Entity.SqlServer.<>c__DisplayClass1.<Execute>b__0() +10
System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute(Func
1
操作)+189
System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute(操作
操作)+78
System.Data.Entity.SqlServer.SqlProviderServices.UsingConnection(DbConnection
sql连接、操作1 act) +229
System.Data.Entity.SqlServer.SqlProviderServices.UsingMasterConnection(DbConnection
sqlConnection, Action
1 幕)+376
System.Data.Entity.SqlServer.SqlProviderServices.GetDbProviderManifestToken(DbConnection
连接)+201
System.Data.Entity.Core.Common.DbProviderServices.GetProviderManifestToken(DbConnection
连接)+87
[ProviderIncompatibleException: The provider did not return a ProviderManifestToken string.]
System.Data.Entity.Core.Common.DbProviderServices.GetProviderManifestToken(DbConnection
连接)+271
System.Data.Entity.Utilities.DbProviderServicesExtensions.GetProviderManifestTokenChecked(DbProviderServices
providerServices、DbConnection 连接)+33
[ProviderIncompatibleException: An error occurred while getting provider information from the database. This can be caused by Entity
框架使用了不正确的连接字符串。检查内部
详细信息例外并确保连接字符串是
正确的。]
System.Data.Entity.Utilities.DbProviderServicesExtensions.GetProviderManifestTokenChecked(DbProviderServices
提供者服务、DbConnection 连接)+193
System.Data.Entity.Infrastruct.c__DisplayClass1.b__0(元组3
k) +32
System.Collections.Concurrent.ConcurrentDictionary
2.GetOrAdd(TKey
键、功能2 valueFactory) +72
System.Data.Entity.Infrastructure.DefaultManifestTokenResolver.ResolveManifestToken(DbConnection
connection) +180
System.Data.Entity.Utilities.DbConnectionExtensions.GetProviderInfo(DbConnection
connection, DbProviderManifest& providerManifest) +56
System.Data.Entity.DbModelBuilder.Build(DbConnection providerConnection) +43
System.Data.Entity.Internal.LazyInternalContext.CreateModel(LazyInternalContext
internalContext) +62
System.Data.Entity.Internal.RetryLazy
2.GetValue(TInput 输入) +123
System.Data.Entity.Internal.LazyInternalContext.InitializeContext()
+611
System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType(类型
实体类型) +18
System.Data.Entity.Internal.Linq.InternalSet1.Initialize() +53
System.Data.Entity.Internal.Linq.InternalSet
1.get_InternalContext()
+15
系统.数据.实体.基础设施.DbQuery1.System.Linq.IQueryable.get_Provider()
+38
System.Linq.Queryable.Where(IQueryable
1 来源、表达1 predicate) +63
Microsoft.AspNet.Identity.EntityFramework.UserStore
1.FindByNameAsync(字符串
用户名) +616
Microsoft.AspNet.Identity.d__d.MoveNext() +102
System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(任务
任务)+93
System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(任务
任务)+52
Microsoft.AspNet.Identity.d__15.MoveNext() +243
System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(任务
任务)+93
System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(任务
任务)+52
Berkemeyer.DocumentEngine.Web.Controllers.d__2.MoveNext() +244
System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(任务
任务)+93
System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(任务
任务)+52
lambda_method(关闭,任务)+23
System.Threading.Tasks.TaskHelpersExtensions.ThrowIfFaulted(任务任务)
+33
System.Web.Mvc.Async.TaskAsyncActionDescriptor.EndExecute(IAsyncResult
异步结果)+68
System.Web.Mvc.Async.c__DisplayClass34.b__33(IAsyncResult
异步结果)+16
System.Web.Mvc.Async.WrappedAsyncResult1.CallEndDelegate(IAsyncResult
asyncResult) +10
System.Web.Mvc.Async.WrappedAsyncResultBase
1.结束() +49
System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethod(IAsyncResult
异步结果)+32
System.Web.Mvc.Async.AsyncInitationWithFilters.b__3c()
+50
System.Web.Mvc.Async.c__DisplayClass45.b__3e()
+225
System.Web.Mvc.Async.c__DisplayClass30.b__2f(IAsyncResult asyncResult) +10
System.Web.Mvc.Async.WrappedAsyncResult1.CallEndDelegate(IAsyncResult
asyncResult) +10
System.Web.Mvc.Async.WrappedAsyncResultBase
1.结束() +49
System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult
异步结果)+34
System.Web.Mvc.Async.c__DisplayClass28.b__19()
+26
System.Web.Mvc.Async.c__DisplayClass1e.b__1b(IAsyncResult
异步结果)+100
System.Web.Mvc.Async.WrappedAsyncResult1.CallEndDelegate(IAsyncResult
asyncResult) +10
System.Web.Mvc.Async.WrappedAsyncResultBase
1.结束() +49
System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult
异步结果)+27
System.Web.Mvc.Controller.b__1d(IAsyncResult asyncResult,ExecuteCoreState内部状态)+13
System.Web.Mvc.Async.WrappedAsyncVoid1.CallEndDelegate(IAsyncResult
asyncResult) +36
System.Web.Mvc.Async.WrappedAsyncResultBase
1.结束() +54
System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult)+39
System.Web.Mvc.Controller.b__15(IAsyncResult asyncResult,Controller控制器)+12
System.Web.Mvc.Async.WrappedAsyncVoid1.CallEndDelegate(IAsyncResult
asyncResult) +28
System.Web.Mvc.Async.WrappedAsyncResultBase
1.结束() +54
System.Web.Mvc.Controller.EndExecute(IAsyncResult asyncResult)+29
System.Web.Mvc.Controller.System.Web.Mvc.Async.IAsyncController.EndExecute(IAsyncResult
异步结果)+10
System.Web.Mvc.MvcHandler.b__4(IAsyncResult
asyncResult、ProcessRequestState 内部状态)+21
System.Web.Mvc.Async.WrappedAsyncVoid1.CallEndDelegate(IAsyncResult
asyncResult) +36
System.Web.Mvc.Async.WrappedAsyncResultBase
1.结束() +54
System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult)+31
System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult
结果)+9
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
+9651188
System.Web.HttpApplication.ExecuteStep(IExecutionStep 步骤,布尔值&completedSynchronously) +155
版本信息:Microsoft .NET Framework版本:4.0.30319;
ASP.NET版本:4.0.30319.36213