Enable Integrated Authentication

[Bjornej]

First of all thanks for the plugin, it's really useful to us but we have a issue with authentication.

Basically all our SQL Servers only work with Trusted Connection delegating authentication to Windows and Mixed mode authentication (username and password) is disabled for security reasons.

I've tried various forms of the connection string but I don't seem to be able to enable Trusted authentication even if it seems to be possible with the underlying mssql driver (https://github.com/patriksimek/node-mssql#microsoft--contributors-node-v8-driver-for-nodejs-for-sql-server)

Can you point me in the right direction? Is this currently possible?

[gbrian]

Hi @Bjornej ,

Following documentation is supposed to be easy as:

• Install msnodesql
• Add extra parameter to your connection string ?drive=msnodesql&trustedConnection=true
  After fighting for couple of hours I gave up :( sorry!

Even been able to manage installing msnodesql still having an error when this module is being loaded.
https://stackoverflow.com/questions/19661811/unable-to-download-msnodesql-0-2-1-v0-10-x64-msi

I'll keep you posted if there's any advance on this.