Alok Notes

Embedded and Shared Data Sources is used in SSRS.Datasource is one of the mandatory components/parts of SSRS. In Embedded Datasource, Datasource is embedded in the report projects and it is not accessible by the other SSRS report projects. In Shared Datasoruce ,Datasource is share and it can be access by the other SSRS report proejcts.

How SSRS reports files transfer from development to Production when SSRS reports delpoy Actually In SSRS when we deploy the reports then *.rdl(report file) and *.rds datasource file does not upload to server using deploy command(right click on *.rdl file) of visual studio IDE solution explore. In real data record or meta data information moves/insert in report server database which was configured using SSRS configuration window. All the information like datasource and .rdl file information/meta data saved in report server database. *.rdl file informaiton save in xml format in the report server database and same as datasource.

The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) This Error throws when we try to access/browse the SSRS Report manager link/URL through Report services configuration manager window. This error due to missing database or data source for the reports.Configure database or report database through eport services configuration manager window(Mentioned/specify data source ,username and password).