我正在尝试从节点(使用节点mssql)远程连接到Microsoft SQL Server。
var sql = require('mssql')
var config = {
server: '**',
user: '**',
password: '**!',
database: '**'
}
sql.connect(config, function(err) {
var request = new sql.Request()
request.query("select *", function(err, recordset) {
console.log(err)
console.log(recordset)
})
console.log('end')
})
我从服务器运行了以下查询:
SELECT
CONNECTIONPROPERTY('net_transport') AS net_transport,
CONNECTIONPROPERTY('protocol_type') AS protocol_type,
CONNECTIONPROPERTY('auth_scheme') AS auth_scheme,
CONNECTIONPROPERTY('local_net_address') AS local_net_address,
CONNECTIONPROPERTY('local_tcp_port') AS local_tcp_port,
CONNECTIONPROPERTY('client_net_address') AS client_net_address
基于
SQL - Query to get server's IP address
我是否使用
client_net_address
远程连接,或
server
参数