March 8, 2006 at 2:12 pm
I'm receiving the following error when trying to view a Reporting Services AdventureWorks report:
But I'm able to view the data when I do a preview of the report in Visual Studio in BI Dev Studio. I'm using Windows authentication in the AdventureWorks data source.
March 9, 2006 at 4:23 am
if you haven't already, you need to add your Windows login as a SQL user to Adventure Works and give that login at least data reader permission.
I have seen it recommended that you use a generic reporting account rather than windows authentication... mainly in case someone puts something nasty in a report file and waits for a user with admin priviledges to run the report...
This code might create a new SQL account and make it a SQL administrator... which means that account is now a domain administrator and you have a problem...
With the generic login you can make it data reader only... so the user can only read data and not do much else...
HTH
Martin
March 10, 2006 at 2:03 am
hi frn,
Step 1: first create a user in the windows user
step 2: create a user in report server db installed in the sql . give the above created user name.
Step 3: assign the public and RSEXECrole to the user.
Step 4: go to the report Manager and select your report.
Step 5: select the properties and in that find the datasource. give the datasource and credentials.
Step 6: apply the configuration.
Step 7:now build and deploy the report.
Step 8:hope your work is done.
Happy Reporting.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply