Forum Discussion

CeeVee33's avatar
CeeVee33
Icon for Advocate II rankAdvocate II
1 year ago
Solved

Fabric LH/WH Encryption with PBI Desktop

Hi Experts -   I'm reaching out for a weird action by Fabric Lakehouse & Warehouses.   In SSMS - when I am at home on VPN, I connect to them with "Mandatory" Encryption. when I am in office on...
data warehouse
Mirrored Azure SQL Database
warehouse
  • CeeVee33's avatar
    CeeVee33
    1 year ago

    Hi Anonymous 

     

    It appears that when the firewall rules were set up, they just had TDE rules i.e. Transparent Data Encryption rules related to mssql-db-encrypted . They had to add ssl as well.

     

    Thank you for your help

CeeVee33's avatar
CeeVee33
Icon for Advocate II rankAdvocate II
1 year ago

Good point, SamsonTruong . I should have mentioned what all have I tried.

 

Yes, I've tried connecting using the OneLake Catalog option and Direct SQL Server Option. Both do not work. I get the below error

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi CeeVee33 ,

    Thank you for reaching out to Microsoft fabric community forum. Also thank you SamsonTruong  for your input.

     

    Also thanks for confirming and providing screenshot of the error. The error you’re encountering typically indicates a network-level interruption. This is often caused by firewall rules, proxy settings, or port restrictions within your corporate network environment.

     

    Please check with your IT team to ensure that the necessary ports particularly 1433 (used for SQL connections) and 443 (used for HTTPS/OneLake connections) are open and unrestricted.

     

    Additionally, please confirm that TLS 1.2 or higher is supported and that all required Microsoft root certificates are trusted on your machine. As a quick diagnostic step, you might also try connecting from a different network, such as a personal hotspot, to verify whether the issue is network specific.

     

    Hope this helps. Please reach out for further assistance.

    If this post helps, then please consider to Accept as the solution to help the other members find it more quickly and a kudos would be appreciated.

     

    Thank you.

    • CeeVee33's avatar
      CeeVee33
      Icon for Advocate II rankAdvocate II
      1 year ago

      Thanks Anonymous for the inputs. 

       

      I will have to talk to the IT teams to get this fixed. I am sorry, I think I'll not accept as a solution until IT teams can fix as per your advice.

       

      My biggest concern is same destination gets access by different encryption method on company and non-company networs. So there is something amiss. A destination should be open on only one method.

       

      I'll get back soon.

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi CeeVee33 ,

         

        Thanks for the update, totally understandable that you'd want to check with your IT team first.

        You’re right to be cautious about the same destination using different encryption methods on different networks. That does sound like something worth looking into. Once your IT team has had a chance to review, feel free to reach out. I’m happy to help you.

         

        Thank you, and please keep using the fabric community forum.