sql - 连接到 SQL Server : Connection Error: Failed to connect to servername\instancename in 15000ms 时出现超时错误

Question

错误代码是代码 ETIMEOUT。我使用的是 SQL Server 2014，NodeJs 版本 v12.16.2，我在 Visual Studio Code 中运行这段代码。

我已经创建了数据库，并且还创建了包含一些记录的表。对于服务器名称，我也尝试提供 FQDN，但没有成功。

这是代码片段:

const express = require('express');
const app = express();
var Connection = require('tedious').Connection;
var Request = require('tedious').Request;
app.get('/', function(req, res) {
   res.send('<hHii</h');
});
const sql = require('mssql');
var config = {
   user: 'domain\username',
   password: 'mypwd',
   server: 'servername',
   host: 'hostname',
   port: '1433',
   driver: 'tedious',
   database: 'DBname',
   options: {
      instanceName: 'instancename'
   }
};
sql.connect(config, function(err) {
   if (err)
      console.log(err);
   let sqlRequest = new sql.Request();
   //var sqlRequest = new sql.Request(connection)
   let sqlQuery = 'SELECT * from TestTable';
   sqlRequest.query(sqlQuery, function(err, data) {
      if (err) console.log(err);
      console.log(data);
      //console.table(data.recordset);
      // console.log(data.rowAffected);
      //console.log(data.recordset[0]);
      sql.close()
   });
});
const webserver = app.listen(5000, function() {
   console.log('server is up and running....');
});

错误:

tedious deprecated The default value for `config.options.enableArithAbort` will change from `false` to `true` in the next major version of `tedious`. Set the value to `true` or`false` explicitly to silence this message.   

node_modules\mssql\lib\tedious\connection-pool.js:61:23  
server is up and running....  

ConnectionError: Failed to connect to servername\instantname in 15000ms

at Connection.<anonymous(..\SQL\Sample\sample\node_modules\mssql\lib\tedious\connection-pool.js:68:17)  
at Object.onceWrapper (events.js:417:26)  
at Connection.emit (events.js:310:20)  
at Connection.connectTimeout (..\SQL\Sample\sample\node_modules\tedious\lib\connection.js:1195:10)  
at Timeout._onTimeout (..\SQL\Sample\sample\node_modules\tedious\lib\connection.js:1157:12)  
at listOnTimeout (internal/timers.js:549:17)  
at processTimers (internal/timers.js:492:7) {  
   code: 'ETIMEOUT',
   originalError: ConnectionError: Failed to connect to INPUNPSURWADE\DA in 15000ms

   at ConnectionError (..\SQL\Sample\sample\node_modules\tedious\lib\errors.js:13:12)  
   at Connection.connectTimeout (..\SQL\Sample\sample\node_modules\tedious\lib\connection.js:1195:54)  
   at Timeout._onTimeout (..\SQL\Sample\sample\node_modules\tedious\lib\connection.js:1157:12)  
   at listOnTimeout (internal/timers.js:549:17)  
   at processTimers (internal/timers.js:492:7) {  
      message: 'Failed to connect to servername\instantname in 15000ms',
      code: 'ETIMEOUT'
    },
    name: 'ConnectionError'
  }

ConnectionError: Connection is closed.

at Request._query (..\SQL\Sample\sample\node_modules\mssql\lib\base\request.js:462:37)  
at Request._query (..\SQL\Sample\sample\node_modules\mssql\lib\tedious\request.js:346:11)  
at Request.query (..\SQL\Sample\sample\node_modules\mssql\lib\base\request.js:398:12)  
at Immediate.<anonymous(..\SQL\Sample\sample\index.js:43:12)      
at processImmediate  (internal/timers.js:458:21) {
   code: 'ECONNCLOSED',  
   name: 'ConnectionError'  
}

Answer 1

1. 转到 Windows 的“开始”菜单，搜索“服务”并将其打开。
2. 寻找“SQL Server 浏览器”
3. 右键单击它并转到“属性”。
4. 将“启动类型”切换为“自动”
5. 点击确定
6. 再次右键单击它并启动服务。

之后它应该可以工作了!