CODEWITHSUNDEEP
azureazure-synapse
Scott Wood
Scott Wood

Reputation: 1127

How to connect to Azure Synapse?

How am I supposed to connect to Azure Synapse? Is there a page on the portal (and where is it)? Is it from Management Studio (and how to I set that up)?

Upvotes: 0

Views: 4143

Answers (3)

Anass Kartit
Anass Kartit

Reputation: 2088

from azure portal click overview open synapse studio:

https://web.azuresynapse.net/en-us/workspaces click the sql pool and then you will see the endpoint and the connection string

enter the connection string in data studio

enter image description here

enter image description here

enter image description here

enter image description here

Upvotes: 3

WaitingForGuacamole
WaitingForGuacamole

Reputation: 4301

You can connect from either SQL Server Management Studio or Azure Data Studio using its dedicated SQL endpoint:

tcp:myazuresynapseinstance.database.azuresynapse.net,1433

The Properties blade in the Portal will display other endpoints.

You can also connect from the Portal - under the "Getting Started" section there is an "Open Synapse Studio" link.

Upvotes: 1

David Browne - Microsoft
David Browne - Microsoft

Reputation: 88852

In the Azure Portal in the Overview you see the "Dedicated SQL Endpoint" and the "Serverless SQL Endpoint", and you can connect to these through SSMS, any other SQL Server client tool, or you can navigate to the "Workspace Web URL" and use the online editor for SQL Scripts there.

Upvotes: 0

Related Questions