Friday, March 23, 2012

Integration Services and Analysis Services missing in Management Studio

If you don’t see Integration Services and Analysis Services  in SQL Server Management Studio in “connecting to server” dialog box, there could be one of the two reasons listed below: 

1. You are using SLQ Server  Management Studio Express(SSMSE). If so, please note that you can’t use SSMSE to manage SQL Server Analysis Services, Integration Services, Notification Services, Reporting Services, SQL Server Agent, or SQL Server 2005 Mobile Edition.
2. You only have “Management Tools - Basic” installed. To be able to connect to other services(Integration Services, Analysis Services  etc), you’ll need to have “Management Tools - Complete”. Just run the installation file again and select the option shown in the screen shot below to resolve this.

No comments:

Post a Comment