Workflow Manager 2018
Workflow Manager uses the value of SQLConnectionString setting in the web.config file to connect to the Workflow Manager database from .asp pages. The default value of this setting is:
<!--Database connection string for ASP pages-->
<add key="SQLConnectionString" value="Driver={SQL Server}; server=.; database=wm; uid=sa; pwd=sa; Max Pool Size=50000;"/>
To modify the database connection string for .asp pages, perform the following steps.
To modify the database connection string for .asp pages:
1. | Open the wwwroot directory of the Workflow Manager installation and open web.config in a text editor. |
2. | Locate the Database connection string for ASP pages portion of this file. |
<add key="SQLConnectionString" value="Driver={SQL Server}; server=.; database=wm; uid=sa; pwd=sa; Max Pool Size=50000;"/>
3. | Modify the database connection string using the following syntax: |
String |
Default |
How to Modify |
Server Name |
server=.; |
Replace the default value for server (a period) with the name of the server that contains the database that you want to connect to: server=myservername; |
Database Name |
database=wms; |
Replace the value for database with the name of the database that you want to connect to: database=mydatabasename; |
User ID |
uid=sa; |
Replace the value of uid with a valid User ID for the specified database: uid=myuserid; |
Password |
pwd=sa |
Replace the value of pwd with a valid password for the specified database and User ID: pwd=mypassword; |
Workflow Manager 201831 October 2018 |
Copyright Information | Flexera |