Hello all, I'm using Sqlserver 2008 R2 Developer edition and i've created the small report and it is working in my computer , when I'm browsing form another computer it is not working for another user and I have give full access. An error has occurred during report processing. (rsProcessingAborted) Cannot create a connection to data source 'MyDB_TEST'. (rsErrorOpeningConnection) For more information about this error navigate to the report server on the local server machine, or enable remote errors Regards, Vik

How is your datasource configured? Are the credentials stored on the report server?

How is your dataset configured? Are the credentials stored on the report server?

I used embeded dataset in my report... Could you explain what credentials are to be stored in the Report Server. Regards, Vik Regards, Vik

What credentials are you using in your dataset?

I didn't use any credentials while creating data set.Regards, Vik

Sorry I mean the data source.

I checked the data source (Shared data source) properties. Its showing do not use credentialsRegards, Vik

You'll see the following options in data source properties. Please let us know which one among the following have you selected. <label for="ui_rdoPromptUser">Credentials supplied by the user running the report</label> <label for="ui_rdoStored">Credentials stored securely in the report server</label> <label for="ui_rdoIntegrated">Windows integrated security</label> <label for="ui_rdoNone">Credentials are not required</label>

Windows integrated securityRegards, Vik

Hi, Try this:- 1. Go to your Shared Data Source, open the one which you are using for your rdl file. 2. General Tab, click on "edit button" 3. Select "Use Windows Authentication" also double check your Server-Name & Database-Name and hit "Test connection". 4. If Tested successfully than hit OK OK twice. Now see by previewing your rdl file. Please let us know your feedback. Thanks KumarKG, MCTS

@ Kumar . I followed the steps you provided. and tried to access the report on another machine in the same network but getting the same error.Regards, Vik

Hi Vik, Is everything working on BIDS side? Let us go step by step process. Thanks KumarKG, MCTS

I used Report Builder to build report and deployed it on Report server.Regards, Vik

Hi Vik, Please double check your DataSource "MyDB_TEST" on your Report Server. Is it Tested successfully? Thanks KumarKG, MCTS

YES Connection is successful..Regards, Vik

Hi, Now, try re-attached the above successful DataSource to your report file and Apply and preview the report. Does that help you out? Thanks KumarKG, MCTS

Are you sure that the other user has required access to SQL Server?

@ Shahfaisal I m using SQL server developer edition. IS that the reason why i am unable to get the report on another machine.Regards, Vik

@ Kumar I tried re-attaching the above successful DataSource to your report file. But couldn't access the report on another machine. Regards, Vik

I have figured it out. Solution for above problem is I Mgt Studio. Add the user as a Login. then Click Properties and navigate to User Mappings page Put a check mark on the Database that the report is trying to access (apart from ReportServer and ReportServerTempDB) Regards, Vik

That is what I meant when I said - Are you sure that the other user has required access to SQL Server?