SkypeToTeams: Move-csUser Failed, A network-related or instance-specific error occurred while establishing a connection to SQL Server


When trying to move A Skype user to Teams we encountered this error

PS C:\> $SFBUser= »SipuserAddress »
PS C:\> $url=https://admin0e.online.lync.com/HostedMigration/hostedmigrationService.svc
PS C:\> Move-CsUser -Identity $SFBuser -Target sipfed.online.lync.com -MoveToTeams -Credential $Mycreds -HostedMigrationOverrideUrl $url -Proxypool PROXYPOOLFQDN -DomainController DOMAINCONTROLERFQDN -BypassAudioConferencingCheck -Confirm:$false -BypassEnterpriseVoiceCheck
Move-CsUser : 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 line:1 char:1 + Move-CsUser -Identity $SFBuser -Target sipfed.online.lync.com -MoveTo …

From the same server (Windows Server 2016 Standard Build 10.0.1493 build 14393) we have checked the connection to the CMS with a telnet 1433 successfully

The skype 2015 CMS SQL Server Is running Sql Server 2012 Failover Cluster Instance. Service Pack 4 For Microsoft Sql Browser (KB4018073)

When I look at the Conversation here what I can see: TDS:Prelogin, Version = Undefined TDS version(0x74000004) And TDS:Response, Version = Undefined TDS version(0x74000004)

When a client connects to SQL Server, as part of the logon process the version of the TDS protocol is negotiated. If a SQL client with version 2008 is connecting to a SQL Server running 2016 for example; the 2008 TDS version will be used. The following TSQL can be used to determine the SQL client version. Note: This is valid to SQL 2017.

SELECT CASE CONVERT(VARBINARY(9), protocol_version)

WHEN 0x07000000 THEN ‘SQL 7.0’

WHEN 0x07010000 THEN ‘SQL 2000’  

WHEN 0x71000001 THEN ‘SQL 2000 SP1’

WHEN 0x72090002 THEN ‘SQL 2005’

WHEN 0x730A0003 THEN ‘SQL 2008’

WHEN 0x730B0003 THEN ‘SQL 2008’

WHEN 0x74000004 THEN ‘SQL 2012’

WHEN 0x74000004 THEN ‘SQL 2014’

WHEN 0x74000004 THEN ‘SQL 2016’

WHEN 0x74000004 THEN ‘SQL 2017’

ELSE CONVERT(VARCHAR(20), protocol_version)

END AS [TDS Version], *

FROM   sys.dm_exec_connections

 

Additional Link :

https://social.technet.microsoft.com/Forums/lync/en-US/d638b91f-c8f5-41d6-8eab-a798ebf18b13/movecsuser-with-parameter-quotmovetoteamsquot-fails?forum=sfbfr

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/dd772047-fd73-4097-8db5-fe936ef693c4/cant-connect-to-alwayson-availability-group-in-ssis?forum=sqlintegrationservices

 

 

 

 

Votre commentaire

Choisissez une méthode de connexion pour poster votre commentaire:

Logo WordPress.com

Vous commentez à l’aide de votre compte WordPress.com. Déconnexion /  Changer )

Photo Google

Vous commentez à l’aide de votre compte Google. Déconnexion /  Changer )

Image Twitter

Vous commentez à l’aide de votre compte Twitter. Déconnexion /  Changer )

Photo Facebook

Vous commentez à l’aide de votre compte Facebook. Déconnexion /  Changer )

Connexion à %s