Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SSRS and SSIS not available in SSMS

Posted on 2014-12-24
3
Medium Priority
?
177 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 66

Accepted Solution

by:
Jim Horn earned 2000 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

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
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…
Via a live example, show how to shrink a transaction log file down to a reasonable size.

886 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