1549690 - Crystal Reports with parameters prompts for database logon.

SAP Knowledge Base Article - Public

1549690 - Crystal Reports with parameters prompts for database logon.

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.

img1.jpg

  • Change the Identity to "NetworkService".

 img2.jpg

Note: The NetworkService account should have a login in SQL Server, and also permission on the Windows Temp folder.                                                                                                 

See Also

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