Error when try connect to mssql server database

Kelum shared this idea 32 days ago
Under Consideration

Could you pls help on to connect mssql server database? I'm getting following error when i just click on "Connect" with default URI. (" mssql://user:password@localhost/INSTANCE/database?encrypt=true ")


Knex:Error Failed to connect to localhost:undefined in 15000ms

stack: ConnectionError: Failed to connect to localhost:undefined in 15000ms

at Connection.<anonymous> (C:\Users\KelumDesktop\AppData\Local\Programs" +

"osqlbooster4mongo\resources\app.asar" +

"ode_modules\mssql\lib edious.js:378:25)

at Object.onceWrapper (events.js:273:13)

at Connection.emit (events.js:182:13)

at Connection.connectTimeout (C:\Users\KelumDesktop\AppData\Local\Programs" +

"osqlbooster4mongo\resources\app.asar" +

"ode_modules edious\lib\connection.js:467:12)


How should i change the URI?


Assume my details are as follows;

Windows user name- my_user

Windows Password - Mypassword123

SQL server name - DESKTOP-ABCDEFG\SQLEXPRESS

Database name - mydatabase


Appreciate if you can help me on this?

Comments (1)

photo
1

NoSQLBooster uses knexjs to connect to SQL DBs. Knexjs does not support Windows Authentication for MS SQL (#ref). You need to use SQL Server authentication mode.

About MSSQL Connection Formats: https://github.com/tediousjs/node-mssql#formats