Get an error when trying to connect to SQL. This happens on the latest v9.1.0 but works fine on v9.0.1
This is the function which is called to connect to SQL
async function getSqlServerDriver() {
const pool = new sql.ConnectionPool(config.sql.connectionString);
await pool.connect();
return pool;
}
The error is
Login failed for user ''.
at Object.onceWrapper (node:events:628:26)
at Connection.emit (node:events:513:28)
at Connection.emit (node:domain:489:12)
at processTicksAndRejections (node:internal/process/task_queues:96:5)
Configuration:
// paste relevant config here
config.sql.connectionString = "Server=x.x.x.x;Database=someDb;User Id=someUser;Password=somePass;trustServerCertificate=true;request timeout=30000"
Software versions
NodeJS: v16.18.1
node-mssql: v9.1.0
SQL Server: Microsoft SQL Server 2019 (RTM) - 15.0.2000.5 (X64)
Can not connect to SQL server
Expected behaviour:
Successfully connect to SQL server
Connect to SQL and successfully run queries
Actual behaviour:
Get an error when trying to connect to SQL. This happens on the latest v9.1.0 but works fine on v9.0.1
This is the function which is called to connect to SQL
async function getSqlServerDriver() { const pool = new sql.ConnectionPool(config.sql.connectionString); await pool.connect(); return pool; }
The error is
Configuration:
Software versions