Skype For Business Database Migration
I have moving Skype for Business Database SQL 2014 to 2019.
I backed up all databases and created instance as same name on SQL 2019 and restored databases.
But I receive error message like below.
Error encountered pushing data to RtcXds Blob Store
Push cycle identifier: [skypefrontend.abc.local.2fd688f5-0f3a-407f-bab5-3fa5c3757443]
Error Message: [PushController: XdsPublishItems failed: Could not connect to SQL server : [Exception=System.Data.SqlClient.SqlException (0x80131904): 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource
1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource
1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource1 retry)
at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
at Microsoft.Rtc.Common.Data.DBCore.PerformSprocContextExecution(SprocContext sprocContext)
Cause: Possible issues with back-end database.
Ensure the back-end is functioning correctly.
According to your error messages, This error usually means that the client can't find the SQL Server instance. This issue occurs when at least one of the following problems exists:
- The name of the computer hosting SQL Server is incorrect.
- The instance doesn't resolve the correct IP.
- The TCP port number isn't specified correctly.
For more details about steps to troubleshoot the error, you could refer to:
It has been a while, how is everything going?
If you have any update about this issue, please feel free to post back.
Thank you for your answer. Actualy I see on my everythink is looking good.
The name of the computer hosting SQL Server is incorrect. / thats correct
The instance doesn't resolve the correct IP. / instance resolve right ip
The TCP port number isn't specified correctly. / port is same.
Unfortunalty skype not connect to database.
Could you verify me my steps is right or am I run some powershell script for rebuild database or another.
How did you migrate SQL 2014 to 2019 in SFB Server? Could you share the steps to us?
Sign in to comment