Unable to connect NodeJS with MSSQL

[yeehengoh]

Node.js Version: 12.3.1
OS: Windows
Scope: Code
Module (and version): studentWebsite

I am facing difficulties of connecting my web apps to my MSSQL database.
After compiling program in Visual Studio 2017, once starting my program, it comes out with this error.

"Error while connecting to database :- ConnectionError: Login failed for user 'mylocal'."

The Google chrome web browser appears to have the following error.
{"code":"ELOGIN","originalError":{"message":"Login failed for user 'mylocal'.","code":"ELOGIN"},"name":"ConnectionError"}
For your information, I used NodeJS version 12.3.1, Express JS with version 14.7.1, and MSSQL with version 5.1.0.

I've located my source code inside my public GITHUB as following address.
https://github.com/yeehengoh/studentNodes

In my db.js, my connection string is written as below.

const db =
{
user: "mylocal",
password: "my123",
server: "localhost\LocalDBDemo",
database: "studentData",
port: 1433
};

module.exports = db;

Not so sure is there anything wrong with my setting over here, and i've also attached the snapshot for database's SQL server authentication.

Please help on that. Thanks...

[gireeshpunathil]

I am not an MSSQL expert, but the abstraction for the server does not look intuitive - is it the IP address or the well known name, or the name of the DB server instance, or a combination of all these - https://www.npmjs.com/package/mssql#general-same-for-all-drivers is not very specific on this.

Having said that, in your image the server name is shown as (LocalDb)\LocalDBDemo while your string is localhost\LocalDBDemo - could this be a reason?

[gireeshpunathil]

it would also be great if the GUI provides a copy button that composes a connection string from the input that we provide.

[yeehengoh]

Hi Gireesh, Maybe i can try to change my connection string to format as below, see whether it works well or not... mssql://username:password@localhost:1433/database?encrypt=true Regards, YeeHeng Oh

…

On Tue, Jun 11, 2019 at 12:36 PM Gireesh Punathil ***@***.***> wrote: it would also be great if the GUI provides a copy button that composes a connection string from the input that we provide. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#1972?email_source=notifications&email_token=AMBOCIEE3WQDWJ2BBTAXTSDPZ4TVHA5CNFSM4HW2LXB2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODXL5EXY#issuecomment-500683359>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AMBOCIDWERRR3GTEMWKDYOLPZ4TVHANCNFSM4HW2LXBQ> .

[gireeshpunathil]

@yeehengoh - were you successful with the new connection string?

[gireeshpunathil]

inactive, closing

[yeehengoh]

Hello there, I just signed the petition "United Nations: Call for the resignation of Tedros Adhanom Ghebreyesus, WHO Director General" and wanted to see if you could help by adding your name. Our goal is to reach 1,500,000 signatures and we need more support. You can read more and sign the petition here: http://chng.it/sYwMWdTDMb Thanks! Mandy