Run the Interactive SQL utility (dbisql) to change the DBA password.
Prerequisites
Ensure runtime servers are stopped. In Windows, select .
-
Change to <UnwiredPlatform_InstallDir>\Servers\SQLAnywhere11\bin32, and run:
dbisql
-
Locate the database you are changing the password for:
-
Select ODBC data source name.
-
Click Browse.
-
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.
-
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>.