Forum Discussion

dwakchaure's avatar
dwakchaure
10 months ago

Connecting to a SQL Server database using Integrated Security from JavaScript

I have a BDD test. One of the step definitions connects to SQL Server database and fetches some data. I use JavaScript. This the JavaScript code I have. The connection used Integrated Security, so n...
script tests
rraghvani's avatar
rraghvani
Icon for Champion Level 3 rankChampion Level 3
10 months ago

Providing you are using the correct ODBC driver, here's the connection that I use for SQL Server

"Provider=MSOLEDBSQL19.1; Integrated Security=SSPI; Persist Security Info=False; Initial Catalog=Your_Database_Name; Data Source=Your_Database_Server_Name; Use Encryption for Data=False;"