I've had some trouble in the recent past with the pre-definded MSSQL nodes and connection errors. Errors are recent with newer versions installed. One option is to revert to prior versions. I'm not sure if these are problems with versions or Microsoft updates etc... Errors exist where they did not before. All this leaves my Node-RED development in limbo until I can resolve issues around the errors.
The following are instructions from https://www.dotnetcurry.com/nodejs/1238/connect-sql-server-nodejs-mssql-package.
This will install a Typescript definition for the VSCode so that we can get the help of the intellisense for various packages.
tsd query node --action install
The above command provides Node.js intellisense for the application.
npm install mssql
This command will install mssql package in node-modules folder.
tsd query mssql --action install
This will install mssql intellisense for the current application.