Cannot access Database

[CHUDMAN]

CE 10 Premium against DB2 database on Win 2000 advance servers

go to enterprise console of reports and select "New Report"
Create Report page opens
Defaults: Choose data source page, or no page opens
Business view contains nothing or on other machine nothing appears.

I need to be able to access the primary database to draw field from tables to develop a new report.

HELP Training Issue



Chad L. Miller
Configuration Analyst
SEI/CMM level 3 certified

http://www.lockheedmartin.com

 

[jraheja]

My first step would be to look at my DSN. Go to Start ->Settings->Control Panel->Administrative Tools->Data Sources. Try creating a new data source or (use the old one ) to your database and test the connectivity.

You can also try running a query against that datasource.

Also check the authentication. When you do a typical installtion fo Windows 2000 server it by default sets 'Windows Authentication'.