Saturday, February 25, 2012

Management Stusio install via SMS

s there a way to only install sql management studio via SMS?

I found the article on the unattend install, but I do not want the connectivity tools, etc.

I only need the management studio portion installed, nothing elsre. Has anyone accomplished this?

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=478384&SiteID=1|||

I replied to that post, but it did not really help me out.

I do not know the msi

|||

IS SSMSE (SQL Server Management Studio Express) any help here?

http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796

|||

The full Management Studio application is able to manage all our SQL Server products - including SQL Server, Analysis Services, Integration Services, and SQL Server Agent. Because of its scope, SSMS has a lot of dependencies under the covers that end needing most of the components you aren't interested in running in order to start.

We tailored Management Studio Express to not have all those dependencies, so the install is fairly small and doesn't bring in anything other than what's needed to work with the SQL Server relational engine. Management Studio Express is missing functionality from the full SSMS that some users use frequently, like the ability to work with SQL Server Agent and SSIS, which prevents it from working with maintenance plans, importing and exporting data using a wizard, and using a wizard to copy databases. If you don't use that functionality, SSMSE might work well for you.

You can download SSMS Express here: http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&DisplayLang=en

Hope this helps,
Steve

No comments:

Post a Comment