Article - CS274473
Integrated Security for connections to Microsoft SQL Server from ThingWorx Platform
Modified: 21-Oct-2025
Applies To
- ThingWorx Platform 8.0 to 9.6
- Microsoft SQL Server
Description
- How to enable integrated security in JDBC Connection String to Microsoft SQL Server (MSSQL, MS SQL) as Primary Persistence Provider to ThingWorx
- Currently, username and password are required to be configured in the /ThingworxPlatform/platform-settings.json file but would like to unset these to use Integrated Security
- Setting Integrated Security on Database Thing or Secondary Persistence Provider
- Using Windows Authentication instead of Microsoft SQL Database User to connect to the Primary or Secondary Persistence Provider
- Windows Authentication for ThingWorx Platform connections to MS SQL
- Unable to connect to external MS SQL server database with Windows authentication
- Domain Account to facilitate MSSQL connections from ThingWorx Platform
- Unable to use the Database Thing connection to SQL Server Database using Windows Authentication
- JDBC connection setup in the Database Thing in ThingWorx only allows for either database accounts or to use the Windows account that is logged into the ThingWorx service on the application server
- Desire to use the following JDBC Connection String format in ThingWorx Platform:
-
jdbc:sqlserver://<ServerName>\\<InstanceName>:<Port>;databaseName=Thingworx;applicationName=Thingworx;integratedSecurity=true;
-
This is a printer-friendly version of Article 274473 and may be out of date. For the latest version click CS274473