SQL Server本机客户端11.0:命名Pipes提供商:无法打开与SQL Server的连接

Question

var express = require('express');
var app = express();
app.get('/', function (req, res) {
    var sql = require('mssql/msnodesqlv8');
    var config = {
        driver: 'msnodesqlv8',
        connectionString: 'Driver={SQL Server Native Client 11.0};Server=DESKTOP-QUUGSCTSQLEXPRESS;Database=nodedb;Trusted_Connection=yes;',
       // CONNECTION_NAME = "Provider=SQLNCLI10.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog="CatalogName";Data Source="Production_Server_Name;""
    };
    const pool = new sql.ConnectionPool(config).connect().then(pool => {
        return pool.request().query("Select * From dbo.test")
    }).then(result => {
        let rows = result.recordset
        res.status(200).json(rows);
        sql.close();
    }).catch(err => {
        res.status(500).send({ message: `${err}` })
        sql.close();
    });
});
var server = app.listen(5000, function () {
    console.log('Server is running..');
});

我使用此代码nodejs在Windows身份验证模式下连接MSSQL连接字符串。我尝试运行此程序，我会遇到这样的错误

{
   "message":"ConnectionError: [Microsoft][SQL Server Native Client 11.0]Named Pipes Provider: Could not open a connection to SQL Server [53]. "
}

我启用了所有管道和TCP端口。

Answer 1

connectionString: 'Driver={SQL Server Native Client 11.0};Server=DESKTOP-QUUGSCTSQLEXPRESS;Database=nodedb;Trusted_Connection=yes;'

您可能需要更改服务器名称DESKTOP-QUUGSCTSQLEXPRESS

到DESKTOP-QUUGSCT\SQLEXPRESS