Configure SqlPackageExecutable for Nodinite Log Database Automation
To install and update Nodinite, the SqlPackageExecutable must exist in the latest version. In addition, the SqlPackageExecutable must be configured correctly in the Nodinite System Parameters. The Nodinite Logging Service uses this parameter to spawn new Log Databases as the old ones get too old or too large.
Easily automate Log
- ✅ Enable automated schema updates for all supported SQL Server versions
- ✅ Ensure correct folder path conventions for 32/64-bit installations
- ✅ Troubleshoot common issues with SQLPackage.exe
- ✅ Streamline configuration for compliance and reliability
The SqlPackageExecutable system parameter in Nodinite enables automated schema updates and management for the Log Database. It supports SQL Server 2008 R2 through 2025, ensuring compatibility and reliability for your monitoring solution.
Supported SQL Server Versions and Folder Paths
64 Bit
| Version of Folder | SQL Version | Possible path | Comment |
|---|---|---|---|
| 180 | SQL Server 2025 | "C:\Program Files\Microsoft SQL Server\180\DAC\bin\SqlPackage.exe" | Default for SQL Server 2025 |
| 170 | SQL Server 2022 | "C:\Program Files\Microsoft SQL Server\170\DAC\bin\SqlPackage.exe" | Default for SQL Server 2022 |
| 160 | SQL Server 2019 | "C:\Program Files\Microsoft SQL Server\160\DAC\bin\SqlPackage.exe" | Default for SQL Server 2019 |
| 150 | SQL Server 2019 | "C:\Program Files\Microsoft SQL Server\150\DAC\bin\SqlPackage.exe" | Default for SQL Server 2019 |
| 140 | SQL Server 2017 | "C:\Program Files\Microsoft SQL Server\140\DAC\bin\SqlPackage.exe" | Default for SQL Server 2017 |
| 130 | SQL Server 2016 | "C:\Program Files\Microsoft SQL Server\130\DAC\bin\SqlPackage.exe" | Default for SQL Server 2016 |
| 120 | SQL Server 2014 | "C:\Program Files\Microsoft SQL Server\120\DAC\bin\SqlPackage.exe" | Default for SQL Server 2014 |
| 110 | SQL Server 2012 | "C:\Program Files\Microsoft SQL Server\110\DAC\bin\SqlPackage.exe" | Default for SQL Server 2012 |
| 105 | SQL Server 2008 R2 | "C:\Program Files\Microsoft SQL Server\105\DAC\bin\SqlPackage.exe" | Default for SQL Server 2008 R2 |
32 Bit
| Version of Folder | SQL Version | Possible path |
|---|---|---|
| 180 | SQL Server 2025 | N/A - 32 bit is not supported with SQL Server 2025 |
| 170 | SQL Server 2022 | N/A - 32 bit is not supported with SQL Server 2025 |
| 160 | SQL Server 2019 | "C:\Program Files\Microsoft SQL Server\160\DAC\bin\SqlPackage.exe" |
| 150 | SQL Server 2019 | "C:\Program Files (x86)\Microsoft SQL Server\150\DAC\bin\SqlPackage.exe" |
| 140 | SQL Server 2017 | "C:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin\SqlPackage.exe" |
| 130 | SQL Server 2016 | "C:\Program Files (x86)\Microsoft SQL Server\130\DAC\bin\SqlPackage.exe" |
| 120 | SQL Server 2014 | "C:\Program Files (x86)\Microsoft SQL Server\120\DAC\bin\SqlPackage.exe" |
| 110 | SQL Server 2012 | "C:\Program Files (x86)\Microsoft SQL Server\110\DAC\bin\SqlPackage.exe" |
| 105 | SQL Server 2008 R2 | "C:\Program Files (x86)\Microsoft SQL Server\105\DAC\bin\SqlPackage.exe" |
FAQ
❔How do I find the correct SqlPackage.exe path?
Use the tables above to match your SQL Server version and installation type.❔What if SqlPackage.exe is missing?*
Download and install the latest sqlpackage❔Can I use SqlPackageExecutable with older SQL Server versions?
Yes, but you must always use the latest version of SqlPackage.exe.
Further assistance is available in the Nodinite Troubleshooting guide.