Pages

03 September, 2023

originalError: ConnectionError: Login failed for user 'userName' when connecting Node.js to SQL Server

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 } }

No comments:

Post a Comment

Thanks