Connection Error 111219

Published Jul 22 2019 06:05 AM 2,114 Views
Microsoft

In the Event of you receiving a connection error "Cannot Connect to Server.database.windows.net Error :111219" while attempting to connect to your Azure Data Warehouse you are receiving the exception due to you reaching the Connection Limit specified for Azure Data Warehouse.

 

111219.png

 

The following article contains all relevant information on Azure Data Warehouse capacity limits.

 

https://docs.microsoft.com/en-us/azure/sql-data-warehouse/sql-data-warehouse-service-capacity-limits

 

Azure Data Warehouse allows a maximum of 1024 concurrent open sessions for Large SLO databases and 512 for Service level 500 and below. An Open Session does not constitute as an active query running against the Data Warehouse. 

 

 

%3CLINGO-SUB%20id%3D%22lingo-sub-718051%22%20slang%3D%22en-US%22%3EConnection%20Error%20111219%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-718051%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20the%20Event%20of%20you%20receiving%20a%20connection%20error%20%22Cannot%20Connect%20to%20Server.database.windows.net%20Error%20%3A111219%22%20while%20attempting%20to%20connect%20to%20your%20Azure%20Data%20Warehouse%20you%20are%20receiving%20the%20exception%20due%20to%20you%20reaching%20the%20Connection%20Limit%20specified%20for%20Azure%20Data%20Warehouse.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22111219.png%22%20style%3D%22width%3A%20621px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F120480iE2E96768690CC71F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22111219.png%22%20alt%3D%22111219.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20following%20article%20contains%20all%20relevant%20information%20on%20Azure%20Data%20Warehouse%20capacity%20limits.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsql-data-warehouse%2Fsql-data-warehouse-service-capacity-limits%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Fsql-data-warehouse%2Fsql-data-warehouse-service-capacity-limits%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAzure%20Data%20Warehouse%20allows%20a%20maximum%20of%201024%20concurrent%20open%20sessions%20for%20Large%20SLO%20databases%20and%20512%20for%20Service%20level%20500%20and%20below.%20An%20Open%20Session%20does%20not%20constitute%20as%20an%20active%20query%20running%20against%20the%20Data%20Warehouse.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-718051%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESynapse%20Security%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESynapse%20SQL%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESynapse%20Support%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Jun 22 2020 07:44 AM
Updated by: