cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Connecting to Data Warehouse with SSMS

How do I connect to a data warehouse using SQL Server Management Studio?  What permissions do I need to do this?

1 REPLY 1
Anonymous
Not applicable

To connect to a warehouse in SSMS, you must first download SSMS (https://learn.microsoft.com/sql/ssms/download-sql-server-management-studio-ssms) and have access to a warehouse item within a premium per capacity workspace with contributor or above permissions. Once you have access, you can connect using the provided T-SQL Connection String for your Data Warehouse.

Helpful resources

Announcements
Welcome to the Synapse (preview) Community

Join Today

Learn more about the Synapse (preview) Community and how you can participate.

Get Help with Synapse in the General Discussion Forum

General Discussion Forum

Ask your questions about Synapse here!

Webinars and Video Gallery

Webinars and Video Gallery

Learn more about Synapse through webinars and short videos.

Carousel_Build_v2

Check out the latest on analytics in Microsoft Fabric!

Microsoft Fabric brings everything you need into one analytics solution.

Top Solution Authors
Top Kudoed Authors