February 8, 2013 at 1:41 am
Hi
I want to present to management about moving our reports into SSRS and need assistance in answering this question.
When an SSRS report is deployed does the database travel with the report or only the connection settigs travel.
When the user interacts with the report via the browser then a message is sent to sql, sql runs the query and then results are sent to the browser - is this correct?
Does the user need to have access to the database in order to view the report?
I plan on deploying the reports to sharepoint, is there a risk of ssrs bringing sharepoint down?
Thank you for your assitance.
February 8, 2013 at 8:55 am
SceloM (2/8/2013)
HiI want to present to management about moving our reports into SSRS and need assistance in answering this question.
When an SSRS report is deployed does the database travel with the report or only the connection settigs travel.
When the user interacts with the report via the browser then a message is sent to sql, sql runs the query and then results are sent to the browser - is this correct?
Does the user need to have access to the database in order to view the report?
I plan on deploying the reports to sharepoint, is there a risk of ssrs bringing sharepoint down?
Thank you for your assitance.
Having an effective SSRS deployment isn't as easy as it seems.
What is your current system and why are you changing platforms?
The database never "travels" anywhere it's always at the same place. You define connection string and that's either embedded in the report or on the SSRS server if it's a shared data source. They are encrypted.
You can use whatever credentials you want for the data sources (AD, SQL etc) The user doesn't have to have rights on the database.
Read through BOL
http://msdn.microsoft.com/en-us/library/ms159106
---------------------------------------------------------------
Mike Hahn - MCSomething someday:-)
Right way to ask for help!!
http://www.sqlservercentral.com/articles/Best+Practices/61537/
I post so I can see my avatar :hehe:
I want a personal webpage 😎
I want to win the lotto 😀
I want a gf like Tiffa :w00t: Oh wait I'm married!:-D
February 10, 2013 at 11:02 pm
Thank you.
I will go through the link that you provided.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply