how can i connect from node.js to sql DB?

Question

i tried the following code:


const config = {
server: 'localhost',
database: 'MyDB',
user: *userName*,
password: *password*

const dbPool = new sql.ConnectionPool(config, err => {
 if (err)
   console.log(err)
 else
   console.log("success")
})

i created on the SSMS a user and a login, and did logged in with it to make sure it works. i changed the authentication from windows to SQL server. what am i missing?

I keep get this error message:

Login failed for user 'userNamr'.,

Code: 'ELOGIN'

Have you checked the logs on SQL Server? Can you see the connection attempt there, and if so, what do the logs say is the reason the login was rejected? — Thom A
– Thom A ♦, Commented Jan 27, 2020 at 10:32
Can you please print err in else part. So that we can check. — Prince Kumar Barnwal
– Prince Kumar Barnwal, Commented Jan 27, 2020 at 10:34

xplatypus07 · Accepted Answer · 2020-01-27 11:13:25Z

1

I think you have entered a wrong username or a user that does not exist but here is the demonstration how you can connect node.js to sql.

PS: make sure you have npm install and proper module for the db engine.

const pg = require("pg"); //replace "pg" with whatever engine you are using such as mssql

const connectionString = {
      user: 'username',
      host: 'localhost',
      database: 'testdb',
      password: 'mypass',
      port: 5432,
    };

const client = new pg.Client(connectionString);
    client.connect();
    client.query(
        'SELECT * from student;'
        ).then(
          res => {
        console.log(res.rows);
    }).finally(() => client.end());

answered Jan 27, 2020 at 11:13

xplatypus07

614 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

J.George · Accepted Answer · 2020-01-27 11:31:42Z

0

Is this the package you are using.In that case, I believe you are missing the connect method which as taken from the docs.Also ELOGIN err comes when login fails

const pool = new sql.ConnectionPool({
    user: '...',
    password: '...',
    server: 'localhost',
    database: '...'
})

pool.connect(err => {
    // ...
})

answered Jan 27, 2020 at 11:31

J.George

3391 gold badge2 silver badges5 bronze badges

Collectives™ on Stack Overflow

how can i connect from node.js to sql DB?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related