Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 178
  • Last Modified:

SSRS and SSIS not available in SSMS

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
rwheeler23
Asked:
rwheeler23
  • 2
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
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
 
rwheeler23Author Commented:
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
 
rwheeler23Author Commented:
You got me to another useful download plus the issue was resolved. Thanks.
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now