search

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.54k stars 899 forks source link

Connection Server must recognize <host>:<port> strings #15310

Open sir-farfan opened 3 years ago

sir-farfan commented 3 years ago

For decades every application knows to recognize the [host]:[port] "server" string.

Azure Data Studio, however, uses [host],[port] which is weird and forces you to open the Advanced settings to look for the "Port" just to put it that way in the server field.

ADS should play nice with everything else and use the known syntax too.

Steps to Reproduce:

1.

kburtram commented 3 years ago

@sir-farfan you can enter "server,port" directly in the Connection Dialog server field without needing to go to the Advanced Options dialog. This is standard format used for connecting to SQL Server in the various tools we ship (as far as I know). I'll leave this open as suggestion to additionally support the ":" syntax.