CODEWITHSUNDEEP
reporting-servicesreporting
user1838149
user1838149

Reputation:

SSRS (reporting services) deploy

I deployed my report into the local server but when I click to open it then gives me the following error. Do u have any idea to overcome this issue? 

       •    An error occurred during client rendering. 
       o    An error has occurred during report processing. (rsProcessingAborted) 
           Cannot create a connection to data source 'DataSource1'.
                (rsErrorOpeningConnection) 
           The Microsoft Office Access database engine cannot open or write 
               to the file 'C:\Users\USER\Desktop\okul.accdb'. 
               It is already opened exclusively by another user, 
               or you need permission to view and write its data.

Upvotes: 0

Views: 349

Answers (1)

eestein
eestein

Reputation: 5114

You should try checking if the account used by SSRS has the modify permission on that file folder.

You can do that through RSCM (Reporting Services Configuration Manager). You can even add a local admin account if that's a dev machine. Click on "Service Account" and configure it your way.

Should you need, here's more detailed information on how to do that:

http://technet.microsoft.com/en-us/library/bb522727(v=sql.105).aspx

Upvotes: 1

Related Questions