Access DB as SSRS Datasource

[scoobyroo]

We have an Access 2007 database that is used as a datasource for a SSRS report. When previewing the report in Visual Studio, the report renders fine. When trying to run the report from Reporting Services, we get the following error: An error has occurred during report processing. Cannot create a connection to data source 'CapitalNotes'. For more information about this error navigate to the report server on the local server machine, or enable remote errors.

We have tried Windows Authentication, No Credentials and Credentials stored securely in the report server. Same error every time.

We have moved the database to the Reporting Services server to see if it was a permissions issue with the database since it was sitting in a folder not accessible to everyone, but still get the same error.

Any advice or suggestions would be appreciated. We are assuming it is a permissions issue, but can't figure out where we are going wrong.

 

[SQLScholar]

What account is reporting services running under? does that have access to the folder?

----------------------------------------

http://www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

 

[scoobyroo]

Here lies one of the problems. I don't have access to see what account the reporting services runs as and the person who does has no idea what he is doing. Can you tell me how to check so I can tell him step by step what to do?

 

[xlbo]

reporting services should be running either as the person who invokes the report or as a service account (hard coded user and password)

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question