by Santhakumar Munuswamy
Posted on 01 January 2017
SSRS
In this article. We will discuss in detail about the SSDT 2016, Prerequisite, Setting up the Environment, How to Start/Stop the Report Server, How to run the Web Service Url using Reporting Services Configuration Manager and so on. As you all know the previous version of SSDT and we will see about SSDT 2016 as now
- What's SSDT 2016?
- Prerequisite
- Setting up the Environment
- How to Start / Stop Reporting Server
- How to run Report Server Webservice URL
What’s SSDT 2016?
SQL Server Data Tool is a modern development tool. It's an available many package such as Relational databases, Azure SQL databases, Integration Services packages, Analysis Services data models, and Reporting Services report. As you all know the SSDT, you can easily design the report and deploy the report in the SQL Server. Similarly, you can develop an application and deploy using Visual Studio.
Prerequisite
We will see in detail about the minimum prerequisite of SSDT 2016, as given below
- SQL Server Data Tools 16.5
Supported SQL Server Versions
S. No | Packages | SQL Server supported version |
1. | Relational databases | SQL Server 2005 - 2016 Azure SQL database and Data Warehouse (supports only SQL queries) |
2. | Analysis Services models | SQL Server 2008 - 2016 |
3. | Reporting Services reports | SQL Server 2008 - 2016 |
4. | Integration Services packages | SQL Server 2012 - 2016 |
Setting up the Environment
We will discuss in detail about the SQL Server Data Tools 2016 installation procedure with step by step guide as below
Go to Microsoft SQL Server Management Tool Downloads page and download the SSDT 16.5 version to your PC
Go to SQL Server 2016 Setup Folder, and double click the SSDTSetup.exe
The Microsoft SQL Server Data Tools 2015 window will open and verify all the features are checked. Then, Click the Next button.
The License Terms window will open and check the license terms checkbox. Then, Click the Install button.
The Setup Progress window will open
The Setup Successful window will open and Click the Restart button
How to Start / Stop Reporting Server using Reporting Services Configuration Manager
Go to All Programs, you can find the Microsoft SQL Server 2016 and then view the Configuration Tools. Now, Click the Reporting Services Configuration Manager
The Reporting Services Configuration Manager window will open and verify the Server Name and Report Server Instance. Then, Click the Connect button.
The Report Server status window will open and Click the Start button.
After, you can see the successfully started Report Server information. Now, you can verify the Report Service Status as started.
The Report Server status window will open and click the Stop button
How to run ReportServer Webservice URL on the Browsers
First of all, you have to open the Reporting Services Configuration Manager and connect the Report Server option. After, Click the Start button and once the Report Server as started. Then, Click the Web Service Url navigation and verify the Virtual Directory, IP Address, Port, URLs.
As far now, you can copy the Url and past on the Browser
Reference
Conclusion
I hope you understood SSDT 2016 installation guidelines, Start/Stop the Report Server, Run the Web Service Url on the browser and so on. I have covered all the required things. If you find anything which I missed in this article, please let me know. Please share your valuable feedback or comments and suggestions to improve future articles.