Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Datasource login issues

Status
Not open for further replies.

jckauffman

IS-IT--Management
Aug 6, 2009
1
US
Hello everyone,

Are there any quirks to using an Access datasource for a report in crystal enterprise XI you can tell me about?

The reports (predate my hiring) have both an MS SQL and Access datasources. The Access datasource suddenly began requiring a username/password overnight and no credentials supplied work. I've cleared any users from the Access db and specified them with passwords all to no avail.

I can run preview the report on my local machine, in crystal, just fine wthout supplying any credentials.

I've tried every combination of settings in CMC and nothing's working. To make this more confusing, this happened overnight without any apparent changes to the environment.

Thanks in advance.
 
Hi,
Be sure that the XI servers are running under an account with full access rights to the file system and the database.





[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top