Crystal Reports Server

[mattr555]

I have installed the crystal reports server and can get a report to get served to my browser but the report prompts for the DSN connection information to connect to the SQL Server.

Does anyone know of a way of automatically parsing this information to the report. Ive tried a system and file DSN and tried including the line PWD=password in the file DSN but nothing seems to work.

Our intranet uses NT Integrated Authentication and ideally i'd like to use this to seamlessly control rights to my crystal reports and not use a SQL Server user account.