Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: RAS prompt for the DB logon credentials Post Reply Post New Topic
Author Message
jaramin
Newbie
Newbie


Joined: 31 May 2010
Online Status: Offline
Posts: 2
Quote jaramin Replybullet Topic: RAS prompt for the DB logon credentials
    Posted: 31 May 2010 at 8:44am
Hi, I designed a report using crystal report XI, I use a store procedure from database in SQL 2005.
My connection data is:
Database type: OLEDB (ADO)
Provider: SQLOLEDB
DataSource: MAR1ACCT01
Initial Catalog: Request
User Id: sa
Integrated Security: false
Use DSN default properties: False
 
This report work fine from Crystal XI but when I copied this report in Report Application Server of Crystal Enterprise 9 the report prompt for the DB logon credentials, I dont want to enter logon credentials this must be automatically.
 
How do I do it?
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 02 Jun 2010 at 6:57am
You need to log in to the CMC for Crystal Enterprise, locate the report, and edit the properties to include the database login.  You'll need to do this every time you add a new report or update an existing report in CE.
 
-Dell


Edited by hilfy - 02 Jun 2010 at 6:57am
IP IP Logged
jaramin
Newbie
Newbie


Joined: 31 May 2010
Online Status: Offline
Posts: 2
Quote jaramin Replybullet Posted: 02 Jun 2010 at 7:57am
Sorry but I don't have CMC for Crystal Enterprise, I only have in menu start > All programs > Crystal Enterprise 9 > Tools > RAS Configuration Manager
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 02 Jun 2010 at 8:19am

I'm not super-familiar wiht CE, I assumed it operated like BOE.  Where do you go to add folders, users, etc to CE?  That tool should give you the ability to set the properties on the individual reports.

-Dell

IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.