# Installing Unified-RED on Windows with SQL Server – Help Needed
**URL:** https://discourse.nodered.org/t/installing-unified-red-on-windows-with-sql-server-help-needed/95614
**Category:** Dashboard
**Tags:** unified-red
**Created:** [24 February 2025 17:47 UTC](https://discourse.nodered.org/t/installing-unified-red-on-windows-with-sql-server-help-needed/95614 "2025-02-24T17:47:56Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@fopak](https://discourse.nodered.org/u/fopak)
#### Post date: [24 February 2025 17:47 UTC](https://discourse.nodered.org/t/installing-unified-red-on-windows-with-sql-server-help-needed/95614/1 "2025-02-24T17:47:57Z")
Hello everyone,
I am new to Node-RED, and for the past two days, I have been trying to install Unified-RED without success.
- After installing Unified-RED and restarting the server (Node-RED), I get **Error 1** and notice that the **Unified-RED database is not created**.
- When I manually create the database and restart the server, I get **Error 2**.
Could someone help me understand **how to install Unified-RED with SQL Server**?
Does anyone have the **SQL script to manually create the database tables**?
Thank you for your help!
_======================== Error 1 =========================_
C:\Users\User01\>node-red
24 Feb 17:24:21 - [info]
# Welcome to Node-RED
24 Feb 17:24:21 - [info] Node-RED version: v4.0.9
24 Feb 17:24:21 - [info] Node.js version: v22.14.0
24 Feb 17:24:21 - [info] Windows\_NT 10.0.19045 x64 LE
24 Feb 17:24:22 - [info] Loading palette nodes
24 Feb 17:24:24 - [info] Unified-RED Dashboard version 2.5.2 started at /ui
24 Feb 17:24:24 - [info] Dashboard version 3.6.5 started at /ui
AccessDeniedError [SequelizeAccessDeniedError]: Login failed for user 'password000@001'.
at ConnectionManager.connect (C:\Users\User01.node-red\node\_modules\sequelize\lib\dialects\mssql\connection-manager.js:115:17)
at process.processTicksAndRejections (node:internal/process/task\_queues:105:5)
at async ConnectionManager.\_connect (C:\Users\User01.node-red\node\_modules\sequelize\lib\dialects\abstract\connection-manager.js:222:24)
at async C:\Users\User01.node-red\node\_modules\sequelize\lib\dialects\abstract\connection-manager.js:174:32 {
parent: ConnectionError: Login failed for user 'password000@001'.
at Login7TokenHandler.onErrorMessage (C:\Users\User01\node\_modules\tedious\lib\token\handler.js:186:19)
at Readable. (C:\Users\User01\node\_modules\tedious\lib\token\token-stream-parser.js:19:33)
at Readable.emit (node:events:518:28)
at addChunk (node:internal/streams/readable:561:12)
at readableAddChunkPushObjectMode (node:internal/streams/readable:538:3)
at Readable.push (node:internal/streams/readable:393:5)
at nextAsync (node:internal/streams/from:194:22)
at process.processTicksAndRejections (node:internal/process/task\_queues:105:5) {
code: 'ELOGIN'
},
original: ConnectionError: Login failed for user 'password000@001'.
at Login7TokenHandler.onErrorMessage (C:\Users\User01\node\_modules\tedious\lib\token\handler.js:186:19)
at Readable. (C:\Users\User01\node\_modules\tedious\lib\token\token-stream-parser.js:19:33)
at Readable.emit (node:events:518:28)
at addChunk (node:internal/streams/readable:561:12)
at readableAddChunkPushObjectMode (node:internal/streams/readable:538:3)
at Readable.push (node:internal/streams/readable:393:5)
at nextAsync (node:internal/streams/from:194:22)
at process.processTicksAndRejections (node:internal/process/task\_queues:105:5) {
code: 'ELOGIN'
}
}
24 Feb 17:24:24 - [red] Uncaught Exception:
24 Feb 17:24:24 - [error] SequelizeAccessDeniedError: Login failed for user 'password000@001'.
at ConnectionManager.connect (C:\Users\User01.node-red\node\_modules\sequelize\lib\dialects\mssql\connection-manager.js:115:17)
at process.processTicksAndRejections (node:internal/process/task\_queues:105:5)
at async ConnectionManager.\_connect (C:\Users\User01.node-red\node\_modules\sequelize\lib\dialects\abstract\connection-manager.js:222:24)
at async C:\Users\User01.node-red\node\_modules\sequelize\lib\dialects\abstract\connection-manager.js:174:32
_======================== Error 2 =========================_
C:\Users\User01\>node-red
24 Feb 17:25:15 - [info]
# Welcome to Node-RED
24 Feb 17:25:15 - [info] Node-RED version: v4.0.9
24 Feb 17:25:15 - [info] Node.js version: v22.14.0
24 Feb 17:25:15 - [info] Windows\_NT 10.0.19045 x64 LE
24 Feb 17:25:16 - [info] Loading palette nodes
24 Feb 17:25:18 - [info] Unified-RED Dashboard version 2.5.2 started at /ui
24 Feb 17:25:18 - [info] Dashboard version 3.6.5 started at /ui
24 Feb 17:25:18 - [info] Settings file : C:\Users\User01.node-red\settings.js
24 Feb 17:25:18 - [info] Context store : 'default' [module=memory]
24 Feb 17:25:18 - [info] User directory : \Users\User01.node-red
24 Feb 17:25:18 - [warn] Projects disabled : editorTheme.projects.enabled=false
24 Feb 17:25:18 - [info] Flows file : \Users\User01.node-red\flows.json
24 Feb 17:25:18 - [warn]
* * *
Your flow credentials file is encrypted using a system-generated key.
If the system-generated key is lost for any reason, your credentials
file will not be recoverable, you will have to delete it and re-enter
your credentials.
## You should set your own key using the 'credentialSecret' option in your settings file. Node-RED will then re-encrypt your credentials file using your chosen key the next time you deploy a change.
24 Feb 17:25:18 - [warn] Encrypted credentials not found
24 Feb 17:25:18 - [info] Server now running at [http://127.0.0.1:1880/](http://127.0.0.1:1880/)
24 Feb 17:25:18 - [info] Starting flows
24 Feb 17:25:18 - [info] Started flows
24 Feb 17:25:18 - [red] Uncaught Exception:
24 Feb 17:25:18 - [error] Error
at Query.run (C:\Users\User01.node-red\node\_modules\sequelize\lib\dialects\mssql\query.js:107:25)
at C:\Users\User01.node-red\node\_modules\sequelize\lib\sequelize.js:315:28
at process.processTicksAndRejections (node:internal/process/task\_queues:105:5)
at async MSSqlQueryInterface.select (C:\Users\User01.node-red\node\_modules\sequelize\lib\dialects\abstract\query-interface.js:407:12)
at async Role.findAll (C:\Users\User01.node-red\node\_modules\sequelize\lib\model.js:1140:21)
at async Role.findOne (C:\Users\User01.node-red\node\_modules\sequelize\lib\model.js:1240:12)
at async init (C:\Users\User01.node-red\node\_modules\unified-red\api\users\role.service.js:10:11)
---
### Author:  [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)
#### Post date: [24 February 2025 19:25 UTC](https://discourse.nodered.org/t/installing-unified-red-on-windows-with-sql-server-help-needed/95614/2 "2025-02-24T19:25:30Z")
Hi, ~~I've moved this out of the Dashboard category as this is a 3rd-party clone and not one of the more recognised dashboards.~~ I was possibly a little hasty. I've moved it back into the Dashboard category but changed the tag to indicate the actual node package.
If this error is caused by [unified-red (node) - Node-RED](https://flows.nodered.org/node/unified-red/) I can only suggest contacting the author via GitHub.
I do note that this package has **50** dependencies which seems like an excessive number?
Also, do you have the pre-requisite libraries installed?
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [26 March 2025 19:26 UTC](https://discourse.nodered.org/t/installing-unified-red-on-windows-with-sql-server-help-needed/95614/3 "2025-03-26T19:26:28Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.