dba password change...펌

Changing the Default DBA Password in Pylon Anywhere This document explains how to change the default password for the dba account of the Pylon Anywhere system database.

 

 

 

Overview

By default, the dba password for the Pylon Anywhere system database is pylonanywhere. It is important for administrators to change this password after installing Pylon Anywhere. The dba password can also be changed on a periodic basis if desired.

The following steps outline the process of changing the password associated with the dba account of the Pylon Anywhere system database, which is an Adaptive Server Anywhere database.

Changing the password in the database

1. Launch dbisqlc.exe from the DB directory of your Pylon Anywhere installation folder (typically C:\Program Files\Sybase\Pylon Anywhere) or database server machine. This program, Interactive SQL, is used to run SQL commands against the system database.
2. In the Connect to Adaptive Server Anywhere dialog, type dba in the User ID field, pylonanywhere (or your current dba password if already changed) in the Password field, and select Pylon Anywhere from the Data source name dropdown list. Click OK.
   
3. In the Command window, type GRANT CONNECT TO DBA IDENTIFIED BY new_password where new_password is the value you want to use for the new dba password. Click Execute.
   
4. Close Interactive SQL.
5. Verify that the password was updated correctly by repeating steps 1 and 2 using the new password value.

Updating the Pylon Anywhere Data Source

1. Launch the ODBC Data Source Administrator program by choosing Start > Run and entering odcad32.exe. This program is used to view and update ODBC Data Sources.
2. In the ODBC Data Source Name Administrator window, click the System DSN tab, select Pylon Anywhere, and click Configure.
   
3. Click the Login tab, and enter the new password value in the Password field.
4. To verify the connection to the database, click the ODBC tab and click the Test Connection button. If prompted with a message that says "The 'autostop' parameter is turned off. Would you like to leave the databse running after testing the connection?", select Yes. A "Connection successful" message should appear. Click OK and close the ODBC Data Source Administrator.

Updating the Pylon Anywhere Admin Console

1. Launch the Pylon Anywhere Admin Console from the Windows Start menu by choosing Start > Programs > Pylon Anywhere > Pylon Anywhere Admin Console.
2. Right-click on Pylon Anywhere Admin Console and choose Properties. Note that if you try to expand Pylon Anywhere Admin Console with the left mouse button, you will get an connection error since the Admin Console is not aware of the new database password.
   
3. On the General tab, and enter the new password value in the Password field.
   
4. As noted in the Admin Console, you will need to perform this step on all Pylon Anywhere servers in a clustered environment if applicable.
5. Click OK.
6. Restart the Pylon Anywhere server computer.

Verifying Success

After following these steps, verify that you can connect to the database using Interactive SQL (as outlined above), using the ODBC Data Source Administrator (as outlined above), and using the Pylon Anywhere Admin Console.