sql - SQL - DTS 向导导出数据失败
问题描述
我的帐户可以连接到 SQL 数据库并运行查询。但是当我想通过导入/导出向导 (DTSWizard) 导出它的数据时，它给了我
无法检索表列表。
- - - - - - - - - - - - - - - 附加信息：
由于打开服务器连接延迟而无法完成登录过程（Microsoft SQL Server Native Client 11.0）
更多信息：
====================================
无法检索表列表。（SQL Server 导入和导出向导）
====================================
由于打开服务器连接延迟而无法完成登录过程（Microsoft SQL Server Native Client 11.0）
------------------------------ 节目地点：
在 System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) 在 System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions 选项, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) 在 System.Data.ProviderBase .DbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) 在 System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions) 在 System.Data.ProviderBase。 DbConnectionFactory.TryGetConnection(DbConnection owningConnection,TaskCompletionSource'1 重试，DbConnectionOptions userOptions，DbConnectionInternal oldConnection，DbConnectionInternal& 连接）在 System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal（DbConnection outerConnection，DbConnectionFactory connectionFactory，TaskCompletionSource'1 重试，DbConnectionOptions userOptions）在 System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection（ DbConnection outerConnection，DbConnectionFactory connectionFactory，TaskCompletionSource'1 重试，DbConnectionOptions userOptions) 在 System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) 在 System.Data.OleDb.OleDbConnection.Open() 在 Microsoft.SqlServer.Dts。 DtsWizard.SQLServerForm.LoadDatabasesList()在 System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource'1 重试, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) 处重试, DbConnectionOptions userOptions) 在 System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection , DbConnectionFactory connectionFactory, TaskCompletionSource'1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OleDb.OleDbConnection.Open() at Microsoft.SqlServer.Dts.DtsWizard。 SQLServerForm.LoadDatabasesList()在 System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource'1 重试, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) 处重试, DbConnectionOptions userOptions) 在 System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection , DbConnectionFactory connectionFactory, TaskCompletionSource'1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OleDb.OleDbConnection.Open() at Microsoft.SqlServer.Dts.DtsWizard。 SQLServerForm.LoadDatabasesList()DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource'1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource' 1 次重试，DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OleDb.OleDbConnection.Open() at Microsoft.SqlServer.Dts.DtsWizard.SQLServerForm.LoadDatabasesList()DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource'1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource' 1 次重试，DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OleDb.OleDbConnection.Open() at Microsoft.SqlServer.Dts.DtsWizard.SQLServerForm.LoadDatabasesList()Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource'1 retry, DbConnectionOptions userOptions) 在 System.Data.ProviderBase.DbConnectionClosed. TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource'1 retry, DbConnectionOptions userOptions) 在 System。 Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) 在 Microsoft.SqlServer.Dts.DtsWizard.SQLServerForm.LoadDatabasesList() System.Data.OleDb.OleDbConnection.Open()Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource'1 retry, DbConnectionOptions userOptions) 在 System.Data.ProviderBase.DbConnectionClosed. TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource'1 retry, DbConnectionOptions userOptions) 在 System。 Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) 在 Microsoft.SqlServer.Dts.DtsWizard.SQLServerForm.LoadDatabasesList() System.Data.OleDb.OleDbConnection.Open()DbConnectionOptions userOptions) 在 System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) 在 System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource'1 retry, DbConnectionOptions userOptions) 在 System.Data。 Microsoft.SqlServer.Dts.DtsWizard.SQLServerForm.LoadDatabasesList() 上的 OleDb.OleDbConnection.Open()DbConnectionOptions userOptions) 在 System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) 在 System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource'1 retry, DbConnectionOptions userOptions) 在 System.Data。 Microsoft.SqlServer.Dts.DtsWizard.SQLServerForm.LoadDatabasesList() 上的 OleDb.OleDbConnection.Open()DbConnectionFactory connectionFactory) 在 System.Data.OleDb.OleDbConnection.Open() 在 Microsoft.SqlServer.Dts.DtsWizard.SQLServerForm.LoadDatabasesList()DbConnectionFactory connectionFactory) 在 System.Data.OleDb.OleDbConnection.Open() 在 Microsoft.SqlServer.Dts.DtsWizard.SQLServerForm.LoadDatabasesList()
请注意：
- 直到两周前它才能无缝运行
- 帐户访问没有发生变化
- 我可以使用另一个帐户（通过 DTSWizard）从同一个数据库中导出数据
- 我可以在其他数据库上使用此帐户导出数据（通过 DTSWizard）
有没有人见过这样的事情，你能帮我解决这个问题吗？
更新：刚刚得知这个数据库服务器实际上是主服务器的监听器。尝试了主服务器本身，我可以轻松运行向导，完全没有问题。我仍然有兴趣找出导致此问题的原因，并将感谢任何帮助。