Workflow Manager 6.0
Workflow Manager uses the value of connectionStrings setting in the web.config file to connect to the Workflow Manager database from ASP.net pages.
The default value of this setting is:
<connectionStrings>
<add name="DefaultConnectionString" connectionString="Data Source=SERVERNAME;
Initial Catalog=CATALOGNAME;Persist Security Info=True;User ID=sa;Password=sa"
providerName="System.Data.SqlClient"/>
</connectionStrings>
The first connection string, DefaultConnectionString, is used to describe the database that needs to be connected to from ASP.net pages.
The second connection string, StandardConnectionString, is used by the Report Control in Report Center.
To modify the database connection string for ASP.net pages, perform the following steps.
To modify the database connection string for ASP.net pages:
| 1. | Open the wwwroot directory of the Workflow Manager installation and open web.config in a text editor. |
| 2. | Locate the connectionStrings portion of this file. |
<connectionStrings>
<add name="DefaultConnectionString" connectionString="Data Source=TESTLABSQL2K;
Initial Catalog=WM31TO35;Persist Security Info=True;User ID=sa;Password=sa"
providerName="System.Data.SqlClient"/>
</connectionStrings>
| 3. | The first connection string, DefaultConnectionString, is used to describe the database that needs to be connected to from ASP.net pages. Modify this connection string by using the following syntax: |
|
String |
Default |
How to Modify |
|
Data Source |
Data Source=TESTLABSQL2K; |
Replace the default value for Data Source with the name of the database that you want to connect to: Data Source=MYDATABASE; |
|
Initial Catalog |
Initial Catalog=WM31TO35; |
The Initial Catalog string is used internally by AdminStudio Enterprise Server and should not be modified. |
|
Persist Security Info |
Persist Security Info=True; |
The Persist Security Info string specifies whether the connection persists (caches) the password information used while connecting, and should not be modified. |
|
User ID |
User ID=sa; |
Replace the value of User ID with a valid User ID for the specified database: User ID=myuserid; |
|
Password |
Password=sa; |
Replace the value of Password with a valid password for the specified database and User ID: Password=mypassword; |
| 4. | The second connection string, StandardConnectionString, is used by the Report Control in Report Center. Modify this connection string by using the following syntax: |
|
String |
Default |
How to Modify |
|
Data Source |
Data Source=TESTLABSQL2K; |
Replace the default value for Data Source with the name of the database that you want to connect to: Data Source=MYDATABASE; |
|
Persist Security Info |
Persist Security Info=True; |
The Persist Security Info string specifies whether the connection persists (caches) the password information used while connecting, and should not be modified. |
|
User ID |
User ID=sa; |
Replace the value of User ID with a valid User ID for the specified database: User ID=myuserid; |
|
Password |
Password=sa; |
Replace the value of Password with a valid password for the specified database and User ID: Password=mypassword; |
Workflow Manager 6.0 / AdminStudio Enterprise Server 11.5 Help LibraryJune 29, 2012 |
Copyright Information | Contact Us |