1 SSRS Landscape
Local SSRS Instance → Bitbucket Repo→ Deployment Server(SQL SERVER 2010) → Dev SSRS Reporting Server→ Visual Studio 2010 SP1 ( If this version is not available, please use Visual Studio 2012 ) → Push the files to Bitbucket Repo→ If you have SSRS 2010 then deploy to SSRS server directly else login to VM where SSRS 2010 is installed and deploy to Dev SSRS Server→ verify the changes(by Mark)→ deploy the report to Production SSRS Reporting Server.
2 Servers details
Note: Reporting server only opens in IE 11
| Sl no# | Client Name | Instance Name | URL | Description | ||||
|---|---|---|---|---|---|---|---|---|
| 1 | Internal QA | Dev Environments Folder Name: WFDemo_Internal | http://pe1950r2/ReportServer_SQLDEV2012 | 2 | Report access: http://pe1950r2/Reports_SQLDEV2012 | http://pe1950r2/ReportServer_SQLDEV2012 | 310.10.0.10/Reportserver_SQLDEV2012 | For Internal QA only. |
| 2 | ||||||||
| 3 | Eckerd (Internal QA) | Eckerd Development Folder: Eckerdtest | http://10.10.0.10/Reportserver_SQLDEV2012Eckerdtest | For Eckerd Database and folder name should be same | ||||
| 4 | Eckerd (Pre-Prod) | Eckerdtest - Demo https://r720DC.hq.empyra.com/Reports/Pages/Folder.aspx?ItemPath=%2fEckerdTest&ViewMode=List Folder: Eckerdtest | https://r720DC10.hq0.empyra0.com37/ReportServerEckerdtest | For Re-Prod. This is Production Reporting server having this folder. | ||||
| 5 | Eckerd (Prod) | Eckerd Live Folder : Eckerd | https://r720DC10.hq0.empyra0.com37/ReportServerEckerd | For Production | ||||
| 6 | Pilot Eckerd -- Other instances for Demo | Folder:Pilot_Eckerd https://r720DC.hq.empyra.com/ReportServer Folder:EmpyraSandbox1https://r720DC.hq.empyra.com/ReportServerEmpyraSandBox -- Folder:EmpyraSandBox | https://r720DC10.hq0.empyra0.com37/ReportServer -- Demo7 | Eckert Staff will do the testing in Pilot_Eckerd | ||||
| 7 | Development SQL Server | Dev SQL Server | ||||||
| 8 | Internal Development SSRS | yngempyra\developer D@v@lop@r | http://10.10.0.10/ReportServer_SQLDEV2012 -- Dev Server http://10.0.0.37/Reportserver -- Live serverhttp://10.10.0.10/Reports/Pages/Folder.aspx | yngempyra: Domain Name for development Report Server |
3 SSRS Projects Details
| Sl No | Project Name | Description |
|---|---|---|
| 1 |
...
#5 Post review , change the target settings for that particular project and deploy it to production. Note: This required approval from Mark and permission from Vinayak
11. List of DB Tables
Note: Above list may have more tables . Need to update
...