SQL Server Reporting Services (SSRS) is a server-based reporting platform by Microsoft that enables the creation, management, and delivery of interactive and paginated reports. SSRS allows users to design reports with various data sources, customize report layouts, and distribute reports to users through multiple channels.
Prerequisites
SSRS can be installed using the Tessell option profile.
For SSRS to work, the instances have to be integrated with the Microsoft active directory domain.
You would require the below properties to be set to 1 in parameter groups.
“xp_cmdshell“ → It is recommended to turn it off once the package is imported into the Tessell SQL Server host.
Granting Permissions
Before deploying and managing reports in SSRS, you need to grant appropriate permissions using the db user account.
Stored procedure msdb.dbo.t_sp_grant_ssrs_permissions takes “system administrator“ and “system user“ roles
use master
go
EXEC msdb.dbo.t_sp_grant_ssrs_permissions 'tesl\admin','System Administrator'
go
Connectivity
SSRS web service portal can be accessed through. endpoint and the port number where the port is running.
https://<TESSELLENDPOINT>:port/Reports
Configuring SSRS
To configure SSRS for optimal performance and functionality, consider the following:
Access the SSRS web portal and navigate to the "Site Settings" section.
Review and configure the general settings, such as the report server name, encryption settings, and email delivery options.
Verify and adjust the security settings to ensure only authorized users have access to reports and sensitive information.
Configure data source settings to establish connections to databases or other data sources required for report generation.
Set up scheduling and subscription options for automated report delivery.
Customize the SSRS web portal appearance and branding, if desired.
Deployment
To deploy reports in SSRS, follow these steps:
Access the SSRS web portal and navigate to the folder where you want to deploy the report.
Click on the "Upload" or "New" button, depending on your SSRS version.
Use the report server URL as the deployment option.
Configure report properties, such as the display name, description, and parameters, if applicable.
Verify the report's data sources and ensure they are correctly configured to retrieve data.
Save the report to complete the deployment process.
