How to change password for RWDCOLL

[Former Member]

Hi Everyone,

We have RWD 4.3 sp2 with MSSQL 2008.

Because of an error I had to change the password of the the database user RWDCOLL.

Now The RWD uPerform does not start. In the logfile I found the error

Caused by: java.sql.SQLInvalidAuthorizationSpecException: [Vignette Corp.][SQLServer JDBC Driver][SQLServer]Login failed for user 'rwdcoll'.

I was searching here in SapNet, Ancile and general in the Internet but I cannot find a Note how i can change the Password within the RWD uPerform software.

I hope you can help me.

Best Regards

Daniel

[Former Member · Accepted solution]

Ok guys, Thanks for your help. I found one posible solution. that is uninstall RWD and install it again.

Daniel

[satishra]

Did you see that error message in collabconsole.txt ?

does the Collab User has DBA authorization granted..

Can you make sure the collab user has following authorization on Collab Database..

SELECT - Grant

INSERT - Grant

UPDATE - Grant

DELETE - Grant

CONTROL - Yes

ALTER - Grant

INDEX - Grant

REFERENCES - Grant

If not, grant the access...restart the database and try.

and if it still does't resolve your issue, try  removing the 'Database

administrator authority' from the user and restart the database.

Restart the Vignette Collaboration service on the application server and

test the functionality.

[Former Member]

Thanks for your answer. Maybe I didn´t Explain myself.

Everything was working fine. But because of en error I had to change the Password for user rwdcoll in the Database. So i changed it. But now uPerform cannot connect to the database because of the password change.

I cannot change the password back. On the other hand I dont know where I can change the password within uPerform Software.

There is no problem with the authorization, The only problem is the password change.

Yes the error is from the collabconsole.txt.

Best Regards.