on 07-20-2011 4:38 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Don for the useful info!
I understand the security risk but I only wanted to know if there is any interface available in crystal report which allows user to change their database connection password after the authentication has been succeeded. I will check the option to use Trusted Authentication set up in SQL Server and how it can be integrated to fulfill the requirement.
Regards,
Arsh
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.