Connect to a local SQL Server db with sequelize

Question

Having completed the SQL Server installer, the given connection string is Server=localhost\MSSQLSERVER01;Database=master;Trusted_Connection=True;, which seems like a strange format, and if I try to connect to the db with sequelize using that connection string:

var sequelize = new Sequelize(process.env.DB_STRING);

I get the error:

TypeError: Cannot read property 'replace' of null

at new Sequelize (C:\Users\George\Source\Repos\TestProj\node_modules\sequelize\lib\sequelize.js:132:40) at Object. (C:\Users\George\Source\Repos\TestProj\models\index.js:13:21) at Module._compile (module.js:570:32)

Related for PostgreSQL: stackoverflow.com/questions/46207155/… — Ciro Santilli OurBigBook.com
– Ciro Santilli OurBigBook.com, Commented Mar 20, 2021 at 15:20

Vojtěch Dohnal · Accepted Answer · 2017-08-27 10:52:24Z

6

Based on this article you should install sequelize-msnodesqlv8:

var sequelize = new Sequelize({
  dialect: 'mssql',
  dialectModulePath: 'sequelize-msnodesqlv8',
  dialectOptions: {
    instanceName: 'MSSQLSERVER01',
    trustedConnection: true
  },
  host: 'localhost',
  database: 'master'
});

or perhaps better:

var sequelize = new Sequelize({
  dialect: 'mssql',
  dialectModulePath: 'sequelize-msnodesqlv8',
  dialectOptions: {
    connectionString: 'Server=localhost\MSSQLSERVER01;Database=master; Trusted_Connection=yes;'
  },
});

But you should not leave default database as Master. Use your database name instead.

Mark this:

There are many node mssql clients and sequelize defaults to using tedious, but being pure javascript,tedious lacks support for integrated security. msnodesqlv8 is a client that interfaces with a native odbc library. This allows integrated security to be used. It does require additional binaries to deploy, but fortunately, msnodesqlv8 is distributed with binaries for the most common architectures

You are using integrated security, so you need to deal with that problem.

15 Comments

George Edwards Over a year ago

Thanks! Hmm I am getting issue

Unhandled rejection SequelizeConnectionError: [Microsoft][SQL Server Native Client 11.0]Invalid value specified for connection string attribute 'Trusted_Connection'

with your second snippet?

Vojtěch Dohnal Over a year ago

@GeorgeEdwards Try Integrated Security=SSPI; instead of Trusted_Connection=True;. Or Trusted_Connection=yes;

George Edwards Over a year ago

Hmm, now I just get

Unhandled rejection SequelizeConnectionError: [Microsoft][SQL Server Native Client 11.0]Named Pipes Provider: Could not open a connection to SQL Server [53]

Vojtěch Dohnal Over a year ago

Can you connect to localhost\MSSQLSERVER01 using SSMS and Windows Authentication? You should verify that, looks like it does not allow you to connect. Check this.

Vojtěch Dohnal Over a year ago

@GeorgeEdwards But this is another problem which is not really connected with your original question.

|

Collectives™ on Stack Overflow

Connect to a local SQL Server db with sequelize

1 Answer 1

15 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

15 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related