可以将节点连接到SQL Server
我正在尝试将节点应用与SQL Server数据库连接起来,但是我一直遇到此错误:
连接数据库时错误:ConnectionError:
错误:[Microsoft] [SQL Server本地客户端11.0] SQL Server网络接口:连接字符串无效[87]。
错误:[Microsoft] [SQL Server本地客户端11.0]登录超时过期
错误:[Microsoft] [SQL Server本地客户端11.0]在建立与SQL Server的连接时,发生了与网络相关或实例特定的错误。服务器未找到或无法访问。检查实例名称是否正确,以及是否配置了SQL Server以允许远程连接。有关更多信息,请参见SQL Server Books在线。
我将Node软件包mssql
与驱动程序msnodesqlv8
使用,这是我的db config:
const dbConfig = {
user: "user",
password: "password",
driver: 'msnodesqlv8',
server: 'DESKTOP-QG3R51Q',
database: 'WeighingScales',
options: {
instanceName: 'SQLEXPRESS',
trustedConnection: true,
}
};
I'm trying to connect a node app with a SQL Server database, but I keep getting this error:
Error while connecting database: ConnectionError:
Error: [Microsoft][SQL Server Native Client 11.0]SQL Server Network Interfaces: Connection string is not valid [87].
Error: [Microsoft][SQL Server Native Client 11.0]Login timeout expired
Error: [Microsoft][SQL Server Native Client 11.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
I use the node package mssql
with driver msnodesqlv8
, and this is my db config:
const dbConfig = {
user: "user",
password: "password",
driver: 'msnodesqlv8',
server: 'DESKTOP-QG3R51Q',
database: 'WeighingScales',
options: {
instanceName: 'SQLEXPRESS',
trustedConnection: true,
}
};
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论