Data Connectivity: Published report asking for credentials

Print Page | Close Window

Published report asking for credentials

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=4809
Printed Date: 16 May 2024 at 9:45pm

Topic: Published report asking for credentials

Posted By: kolsby
Subject: Published report asking for credentials
Date Posted: 14 Nov 2008 at 10:15am

I am brand new to Crystal (1 week) so bear with me please.

I have created a crystal report from an access database. Although this access database doesn't have any security itself one of its tables is linked to a SQL server through ODBC. When i create a report in Crystal using the Access database it works great. When i publish this report to the server it wants some type of login information.

Under Database configuration (CMC) for the report i seem to have two options.
1)Use original database logon information from the report.
    Server = Location of my access database
    Database = ""
    User: ?
    PW:?
or

2) Use custom database logon information specified here.
     Select a database driver
    Server: ? Is this the SQL server or the server where my access database is contained?
     Database: ? same question
     User: ? Is this the sql user?

I have tried both can't get it to work. What login information does it want? Does it want the sql login information? What am i missing? Any help would be great. I know this is a lot of questinons but i am stumped.
thanks

Print Page | Close Window