Solved

SSRS and SSIS not available in SSMS

Posted on 2014-12-24
3
163 Views
Last Modified: 2016-02-15
I am logged onto the server as the domain administrator and the domain administrator is a SQL sysadmin, however when I go to log into SSMS the only option available is the Database Engine. The reporting and integration engines are dim. I can see the reporting and integration services running. What could be causing this? This is SQL Server 2014.
0
Comment
Question by:rwheeler23
  • 2
3 Comments
 
LVL 65

Accepted Solution

by:
Jim Horn earned 500 total points
ID: 40517576
SSIS and SSRS are not part of the SQL Server / SSMS install, they are a separate install after SQL called SQL Server Data Tools (SSDT).
0
 

Author Comment

by:rwheeler23
ID: 40517837
Jim, thank you for pointing me to the new SQL Data Tools for SQL 2014. However, in this case, I discovered that the original answer to this was going to Programs and Features and then adding to SQL Server 2014 Management Tool - Complete.

Now a dumb question I have is why did Microsoft remove the SSDT-BI from the SQL installation? It was bad enough they changed the name from Business Intelligence Design Studio to SQL Server Data Tools but why remove it from the installation?
0
 

Author Closing Comment

by:rwheeler23
ID: 40517840
You got me to another useful download plus the issue was resolved. Thanks.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My client has a dictionary table. They're defining a list of standard naming convention. Now, they are requiring my team to provide us a mechanism how to match new incoming data with existing data in their system.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now