Changing the Consolidated Database DBA Password

Run the Interactive SQL utility (dbisql) to change the DBA password.

Prerequisites

Ensure runtime servers are stopped. In Windows, select Start > Programs > Sybase > Unwired Platform<version> > Stop Unwired Platform Services.

Task

Change to <UnwiredPlatform_InstallDir>\Servers\SQLAnywhere11\bin32, and run:
```
dbisql
```
Locate the database you are changing the password for:
1. Select ODBC data source name.
2. Click Browse.
3. Select the database. You may need to select Show all data sources to see all names used by Unwired Platform.
  For the consolidated database, choose default-CDB if you are using the default SQL Anywhere consolidated database.
4. Click OK.

Enter:

grant connect to dba identified by <NewPwd>

Execute the command by clicking the right arrow.
Exit dbisql.
Repeat these steps for the cluster database. If you are using the default DSN names, the cluster DSN is clusterdb_<clustername>.