Hi all,

I'm new here but have extensive experience in Crystal reports and will try to benefit the forum.

Does anyone know what is the trick to make ActiveX viewer for Crystal Reports to show the reports without asking for user ID and password. Here is the situation:

working setup: Baan 4c4, SQL 2000, ODBC through Windows Authentication, same physical box Windows 2000, users are using ActiveX viewer through IIS website (tens of reports are working)

new setup that is not working: Baan 4c4 on Windows server 2008, SQL 2008 R2 on another Windows Server 2008, IIS is on XP machine with Crystal Reports installed, ODBC configured same as before, reports work from Crystal Developer but ... when users go to IIS website and click report link it bring the ActiveX viewer and ask for user/password.

I believe something is in SQL 2008 security? Maybe some one has similar setup (not even Baan 4c4) and can give hints?