cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

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

0 Kudos

And, the only option is to use Trusted Authentication set up in SQL Server. then no user name or password is required, CR simply passes the Local PC Domain log on info to SQL to valid the user.

Don

Former Member
0 Kudos

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

0 Kudos

No there is nothing in CR to allow changing the PW in CR. All security is handled by the DB and Client.

Please mark as answered.

Don

Former Member
0 Kudos

Thanks Don!

Answers (0)