Here I will explain how to connect sql database in node js service. you can call this service from angular js, jquery etc. we require express and mssql packages for this. First of all we attach require packages. you have download this packages using npm in your project. var express = require('express'), app = express(); var sql = require('mssql'); Then after configure your database credentials. var config = { user: 'USERNAME', password: 'PASSSWORD', server: 'SERVER IP', database: 'DBNAME', pool: { max: 100, min: 0, idleTimeoutMillis: 3000000 }, options: { encrypt: true } }; Here I have created object of sql connection and call connect method of this. var connection = new sql.Connection(config); connection.connect(); here i have created get method. app.get('/Your service name', function (req, res) { //attach header for cross platf...
Here you can find solution of your code problem & errors.