Crystal RAS 9 - Windows Authentication

[JohnCosta]

I have some reports that access a remote SQL-Server machine. All report users have been set up on the SQL-Server machine and I want to be able to use Windows-NT authentication so I don't have to worry about maintaining passwords for each account.

As long as users are using the Crystal Reports 9 client on their PCs and they have a system DSN setup using 'Windows Authentication', they are able to run the reports fine.

It's when I migrate those reports to a web server that I run into problems. If I have the users attempt to run the same reports from a web server, they are continually prompted for their credentials. When they try to submit those credentials, the 'Database Logon' screen just refreshes.

How can I enable Windows Authentication via Crystal RAS / IIS on the web server so that the user IDs and passwords are recognized on the SQL Server machine?

 

[vidru]

Have a look at these:

http://support.businessobjects.com/library/kbase/articles/c2014691.asp

http://support.businessobjects.com/library/kbase/articles/c2014338.asp

-dave

 

[JohnCosta]

Vidru,

Thanks for your quick reply, but I'm still posed with an authentication problem.

I modifed the startup account for Crystal RAS on my web server. However, now when users run the reports, it's not there own user ID that is validated against SQL-Server, it's the account that Crystal RAS uses to start up as a service.

What I need is each individuals own user ID and password to be validated as this is what I use to determine what data he/she has access to in SQL-Server.

Any ideas?

 

[Turkbear]

Hi,
IIRC, the RAS server's account is always going to be the account that connects to the database..You would need to put code in the report that does the data screening based on the user's ID.




To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[JohnCosta]

Thanks Turk,

Can you provide any links or further info on how this would be implemented. Is this what's referrred to as "impersonation" within Crystal? (I've been on the internet all morning trying to find a solution.)

 

[Turkbear]

Hi,
Sorry, I don't work with RAS enough to show you any code samples, but it would involve setting the login info based on the users ID when creating the report object's database connection info..Yor web page code may be able to get the Cilent's userid ( from IIS' server variables maybe?)





To Paraphrase:"The Help you get is proportional to the Help you give.."