configuring ssrs, sql reporting services, ssrs, sql server 2008, bids, database programming, asp.net
Posted on 2013-05-17
I'm new to sql server reporting services.
I successfully configured the reporting services on my local machine, basically choosing all the default options during the configuration. Now i want to configure SSRS on my production server.
As a first step,
I created a windows user account and specified this as a report server Service Account instead of using built-in-account option.
for everything else i chose the default settings. On the Execution Account Tab, instructions reads the "this should be different from the service account" .
This is the part where i got confused. What is the difference between Service Account
and execution account.
I have a asp.net web application deployed in the same server/domain and i'm planning to use aspx page to display the reports. Do i have add another user for this and give only read permissions.
Also, after configuring the ssrs on production, when i navigate to the reportmanagerURL,
the page is blank, even when i run IE as admin and i'm logged in with admin login to the server.