Integrated Security for Database
How I can use integrated security database information for crystal server?
I designed few reports using SQL Server and integrated security, I'm able to view and execute reports in Crystal Designer but I couldn't found any way to setup database information using integrated security in Crystal Server XI.
Can someone help?
Tim Ziemba replied
You will need to save the report to the server after selecting the trusted connection.
then on the server insure that an ODBC trusted connection exists as well (should be able to test from CR on the server if it's installed)
finally in the CMC report properties > process > database you must select "Use same database logon as when report is run" and enter the AD username and password to be used for the report.
If you would like a more dynamic solution where the actual user credentials are sent to the DB look up SSO to the DB in our admin guides and white papers on the business objects XIR2 articles section. This can also be achieved by setting up kerberos delegation.