please give node-sqlserver-v8 a try! about node-sqlserver-v8 HOT 6 OPEN

This is great!! I am giving it a try and will let you know if I find something. This absolutely amazing though!!!!

from node-sqlserver-v8.

Currently using it, works great!

from node-sqlserver-v8.

I've never connected to an SQL server from Node so this is all new to me. I haven't been able to get this implementation working.
Right now, I'm getting a message:

{ [Error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Login failed for user USERNAME.] sqlstate: '28000', code: 18456 }

Any ideas?

from node-sqlserver-v8.

this error has come back from SQL server, so clearly you are at least communicating with the database. Are you using windows authentication or a database account? The connection has to be configured as below. If you use authentication, set the trusted flag true and the user and password are not therefore required. If the server requires a user and password, then the flag should be false and the credentials set. Is this a local database or an instance maintained by DBA's? How would you connect from Management Studio normally? The configuration below would be precisely inline with your normal access.

var driver = 'SQL Server Native Client 11.0';
var server = '<your_server>';
var user = '';
var pwd = '<password';
var database = 'AdventureWorks2012';
var useTrustedConnection = false;
var conn_str = "Driver={" + driver + "};Server=" + server + ";" + (useTrustedConnection == true ? "Trusted_Connection={Yes};" : "UID=" + user + ";PWD=" + pwd + ";") + "Database={" + database + "};";

from node-sqlserver-v8.

Thanks, TimelordUK. I was able to get it working eventually by using https://www.npmjs.com/package/mssql and renaming your package to stand in for the official MS package in the node_modules folder.

from node-sqlserver-v8.

I'm using this at work, thank you for making it.

from node-sqlserver-v8.