reporting services - How SSRS deployment works? -

we working on application asked generate reports. our immediate choice use ssrs. after studying tutorials completed designing of reports. however, not clear on how deploy ssrs project displaying them in gui environment.

my questions are:

• where should deploy project?
• if deploy in iis, server run it?
• does iis have capability run these?
• do need run report server run these reports?

please any clarification regarding these aspects.

i know how create reports, struggling basic concepts of ssrs. i.e. need more information on how setup in production environment.

there 3 parts every report let's cover first:

1. a datasource connection string or equivalent talk database, service or flat file. can contained in report or shared. shared matters in shared datasource may used 1 or many reports.

2. a dataset query, procedure or structure of obtaining data used in report. may contained in report or shared. again shared may used 1 or many reports , may cached on server.

3. the report itself. part rdl language proprietary microsoft language based in xml takes 1 or many table, matrix, chart or other display elements , presents data has been formatted viewing through 1 or many datasets talking 1 or many data sources.

deployment in simplest possible way bold @ bottom if familiar business intelligence development studio. there should checks done top down of few things checked first:

1. do have ssrs instance running on local instance or server in domain can talk to? need ensure server running ssrs on , working. on installation computer should find quite programs>microsoft sql server (vers)>configuration tools>reporting services configuration manager. once tool comes attempt prompt window servername , report server instance. default instance mssqlserver sql server standard or higher.

2. if works great, if not either never installed ssrs or service not running.

   **if believe did may not running service yet. go programs>microsoft sql server (vers)>configuration tools>sql server configuration manager. show services sql server running, including ssrs if installed correctly. when comes go 'sql server services' on left pane , should see equivalent of 'sql server reporting services (sql instance)'. if stopped, start it. if not there need insure installation of ssrs successful or may on machine.

3. if 2 successful can hit 'connect' , have few panes on left. time being deployment should focus on 2 of panes 'web service url' , 'report manager url'. 1 actual service , other hosting location user see. click on 'report manager url', should see virtual directory , link below. click on link , should able in.

   http:// (servername)/reports 

   if not in due not being administrator installed ssrs or equivalent admin. need admin on server installed ssrs , click on site. once in need add relevant users under "site settings" in upper right under security. not need under "folder settings" security again. if deploying , altering reports want 'admin' first site settings , 'content manager' second. need ensure dedicated users can page before continuing ensure can done.

4. once can above go ssrs config manager , click on 'web service url' on left pane. should see virtual directory, default 'reportserver', , identification section set port 80. below url commonly. click , ensure can go site well.

   http:// (servername)/reportserver 

   did notice url similar different above? huge step lot of people new ssrs miss , end having whole deployment process not work.

5. if can both url's above ready configure solution deployment. easiest method deploy code ssrs server visual studio add on labeled 'business intelligence development studio'. when should have installed ssrs, if on different machine may add on either sql server standard advanced tools or sql enterprise. versioning weird, should match visual studio edition sql server version except sql 2012, on vs 2010. if not sure can again under programs>microsoft sql server (vers)>business intelligence development studio or sql server data tools.

6. once have tool open , create new project 'report server project'. there tutorials on how work ide want focus on deployment should have 1 or many projects under solution. right click project , choose properties. ssrs deployment done. main properties such (i not go on all, may have more):

    overwrite datasets: false default (should kept, may override if need be)  overwrite datasources: false default (same above)  targetdatasetfolder: datasets(you can change if need be)  targetdatasourcefolder: data sources(same above)  targetserverurl: (blank) 

   the main key ssrs deployment 80% of people confused first deploy service not report manager url. put in http:// (servername)/reportserver targetserverurl, not other one. many people ssrs deployment not work them , ends being did targeting wrong.

7. final step: can create folders , datasources , deploy multiple locations @ once. careful, powerful thing set , aware of this. @ top of visual studio there ribbon 'configuration management' default selected show drop down 'debug'. click drop down arrow. should see 1 or many projects have , can choose 'build' or choose check 'deploy' option well. if wish build , deploy multiple environments or perhaps can set configuration different environments qa, dev, prod, etc here well.

   if want started bids follow step 6 , right click project , choose 'deploy'. deploy shared objects first (but not overwrite if set false) , reports. may highlight individual items , choose deploy well.