Automatically Load Server on Azure Data Studio on Start Up

ZAS 1

I have database on a cloud server. I use Azure Data Studios to make queries. However, every time I open Azure Data Studios, my server is disconnected. I need to click on it to connect. And whenever I run a query, I apparently have to connect it again. Is there a way to have it automatically connected when I open the program?

User's image

Erin Stellato 651 Reputation points Microsoft Employee

2023-03-30T16:27:28.79+00:00

Hi @ZAS - yes, the default behavior when you open Azure Data Studio is that connections and queries are not automatically re-established. If this is an option you would like to see added, please submit a feature request here: https://github.com/microsoft/azuredatastudio/issues If you can raise awareness and have folks upvote it and/or add their own comments, that helps us understand interest in this functionality. Thanks!
Ak4495 0 Reputation points

2024-03-28T10:26:40.8066667+00:00

Issue created:
https://github.com/microsoft/azuredatastudio/issues/25549#issue-2212845732

2 answers

GeethaThatipatri-MSFT 29,477 Reputation points Microsoft Employee

2023-03-30T15:05:07.02+00:00

@ZAS Welcome to the Microsoft Q&A platform and thanks for using Azure Services.

The Bestway you can do this is to remember the password and whenever you open Azure Data Studio, you can select the saved connection from the Connection drop-down menu in the Object Explorer pane to automatically connect to your server.

However, when the server is connected on running the new query it does not ask for a connection, for every query execution are you reconnecting?

Are you expecting to auto-connect to the server without selecting which server when you open Azure data studio? if yes then no unfortunately that is not possible.

Regards

Geetha
Please sign in to rate this answer.
GeethaThatipatri-MSFT 29,477 Reputation points Microsoft Employee

2023-04-10T15:28:28.0066667+00:00

@ZAS We haven't heard back from you. Just wanted to check if you had the chance to check my response

David-3300 0 Reputation points

2023-08-17T07:36:10.26+00:00

Is there a way to configure a workspace to automatically connect to servers when the workspace is opened?

Erin Stellato 651 Reputation points Microsoft Employee

2023-08-17T15:40:56.7033333+00:00

@David-3300 There is not an option to configure a workspace to automatically connect to servers when a workspace is opened - please enter that as a request in GitHub (including the scenario in which you would use that and why is also helpful). Thanks!
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Ak4495 0 Reputation points

2024-03-28T10:26:59.61+00:00

Issue Created:
https://github.com/microsoft/azuredatastudio/issues/25549#issue-2212845732
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Automatically Load Server on Azure Data Studio on Start Up

2 answers

Your answer