In this article, we will discuss in detail about SSDT 2016. We will learn the following with reference to SSDT 2016 now.
- What's SSDT 2016?
- Prerequisite
- Setting up the environment
- How to start / stop Reporting Server
- How to run Report Server Web Service URL
What’s SSDT 2016?
SQL Server Data Tool is a modern development tool. It's an available package such as Relational databases, Azure SQL databases, Integration Services packages, Analysis Services data models, and Reporting Services report. As you all know, with SSDT, you can easily design the report and deploy that in SQL Server. Similarly, you can develop an application and deploy that, using Visual Studio.
Prerequisite
We will see 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 - 2016Azure 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
Let's discuss the SQL Server Data Tools 2016 installation procedure with step by step guide.
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. Please verify that all the features are checked. Then, click the "Next" button.
![]()
The "License Terms" window will open. Check the license terms checkbox and click the "Install" button.
![]()
The "Setup Progress" window will open.
![]()
On "Setup Successful" window, click the "Restart" button.
![]()
How to Start / Stop Reporting Server using Reporting Services Configuration Manager
Go to All Programs >> Microsoft SQL Server 2016 >> Configuration Tools. Now, click the "Reporting Services Configuration Manager".
![]()
In the next window, open and verify the "Server Name" and "Report Server Instance". Then, click the "Connect" button.
![]()
The "Report Server Status" window will open. There, click the "Start" button.
![]()
After this, you can see the successfully started Report Server information. Now, verify the Report Service Status as started.
![]()
The Report Server status window will open. Click the "Stop" button.
![]()
How to run Report Server Web Service URL on the browsers
First of all, you have to open the Reporting Services Configuration Manager and connect the Report Server option. After this, click the "Start" button and once the Report Server is started, click the Web Service URL navigation to verify the Virtual Directory, IP Address, Port, URLs.
As of now, you can copy the URL and the paste on the browser.
![]()
Note
You can also read this article at my blog
here
Reference
Conclusion
I hope, you understood SSDT 2016 installation guidelines and how to start working with SSDT 2016. If you find anything that I missed in this article, please let me know. Please share your valuable feedback / comments and suggestions to improve my future articles.