- Run
npm install - Create app-settings.js in the projects root directory.
- Add the following code to the file:
module.exports = {
connection: {
host: "<server ip address>",
user: "<mssql server user>",
password: "<mssql server user password>",
port: <open port to mssql server>,
database: "KnexIssueExample <Change if the database name in the initial SQL script is changed>"
}
}
- Run the init.sql script on your mssql server to create the test database.
- Setup user security rights to the newly created database
npm run startto run the problemmatic scenario