Symptom
- When a web application is run on a client machine or on a server to view Crystal Reports using parameters, it prompts for login
- Same report runs on the development machine without prompting for login.
Environment
- Windows Server 2008 (64 bit).
- Visual Studio 2010.
- CRVS2010
- Web application.
Reproducing the Issue
- Create a report using parameters.
- Use windows authentication (Integrated Security) for retrieving data.
Resolution
- Go to IIS.
- Right Click on the 'Application Pool' used by application > Advanced Settings.
- In Advanced Settings, under 'Process Model' section, select Identity.
- Change the Identity to "NetworkService".
Note: The NetworkService account should have a login in SQL Server, and also permission on the Windows Temp folder.
See Also
- SAP Knowledge Base Article 1412611 - Crystal Reports 2008 using Dynamic parameters, prompts for database logon when used In Visual Studio .NET
Keywords
logon, login, database, parameters, CRVS2010, VS2010, .NET SDK, parameter , KBA , BI-DEV-NET , BI Software Development Kits (SDKs) - .NET or Other , Problem
Product
SAP Crystal Reports, developer version for Microsoft Visual Studio