Forum Discussion

surajpardeshi's avatar
surajpardeshi
Frequent Visitor
2 years ago
Solved

Unable To connect MS Fabric Data Warehouse using SSMS

Hi,   I am using 60 days trail plan of Microsoft Fabric and in it I have created a new Data Warehouse and I want to access it using SQL Server Management Studio (SSMS) tool present on my VM. When ...
data warehouse
  • surajpardeshi's avatar
    surajpardeshi
    2 years ago

    Hi @AndyDDC and Yang, 

     

    I checked with our IT and Networking team and got to know that the IP range needs to be added and whitelisted in our VPN network.  

    They have added the below range, which they think is bit risky becuase it involes entire range and when they tried the specific range it didn't work as per them. 

     

    NetRange:       40.74.0.0 - 40.125.127.255
    CIDR:           40.125.0.0/17

     

    Post adding the above range, i was able to access the data warehouse thorugh SSMS. 

    Generally, what should be whitelisted as per MS guidelines? 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi surajpardeshi ,

 

I can't find your authentication method. I used MFA authentication when I tested it and it worked well.


 

Regarding your error, you can consider the following points:

 

Make sure the server name and port number are correct. In my VM, I configured inbound rules in the following interface:

 

Open SQL Server Configuration Manager and make sure TCP/IP and named pipes are enabled.

 

Make sure the SQL Server Browser service is running. This service helps resolve the port number of the named instance.

 

Restart the SQL Server service.

 

Make sure the username you entered is in the correct format.

 

Please contact me after trying the above steps.

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

  • surajpardeshi's avatar
    surajpardeshi
    Frequent Visitor
    2 years ago

    Hi Yang, 

     

    I was using standalone SSMS tool v19.1 and I didn't had Microsoft Entra MFA authentication type, I installed latest version of SSMS i.e. V20.2 and it has Microsoft Entra MFA authentication type. I tried with suggested authentication type but still I am getting the error. 

     

    • AndyDDC's avatar
      AndyDDC
      Icon for Most Valuable Professional rankMost Valuable Professional
      2 years ago

      Hi surajpardeshi if you're connecting from an Azure VM, does the VM allow outbound traffic?  Have you configured an outbound rule on the VM to allow port 1433.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi surajpardeshi ,

       

      Thanks for the reply from AndyDDC .

       

      username is used as shown in the screenshot below.

       

      Best Regards,
      Yang
      Community Support Team

       

      If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
      If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!