Nodejs Failed to connect to localhost:1433 - Could not connect

 

1. Nodejs

npm install express

npm install mssql

var express=require('express');

var app=express();

app.get('/',function(req,res){

    var sql=require('mssql');

   

   //config for your database

    var config={

       user:'sa',

       password:'XXXX',

       server:'localhost',   //這邊要注意一下!!

       //server: 'LAPTOP-G08D86D1',

       database:'CULA',

       trustServerCertificate: true

    };

   

   //connect to your database

    sql.connect(config,function (err) {

      if(err) console.log(err);

   

   //create Request object

      var request=new sql.Request();

   request.query('select * from CulaClinic',function(err,recordset){

      if(err) console.log(err);

   

   //send records as a response

      res.send(recordset);

      });

    });

   

   });

   

   var server=app.listen(5050,function(){

    console.log('Server is running!');

   });

Error

Failed to connect to 127.0.0.1:1433 - Could not connect

Set 1433

TCP/IP Enable

Make sure SQL Sever browser and   SQL Sever Agent is start

Done