Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Connecting to the utility database allows you to execute database file administration statements, query connection and server properties, and connect to a running database server when it is not possible to connect to the database.
The -su database server option specifies the password for the utility database. To connect to a utility database on a server that was started using the -su option, you need the password that was set by the -su option.
If the -su database server option was not specified for a network server, then you cannot connect to the utility database.
If the -su database server option was not specified for a personal server, you can connect to the utility database and you do not need a password.
Context and remarks
You have a running database server and you want to connect to its utility database.
If the database server is a network server (dbsrv16), then it was started using the -su option and you have this password.
dbsrv16 -n server-name -su password
If the database server is a personal server (dbeng16), then either it was started using the -su option and the utility database has a password, or it was started without the -su option and the utility database has no password.
dbeng16 -n server-name
Start Interactive SQL or Sybase Central.
In the Connect window, specify the following information.
In the User ID field, type DBA.
In the Password field:
|Personal server (dbeng16)||
If the -su option was not specified, then type any non-blank password. The password itself is not checked but the field must not be empty.
If the -su option was specified, then type the set password.
|Network server (dbsrv16)||Type the password specified by the -su option.|
In the Action dropdown list, click Connect To A Running Database On This Computer.
In the Database Name field, type utility_db.
In the Server Name field, type server-name.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|