Connect to a SQL Server using NodeJS

Question

I'm having a project which I need the server to have db. I chose Sql Server 2012 (because I used it). Now the sql configured with a Windows authentication and I unable to connect it (maybe it's because the config string is not good).

Should I use windows authentication or sql connection? I use require ('mssql') and my config is like this:

var config = {
  user: 'MyName',
  password: '123',
  server: 'localhost',
  database: 'MyProj',
  options: {
    instanceName: 'SQLEXPRESS'
  }
};

error message:

{ [ConnectionError: Failed to get response from SQL Server Browser on localhost] name: 'ConnectionError', message: 'Failed to get response from SQL Server Browser on localhost', code: 'EINSTLOOKUP' }

What did I do wrong? (I know something wrong because it doesn't working)

{ [ConnectionError: Failed to get response from SQL Server Browser on localhost] name: 'ConnectionError', message: 'Failed to get response from SQL Server Browser on localhost', code: 'EINSTLOOKUP' } — user2004403
– user2004403, Commented Sep 22, 2014 at 22:17
My problem was I needed to add users and I tried to use one created when I install the db, a big mistake of mine. Thank you — user2004403
– user2004403, Commented Oct 1, 2014 at 12:15

Sequenzia · Accepted Answer · 2014-09-22 22:47:04Z

1

I normally always make sure all my MS SQL Servers are setup in Mixed Mode. Then you can use the actual username and password in your connection string

answered Sep 22, 2014 at 22:47

Sequenzia

2,3719 gold badges40 silver badges60 bronze badges

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

2 Comments

bryanmac Over a year ago

Agreed. I don't know the mssql module but I would guess it's not doing ntlm/integrated auth.

user2004403 Over a year ago

I configured MSSQL when installed it as a mixed and inserted my password (and confirmation) but now I can connect sql management only using windows authentication, SQL authentication doesn't work.

Collectives™ on Stack Overflow

Connect to a SQL Server using NodeJS

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related