CR 2008 Enterprise and Access DB's

[kray4660]

We have CR 2008 Enterprised installed on a Windows 2008 Server 64 bit virtualized server. All our report work except the ones that have a data source of Access on a Novell server. I do not recall the exact error message, but it basically telling us we do not have rights to the data. If we copy the DB to the server we do not have an issue. If we use CR 2008 on the server (not Enterprise) we do not have an issue.

SAP has been working with us on this issue for months with no resolution. I was wondering if someone out there has run into the same issue and found a resolution.

 

[briangriffin]

In the CCM, make sure that the domain account that you use for the SIA has Windows rights to the server/directory where the Access db resides.

 

[kray4660]

This is a novell directory setup, so there is no domain (at least that is what I was told).

 

[briangriffin]

Not too familiar with the current Novell setup, but it still seems like a permissions issue.

Log into any Windows workstation using the SIA's Windows credentials. Then do what you need to do to navigate to the directory containing the db. If you can, it's a different problem. If you can't, have your Novell guy configure it so you can.

 

[kray4660]

According to the DBA, there is no SIA user. According to what he has read, the newest version loads the SIA as a service, but other versions run as a assembly.

Thanks.

 

[briangriffin]

In the Central Configuration Manager, you'll see the SIA, which does run as a Windows service. Click Properties and see what account is being used.

The DBA may be saying that the SIA is running under the local system account. If so, that explains your problem since that account can't access network resources.

Most companies create a domain user for this purpose - BOE_System, or something similar. Then grant rights to that account to access network drives, printers, etc.

You would also have to do this if you wanted the output of a scheduled report to go to a directory not on the server.