SQL Server Reporting Services

 > First install SQL Server

> Download and Install SQL Server Reporting Services

> Download and Install Microsoft Report Builder.

> When you install both

>Open "Report Server Configuration Manager"

>Than click on Desktop -LUDN019/SSRS >Click on Start

>Click on "Service Account"> Click on Use built in account and Virtual service account in (droptdown) and click on apply

>Click on "Webservice URL " > Enter Virtual Directory name to ReportServer and click on Apply

>Click on "Database"> Click on change database> Click on "choose an existing report database"> Click on next>Type SQL Server name "DESKTOP-LUDN019\sqlexpress">Select Authentication type to SQL Server Account> Enter User name and password> Click on test connection and click on Next> Select Report Server Database to Reportserver(dropdown)> Click on next> Click on Authentication Type and select SQL Server Credentials>Enter Username and Password> CLick on next> Click on next and finish

>Click on "Database"> Click on change credentials>Select Authentication Type to SQl server account> Enter User name and password.> Click on next>Enter Authentication Type to SQL Server Credentials> Enter User Name and password>Click on Next , Next and Finish.

> Click on "Web Portal URL"> Enter Virtual Directory to Reports

>Note:- Click on "Encryption keys"> Click on Delete the encryption keys.

> Click on "Web portal URL " and Click URLs "http://desktop-ludn019/Reports/"

>When Open URL in browser > Reports will be display and at last "Data Sources"

> Click on "Data Sources"> Click on "three dots" link and click on manage

> Check the checkbox "Enable this data source"

>Click on Type Under Connection> Select "Microsoft SQL Server" in drop down

>In the connection string type "Data Source=DESKTOP-LUDN019\sqlexpress;Initial Catalog=CBI; user id=sa;password=LIC@123" without quotes

> In the radiobox > click "using the following credentials " under "credentials"> Select the "Database Username and password in type of credentials" > Enter Username and Password and click on Test connection and Apply