Step 1: Configure development environment for Node.js development

You will need to configure your development environment with the prerequisites in order to develop an application using the Node.js Driver for SQL Server. The most common method is to use the node package manager (npm) to install the tedious module, but you can download the tedious module directly at GitHub if you prefer.

The Node.js Driver uses the TDS protocol, which is enabled by default in SQL Server and Azure SQL Database. No additional configuration is required.

Windows

  1. Install Node.js runtime and npm package manager.
    a. Go to Node.js
    b. Click on the appropriate Windows installer msi link.
    c. Once downloaded, run the msi to install Node.js

  2. Open cmd.exe

  3. Create a project directory and navigate to it.

> mkdir HelloWorld  
> cd HelloWorld  
  1. Create a Node project. To retain the defaults during your project creation, press enter until the project is created. At the end of this step, you should see a package.json file in your project directory.
> npm init  
  1. Install tedious module in your project. Tedious is the implementation of the TDS protocol, which is used to communicate to SQL Server.
> npm install tedious  

Ubuntu Linux

  1. Open terminal

  2. Install Node.js runtime.

>sudo apt-get install node  
  1. Install npm (node package manager).
> sudo apt-get install npm  
  1. Create a project directory and navigate to it.
> mkdir HelloWorld  
> cd HelloWorld  
  1. Create a Node project. To retain the defaults during your project creation, press enter until the project is created. At the end of this step, you should see a package.json file in your project directory.
> sudo npm init  
  1. Install tedious module in your project. Tedious is the implementation of the TDS protocol, which is used to communicate to SQL Server.
> sudo npm install tedious  

macOS

  1. Install Node.js runtime and npm package manager.
    a. Go to Node.js
    b. Click on the appropriate macOS installer link.
    c. Once downloaded, run 'dmg' to install Node.js

  2. Open terminal

  3. Create a project directory and navigate to it.

> mkdir HelloWorld  
> cd HelloWorld  
  1. Create a Node project. To retain the defaults during your project creation, press enter until the project is created. At the end of this step, you should see a package.json file in your project directory.
> npm init  
  1. Install tedious module in your project. This is the implementation of the TDS protocol which the driver uses to communicate to SQL Server.
> npm install tedious