I am trying to connect Node.js to SQL Server for the first time. I would greatly appreciate some help.
This function makes the connection:
import config from './dbconfig.js';
import mssql from 'mssql';
export async function getUsers() {
try {
let pool = await mssql.connect(config);
let users = await pool.request().query('SELECT * from users');
return users.recordsets;
}
catch (error) {
console.log(error);
}
}
The config I am importing looks like this:
const config = {
user: 'userName',
password: 'password',
server: 'localhost',
database: 'learningProgress',
options: {
trustedconnecion: true,
enableArithAbort: true,
instancename: 'DESKTOP-564IAGD\SQLEXPRESS',
encrypt: true,
trustServerCertificate: true,
}
port:55829
};
export default config;
In place of userName and password I used my Windows user name and password, is that correct?
In place of instancename I used DESKTOP-564IAGD\SQLEXPRESS, is this correct?
How do I know what my port number is? When my port number is part of the config I get this error:
ConnectionError: Failed to connect to localhost:55829 - Could not connect (sequence)
code: 'ESOCKET'
I tried running this SQL command:
SELECT DISTINCT local_net_address, local_tcp_port
FROM sys.dm_exec_connections;
but I got null.
I will mention that my SQL Server browser is running, and TCP/IP is enabled, IP Addresses - TCP port is set to 1433 (all of them).
If I do not have port in the config this is my error regard the userName:
Promise { }
ConnectionError: Login failed for user 'userName'.
code: 'ELOGIN',
isTransient: undefined
}
}
0 comments:
Post a Comment
Thanks