what URL format that mssql accepts to connect a sqlserver?

[yadongyaly]

• MSSQL Extension Version: 1.22.1
• VSCode Version:1.90.2
• OS Version: Windows 11 Enterprise

Not a bug, I could not find an answer online so post my question here.
I am working on TypeScript project, trying to use windows.open(URL, _self) to connect a database with VSC mssql extension, but I cannot find a correct URL format that mssql extension accepts.

For example, I tried this:
const URL = vscode://ms-mssql.mssql//connect?server=${server}&database=${database}&authenticationType=AzureMFA;
window.open(URL, "_self");

After running, the vscode app pops out a windows saying "do you want to open this URL with mssql extension, and I clicked yes. However, nothing happens after that.

There is an example of opening Azure Data Studio, it works well, I am looking for something similar with VSC mssql extension.
const URL = azuredatastudio://openConnectionDialog?server=${server}&database=${database}&authenticationType=AzureMFA;

[Charles-Gagnon]

This extension doesn't currently support that, so unfortunately you won't be able to connect directly with a URI like you can in ADS

[yadongyaly]

Thanks @Charles-Gagnon for confirming this. I will look around for alternatives then

[Charles-Gagnon]

@yadongyaly FYI - another tracking issue has been opened for supporting this. You can follow that for updates.

#17920

I'll close this as it's a duplicate of that.

[yadongyaly]

[like] Yadong Lyu reacted to your message:

…

________________________________ From: Charles Gagnon ***@***.***> Sent: Monday, July 8, 2024 8:26:19 PM To: microsoft/vscode-mssql ***@***.***> Cc: Mention ***@***.***>; Author ***@***.***>; Comment ***@***.***> Subject: Re: [microsoft/vscode-mssql] what URL format that mssql accepts to connect a sqlserver? (Issue #17915) @yadongyaly<https://github.com/yadongyaly> FYI - another tracking issue has been opened for supporting this. You can follow that for updates. #17920<#17920> I'll close this as it's a duplicate of that. — Reply to this email directly, view it on GitHub<#17915 (comment)> or unsubscribe<https://github.com/notifications/unsubscribe-auth/A2N5XXFBJDJ4H5NTRGMBFHTZLLYWZBFKMF2HI4TJMJ2XIZLTSOBKK5TBNR2WLJDUOJ2WLJDOMFWWLO3UNBZGKYLEL5YGC4TUNFRWS4DBNZ2F6YLDORUXM2LUPGBKK5TBNR2WLJDUOJ2WLJDOMFWWLLTXMF2GG2C7MFRXI2LWNF2HTAVFOZQWY5LFUVUXG43VMWSG4YLNMWVXI2DSMVQWIX3UPFYGLLDTOVRGUZLDORPXI6LQMWWES43TOVSUG33NNVSW45FGORXXA2LDOOJIFJDUPFYGLKTSMVYG643JORXXE6NFOZQWY5LFVA3DCOJXGM4DKM4CUR2HS4DFUVUXG43VMWSXMYLMOVS2UMRTG44TEMRVGYZDLJ3UOJUWOZ3FOKTGG4TFMF2GK>. You are receiving this email because you were mentioned. Triage notifications on the go with GitHub Mobile for iOS<https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android<https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>.