Getting Started With SSDT 2016 Using Visual Studio 2015

In this article, we will discuss in detail about how to get started with SSDT 2016.

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. NoPackagesSQL Server supported version
1.Relational databasesSQL Server 2005 - 2016Azure SQL database and Data Warehouse (supports only SQL queries)
2.Analysis Services modelsSQL Server 2008 - 2016
3.Reporting Services reportsSQL Server 2008 - 2016
4.Integration Services packagesSQL 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.