SQLTools MSSQL/Azure+ Driver

This is a fork of the Microsoft SQL Server/Azure Official driver with Windows Authentication support.

This includes both the tedious driver (part of the Official driver) and the msnodesqlv8 driver, the latter of which introduces Windows Authentication support.

How to activate?

1. Install Node.js v20
2. Set sqltools.useNodeRuntime to true in settings.

⚠️ Module did not self-register error when connecting ⚠️ :

• This happens when you are using a different Node version from How to activate? step 1.
• (IMPORTANT!) Close VSCode
• Go to your extension directory
  • Windows: %USERPROFILE%\.vscode\extensions\fzhem.sqltools-driver-mssql-commver-0.6.0
  • Linux: ~/.vscode/extensions/fzhem.sqltools-driver-mssql-commver-0.6.0
  • Mac OS: ~/.vscode/extensions/fzhem.sqltools-driver-mssql-commver-0.6.0
• Run npm install msnodesqlv8@4.2.1 in your terminal.
  • Alternatively you can run npm rebuild but that may require additional libraries.

Features and Fixes

• Supports msnodesqlv8 driver containing windows authentication support
• Adds DSN connection method
• Fixes Intellisense for databases
• Adds an option to display empty database/schema in side panel
• Adds Security, Functions, Stored procedures, and Linked Servers in side panel
• Supports fetch records functionality for pre SQL Server 2012 databases

Connection Methods

• Tedious driver
  • Same as the official driver but with optional database input.
  • Supports trustServerCertificate boolean setting.
• MSNodeSQLv8 driver
  • Supports Windows Authentication.
  • DSN (Data Source Name) method takes ODBC data source name.
    • If you a windows authentication DSN set Use password to Use empty password.
    • SQL login/password DSNs require both username and password.

Screenshots

Side Panel with additional items

MS Node SQL v8 settings page