If you are moving/changing databases, there are a number of locations that contain connection strings that must be updated. Note the below strings contain sample data.
Registry Key Location
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Metastorm\e-work\Engine\Database
- Connection = ODBC;DSN=bpmsql;UID=metastorm;PWD=metastorm;
Note that this references a 32-bit DSN. On 64-bit systems, use C:\WINDOWS\SYSWOW64\odbad32.exe to manage your 32-bit DSNs (the default ODBC Admin tool in Control Panel points to the 64-bit version)
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Metastorm\e-work\Engine\Database Connectors\Oracle DBC
- Connection = Provider=OraOLEDB.Oracle.1;Data Source=bpmoracle;User Id=metastorm;Password=metastorm;FetchSize=100;CacheType=Memory;PLSQLRSet=1;OLEDB.NET=True
- DotNetConnection = Data Source=bpmoracle;User ID=metastorm;Password=metastorm;
or
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Metastorm\e-work\Engine\Database Connectors\SQL Server DBC
- Connection = Provider=SQLOLEDB;Data Source=.\SQLEXPRESS;Initial Catalog=BPM9;User ID=metastorm;Password=metastorm;
- DotNetConnection = Data Source=.\SQLEXPRESS;Initial Catalog=BPM9;User ID=metastorm;Password=metastorm;
Files & Locations
- C:\Program Files (x86)\Metastorm\BPM\Administrative Tools\Service\web.config
- C:\Program Files (x86)\Metastorm\BPM\Deployment\DeploymentService.exe.config
- C:\Program Files (x86)\Metastorm\BPM\Engine\Diagnostics\ProcessDiagnosticsService\Web.config (Optional Component)
Designer:
Metastorm Eye -> Options -> Default Connection:
- Provider: SQL Server
- Server Name: MBPM2008X64
- Use a specific username and Password:
- User name: metastorm
- Password: metastorm
- Database name: BPM9
