Vignette Service unable to connect database.

[Former Member]

Hello!

There is an error after updating SPP 4.4 -> 4.5.

First - the collaboration database user password has changed and I started the installation with update option.

The installatuion dialog asked to provide database type and credentials.

After the setup program has finished - the Vignette service unable to start - Log file says that the database user\password is incorrect.

How can I check and update this information for my server at SPP 4.5?

[Former Member · Accepted solution]

On the destination uPerform application server, browse to the [install

location]\Collaboration\conf folder.

2. Make a copy of the startup.props file for backup purposes.

3. Open the startup.props file in a text editor.

4. Perform the following modifications:

a. Change db.dbPassword_encrypted=[encrypted password] to

db.dbPassword=[newCollaborationUserPassword], where

[newCollaborationUserPassword] is the password you specified on the SQL

server.

NOTE: Be sure to remove _encrypted from the db.dbPassword parameter.

5. Add the following line to the startup.props file:

db.encrypt=true

6. Save and close the startup.props file.

7. Open a command prompt.

8. Browse to the [install location]\Collaboration\bin folder.

9. Execute the batch file registerAOs.bat

[Former Member]

Hi Makhail,

The default password for uperform_admin  and upsInternalUser is RWD@dm1nP@ssw0rd.  - i suspect the user "uPerformUser3" is the same.

You may be able to change the password for the Collaboration database user from the "startup.props" file within "C:\RWDuPerform\Collaboration\conf" and system starts up without any problems.

Regards,

Matthew

[Former Member]

Hi Matthew,

Thanks for your reply!

The startup.props file contains db.password_encrypted parameter. I suppose this is some hash from encrypted password. I do not know how to change this password.