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? 

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.