Getting Started with SSDT 2016 using Visual Studio 2015

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.

 


About the Author
Santhakumar Munuswamy is a seasoned Solution Architect and Most Valuable Professional in Cloud /AI solutions. He has been experienced around 14 years in Solution designing, Software Product Development, Technical Documentation, Project Management for Web and Cloud Applications. He has experience in the IT industry across different domains (Automotive, Telecommunications, Healthcare, Logistics & Warehouse Automation, etc.) with roles in Technical Architect, Genesys Consultant, Technical Lead, Team Lead, and Developer. He has experienced in mentorship and coaching high potential developers.

Follow Me: Facebook, Twitter, Google Plus, LinkedIn
blog comments powered by Disqus


Month List

Community Badges