Forum Discussion

ErnestoRodri's avatar
ErnestoRodri
New Member
2 years ago
Solved

Error code 11062 related to make a conection to an On Premise SQL Database

Hi, I setted up a on premise data gateway and also created 2 conections to a database in SQL (I use SQL Server Express and SSMS).  The conections I created was base on windows and basic authenticatio...
Need Help
  • ErnestoRodri's avatar
    ErnestoRodri
    2 years ago

    It seemed that I had to add a ninbound rule in my firewall to the port 443.

    Now I can connect.

    Thank you for your help.

ErnestoRodri's avatar
ErnestoRodri
New Member
2 years ago

Hi FabianSchut , I'm just trying to practice and learn Fabric. I don't know if my on-premise server is allowed to got to other internet addresses (how can I check it?), my server is my own computer where I installed a SQL Server Express. I have a test DB and I was trying to create a pipeline to connect that DB and copy the data in a datalakehouse.

FabianSchut's avatar
FabianSchut
Icon for Solution Sage rankSolution Sage
2 years ago

Since it is your own server, I assume that the server is allowed to go to other internet addresses. Could you share some more information about the connection settings you are setting up?

  • ErnestoRodri's avatar
    ErnestoRodri
    New Member
    2 years ago

    It seemed that I had to add a ninbound rule in my firewall to the port 443.

    Now I can connect.

    Thank you for your help.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi ErnestoRodri,

      I'm glad to hear that your problem was resolved. I'm sure it will help other users on the forum.

      Can you mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

       

       

      Best Regards

      Yilong Zhou