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

Any way to change database level user password from CR development UI?

We have Crystal Report XI installed on our machine and using SQL Server 2008 as a database server. We would like to know is there any feature available in crystal report UI to change/control database level user password. Point here to note that user ID and password is required to establish crystal report connection to SQL server database. Here is the complete detail,

u2022 We have pre defined reports in our application and client version of crystal report installed on the same machine. We have also created a database level user to connect to database through Crystal Report UI using ODBC connection (DSN).

u2022 As per our database password policy, Database User level Password must be change within some period of time. Now problem here is every time users have to tell DBA to change their password.

We are looking for some solution such that users can change their password itself from Crystal Report development UI.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jul 20, 2011 at 04:17 PM

    Hello,

    So what you are asking is how to turn Crystal Reports into Microsoft SQL Server Management studio?

    Are you sure you want to do that? Anyone who got hold and ran that report would have the ability to change your database access and security....

    Crystal Reports does not and never will hold the password in the RPT file for obvious security reasons, so it's not Cr that is prompting you to log in it's the database client/server.

    Also, Cr XI does not support SQL 2008, you should be using CR XI R2 SP 6 minimum and using MS's new SQL Client Tool and SQL Native 10 driver.

    Scarily, if you can write a SQL statement to do then then create a Command and paste in the SQL, but I did not nor does SAP in any way shape or form support that. You are basically publishing how to hack into your database....

    You seriously need to talk to your Database Administrator, he can explain all of the security problems what you are attempting to do...

    Good luck

    Don

    Add a comment
    10|10000 characters needed characters exceeded

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.