Database Logon Credentials

[MCuthill]

Hi Everyone,

I have encountered an issue that has come up before and I cannot remember how I fixed it previously.

I have a Crystal Report loaded on to Crystal Enterprise that runs off of 3 SQL Databases. It is giving me the "Database Logon" prompt for 2 of the 3 DB's (These two are newly created DB's for this report). I have previously created new SQL databases for other departments in the company for reports, and solved this issue.

In short, where do I go to remove this DB logon screen. I unchecked "Logon To Database".... but that just gives me an error.

Software:
Crystal Reports 10 Advanced Developer
Crystal Enterprise 10
SQL Server 2000

Thanks,


Mike
______________________________________________________________
"It Seems All My Problems Exist Between Keyboard and Chair"

 

[Turkbear]

Hi,
You need to set the database info in the CMC..go to the report(s), under Process..Database you can set each datasource used in the report to a default and saved username/password combo..





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[MCuthill]

Thanks Turkbear,

I had tinkered with those settings without success. Due to other issues that came up today, I came to realize that Crystal Enterprise is running some services on multiple servers. I had set up the ODBC's on one server, but not the second... ~sighs~ I knew I had handled this before... but didn't realized I was forgetting something THAT simple.



Mike
______________________________________________________________
"It Seems All My Problems Exist Between Keyboard and Chair"