Print Page | Close Window

Crystal Reports asks for user/password in ActiveX

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=16328
Printed Date: 01 May 2024 at 10:57pm


Topic: Crystal Reports asks for user/password in ActiveX
Posted By: batmush1
Subject: Crystal Reports asks for user/password in ActiveX
Date Posted: 01 May 2012 at 2:40pm
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?


Print Page | Close Window