please give node-sqlserver-v8 a try!

[TimelordUK]

greetings. I hope you find some use in this module. I intend to add additional features which hopefully will be based on the community feedback. So please feel free to make suggestions for improvements or issues with the new stored procedure feature.

[meet-bhagdev]

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

[tysjiang]

Currently using it, works great!

[robokozo]

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?

[TimelordUK]

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 + "};";

[robokozo]

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.

[paulbjensen]

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