locked
Downloading topology.. QL Network Interfaces, error: 28. RRS feed

  • Question

  • Skype for business FE enterprise server,  

    I get the following error (see blow ) ,  I've tested DB connection Via a "Microsoft Data Link (.udl)"  file .  

    This I can access it VIA another FE but this one I'm having issues . 

     

    Downloading topology...
    System.Management.Automation.CmdletInvocationException: Unable to read the topology. Please verify that the topology data is accessible before trying this procedure again. If you are using Always On with your Central Management Store database, please verify that Always On has been enabled. ---> Microsoft.Rtc.Common.Data.SqlConnectionException: 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: 28 - Server doesn't support requested protocol) ---> 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: SQL Network Interfaces, error: 28 - Server doesn't support requested protocol)
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean withFailover)
       at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover)
       at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
       at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
       at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData)
       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, TaskCompletionSource`1 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(TaskCompletionSource`1 retry)
       at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
       at System.Data.SqlClient.SqlConnection.Open()
       at Microsoft.Rtc.Common.Data.DBCore.PerformSprocContextExecution(SprocContext sprocContext)
       --- End of inner exception stack trace ---
       at Microsoft.Rtc.Management.Store.Sql.XdsSqlConnection.ReadDocItems(ICollection`1 key)
       at Microsoft.Rtc.Management.ScopeFramework.AnchoredXmlReader.Read(ICollection`1 key)
       at Microsoft.Rtc.Management.WritableConfig.AnchoredXmlSchemaCache.get_Item(ScopeClass scopeClass)
       at Microsoft.Rtc.Management.Xds.ManagementConnection.ReadTopologyXml(TypedXml& typedXml, AnchoredXml& anchoredXml)
       at Microsoft.Rtc.Management.Xds.ManagementConnection.ReadTopology(TypedXml& topologyXml, Topology& topology)
       at Microsoft.Rtc.Management.Xds.XdsCmdlet.<ReadTopology>b__5()
       at Microsoft.Rtc.Management.Internal.Utilities.DeImpersonator.<>c__DisplayClass1.<Run>b__0()
       at Microsoft.Rtc.Management.Internal.Utilities.DeImpersonator.Run[T](Boolean dropImpersonation, Func`1 func)
       at Microsoft.Rtc.Management.Xds.XdsCmdlet.ReadTopology()
       --- End of inner exception stack trace ---
       at System.Management.Automation.Internal.PipelineProcessor.SynchronousExecuteEnumerate(Object input, Hashtable errorResults, Boolean enumerate)
       at System.Management.Automation.Runspaces.LocalPipeline.InvokeHelper()
       at System.Management.Automation.Runspaces.LocalPipeline.InvokeThreadProc()
    Failed
    Finished


    • Edited by Dean Maher Wednesday, August 31, 2016 7:53 PM
    Wednesday, August 31, 2016 7:52 PM

Answers

  • Hi Dean,

    By your said, sometimes, it will be successful or fail to download topology, please try to update SQL database by the following command:

    Install-CsDatabase –Update –ConfiguredDatabases –SqlServerFqdn <SQL FQDN> –ExcludeCollocatedStores

    If not, please check if there are any related errors in application log on FE and BE. You could post those logs to us for troubleshooting.

    In addition, I want to confirm again whether you try to disable A/V software and Windows firewall to have a try.

    If there are any questions or issues, please be free to let me know and we will pleasure to help you. If the above suggestion are helpful to you, please make it as answer so that someone who has similar issue could find this thread as soon as possible.

    Best Regard,

    Jim Xu

    Best Regard

    Jim Xu

    TechNet Community Support


    Please remember to mark the replies as an answers if they help and unmark them if they provide no help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    • Proposed as answer by jim-xu Tuesday, September 13, 2016 12:45 AM
    • Marked as answer by jim-xu Friday, September 16, 2016 8:41 AM
    Saturday, September 3, 2016 9:19 AM

All replies

  • this looks like a SQL database connection error. Check the settings on the RCT Service of the active directory for the correct CMS store.

    regards Holger Technical Specialist UC

    Wednesday, August 31, 2016 11:14 PM
  • Hi Dean,

    Welcome to our forum.

    As Holger said and from the error “A network-related or instance-specific error occurred while establishing a connection to SQL Server”, we suggest you do the following steps for troubleshooting:

    1. Make sure connectivity among DC, DNS, Frond-End, Back-End (SQL).
    2. For communicating with Back-End, port should be opened on Frond-End and Back-End:
    3. Which port number should be opened by the following status:
      • If SQL is the default instance, open port 1433 with TCP on FE and BE
      • If SQL is SQL server browser service, open port 1434 with UDP on FE and BE
      • If SQL is named instances, please open a static port on FE and BE

    https://technet.microsoft.com/en-us/library/gg425818(v=ocs.15).aspx

    Then, if the above suggestions could not be worked for you, disable Windows firewall and A/V software on FE and BE to have a try.

    If the issue persist, check if there are any related errors in application log and post them for our troubleshooting.

    If there are any questions or issues, please be free to let me know and we will pleasure to help you.


    Best Regard

    Jim Xu

    TechNet Community Support


    Please remember to mark the replies as an answers if they help and unmark them if they provide no help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Thursday, September 1, 2016 5:23 AM
  • Thanks for the suggestion .  

    Like i same I've tested the connectionsn Via a "Microsoft Data Link (.udl)"  file .  all works as it should . 

    Both ports are open 1434 and 1433 . 

    If I wait , it works but there are times it fails .   Any insight 

    Friday, September 2, 2016 12:27 PM
  • Hi Dean,

    By your said, sometimes, it will be successful or fail to download topology, please try to update SQL database by the following command:

    Install-CsDatabase –Update –ConfiguredDatabases –SqlServerFqdn <SQL FQDN> –ExcludeCollocatedStores

    If not, please check if there are any related errors in application log on FE and BE. You could post those logs to us for troubleshooting.

    In addition, I want to confirm again whether you try to disable A/V software and Windows firewall to have a try.

    If there are any questions or issues, please be free to let me know and we will pleasure to help you. If the above suggestion are helpful to you, please make it as answer so that someone who has similar issue could find this thread as soon as possible.

    Best Regard,

    Jim Xu

    Best Regard

    Jim Xu

    TechNet Community Support


    Please remember to mark the replies as an answers if they help and unmark them if they provide no help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    • Proposed as answer by jim-xu Tuesday, September 13, 2016 12:45 AM
    • Marked as answer by jim-xu Friday, September 16, 2016 8:41 AM
    Saturday, September 3, 2016 9:19 AM