Skip to Content
author's profile photo Former Member
Former Member

How to change password for RWDCOLL

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 08, 2012 at 10:46 PM

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

    Daniel

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 07, 2012 at 08:23 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • 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.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.