Reports wont run via Crystal Report Server XI

Further info,

The server which has BO on is part of the domain and it has System DSNs setup to the database server. The error indicates its a credentials issue so it must be to do with what BO are trying to pass in terms of credentials, how do I set what parameters are used by BO?

Is the ODBC connection a system or user connection?

mlmcc

Its a system DSN mlmcc, Ive duplicate what DSNs are on the existing BOE server over to this new server and Ive tested to ensure they can access the databases which are in the report Im trying to schedule.

I think everything points to the DSNs but Im at a loss why the BOE wont run the report??

Does everyone have permission to the dsn?

I use them but only on my machine as the only user.  Not sure if there are permissions to grant to non-admin users.

mlmcc

Not sure how to grant permissions to the dsn? Ive gone through the config of the dsn but cannot find anything which allows me to set permissions.

Where would I do that change too?

Are you attempting to schedule the report with an AD User ID rather than a SQL Server User ID

The report is being run with AD credentials.

That's the problem.  I've had issues with this, too.  The easiest fix is to create a SQL Server system account (preferably with non-expiring credentials) and schedule against that.

If you create your ODBC DSN with Windows Authentication then you need to ensure the account that's running Crystal Reports Server also has an account on the database.

By default, Crystal Reports server runs against a Local System Account.  You logon to the server with your own credentials and create an  ODBC DSN with Windows Authentication and test it.   The problem is the DSN is using the ID of whomever is logged in, you in this case.  So, you need to run CRS as an AD system account with non-expiring credentials (a user like "domain\CRSUser", for example).  This should be a domain account that is part of the Administrator's group on the server running CRS.  Then, ensure that the service account has the appropriate rights to the database.

You should then be able to logon to the server as the domain account, and test connectivity through ODBC DSN using Windows Authentication.

Here are the individual steps:

1)  Create a domain account with non-expiring credentials
2) Add this user to the Administrators group on the server running CRS
3) Add this user to the appropriate database(s) with the correct level of permissions
4)  Go into the Central Configuration Manager, stop the SIA, and change the user to the domain user, apply and restart the  SIA
5)  Logoff the server and logon as the domain account and test whether or not the domain account can successfully connect to the database using Windows Authentication in your existing system DSN.
6)  Once you've successfully tested connectivity, logon to the CMC and configure the database connection for the report(s) in question.  You can try using either the domain name by itself or the full domain\user.
7) Test schedule the report to ensure it works..

rhinok - thank you for responding.

Im using the domain administrator account which is not set to expire. The account has been added to the administrators group.

The account has been added to the appropriate databases

I can confirm the dsn works with this account.

Point 4 - I cannot find the SIA service to stop?? Where is this?

D

also, point 6 - can you add a bit more detail for me?

Re: #4 - In the program's list, under your Crystal Reports Server folder, you'll see something called Central Configuration Manager (CCM) and there will generally be 2-3 services running:

1)  Tomcat - installed if you selected it
2)  World Wide Web Publishing Service (IIS) - installed if you selected it
3)  Server Intelligence Agent (SIA) - runs Crystal Reports Server

Stop the SIA, right-click it and go into properties.  You'll see it's running under the Local System Account.  You'll need to change this to domain\user and the password appropriate to that user.  Once you've done this and applied the changes, restart the service.

Re: #6 - If you login to the Central Management Console (CMC) and drill down through folders to a report then you can right-click a report and choose "Database Configuration".   This is where you'll enter the credentials for the report to be able to connect to the database.  I would try domain\user as the user with the correct password and apply the changes.

Ok, Ive got a report to run via the schedule. I had to drill down to the report and then click on the database and use the NT credentials I created (domain admin account).

I have quick a few reports to do, is there a global setting I can change so all reports which are run on the serevr use the nt credentials? I would be a real pain to set the credentials each time a setup a new report. On my old installation of crystal server - i never had to set the credentials.

Ok, thats great - Im able to get into this and set the credentials all at once.<br /><br />Thanks for you help, its appreciated.