This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 54%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
"SQL Tools Microsoft SQL Server/Azure", the driver for SQL Tools in Visual Studio Code, seems unable to connect with my Azure SQL Database account's sole logical server.
I am able to make connection from Visual Studio Code (VSC) to Azure SQL Database (Az SQ DB).
Incidentally, I am also able to make that connection from SSMS.
In VSC, I can successfully run query SELECT 1;
However, when I run other queries (eg to find foreign keys), I am told I don’t have an extension for debugging SQL. VSC offers to find one in the Marketplace, but CoPilot didn't see any point in the ones found (& neither do I).
CoPilot thought the message meant VSC wasn't recognising the MSSQL extension, so recommended installing SQLTools. SQL Tools seemed to or it to work, it seemed to need "SQL Tools Microsoft SQL Server/Azure" - the driver.
Hence, I installed that....but encountered the issue described at start of this description.
The error on Test Connection is "Error opening connection Cannot open server "xxx" requested by the login. The login failed". This was baffling because "xxx" in the error codes it my username, not the server address inputted to the Connection Assistant
Steps taken may be summarised as: verify server address, check firewall rules, close/reopen VSC, remove all connections and reinstate and close/reopen VSC.
Core component of SQL Server for storing, processing, and securing data
Answer accepted by question author
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
"SQL Tools Microsoft SQL Server/Azure" is a 3rd party VSC extension. You should contact the author with questions.
you might try the MS official extension:
https://marketplace.visualstudio.com/items?itemName=ms-mssql.mssql
Many thanks for your reply.
I did have SQL Server (mssql) installed too, however VSC didn't seem to to recognise its availability and this contributed to an impression I'd also need the 3rd party app and its driver.
I now realise: what created that impression, somewhat encouraged by CoPilot, was that I was trying to execute the query from the Run command of VSC's core menu. On the strength of your reply, I uninstalled the third party apps and revisited my query and happened to notice its context menu with option to 'Execute Query'!
(Perils of relying on CoPilot, it seems!)
Thank you so much: you turned the tide for me.