Mar 18, 2011 - SSMS Silent Install instructions 1) Download the SQL Server 2008 R2 from the image library. This may take awhile as it's a 5.5 GB.I prefer to do. With Toad® for SQL Server, you get extensive automation, intuitive workflows and built-in expertise to maximize productivity and reduce risk. This comprehensive toolset complements Microsoft tools by solving key SQL Server challenges, so you can proactively manage many databases.

• Sql Server 2012 Client Tools
• Ms Sql Server 2008 Express Client Tools Download

Microsoft SQL Server 2008 Express teaches you to build desktop and small server applications and redistribute by ISVs. Microsoft SQL Server 2008 Express (64-bit) is a powerful and reliable data. Jun 17, 2014 - Download SQL Server Management Studio 17.2 Upgrade Package (upgrades 17.x to 17.2). You likely just want SQL Server 2008 Express with Tools. Which downloads another installer, which actually installs SSMS.

Below is a list of the SQL components that I installed in the Visual Studio 2010 Professional setup. Sadly, while trying to work I could not find SQL Server Management Studio 2008.

Is there a way to download SQL Server Management Studio 2008 separately and install only that component?

Since in the past I installed SQL Server Management Studio 2005 with a whole new instance of SQL Server 2005 and had couple of instances, and it was a bit messy.

HaxedHaxed

Sql Server 2012 Client Tools

closed as off topic by WillMay 10 '13 at 15:55

Questions on Stack Overflow are expected to relate to programming within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here. If this question can be reworded to fit the rules in the help center, please edit the question.

6 Answers

If you have the SQL Server 2008 Installation media, you can install just the Client/Workstation Components. You don't have to install the database engine to install the workstation tools, but if you plan to do Integration Services development, you do need to install the Integration Services Engine on the workstation for BIDS to be able to be used for development. Keep in mind that Visual Studio 2010 does not have BI development support currently, so you have to install BIDS from the SQL Installation media and use the Visual Studio 2008 BI Development Studio that installs under the SQL Server 2008 folder in Program Files if you need to do any SSIS, SSRS, or SSAS development from the workstation.

As mentioned in the comments you can download Management Studio Express free from Microsoft, but if you already have the installation media for SQL Server Standard/Enterprise/Developer edition, you'd be better off using what you have.

Jonathan KehayiasJonathan Kehayias

I found some articles to be of major use:

This link is an experience someone else had:http://goneale.com/2009/05/24/cant-install-microsoft-sql-server-2008-management-studio-express/

This link has the exact steps involved to install everything properly:http://www.codefrenzy.net/2011/06/03/how-to-install-sql-server-2008-management-studio/

This link confirms the previous link:https://superuser.com/questions/88244/installing-sql-server-management-studio-when-vs2010-beta-2-is-already-installed

Any idea where I can download the Windows XP Home Edition Service Pack 2 ISO file? FWIW: Why would you want the SP2.when SP3 was the last SP for XP? This is because the OS on my old laptop is Windows XP Home Edition SP 2 and I need it to do the Recovery thing. Windows xp home iso download deutsch. No information is available for this page.Learn why. Windows XP Home Edition (Chinese - Hong Kong SAR) ISO CD Image, CDR. Windows XP Home Edition with Service Pack 2 (German), CDR, x86, German.

My Instructions

I am not sure if my instructions will be 100% accurate, but in my instance, because I installed VS2010 on a fresh copy of Windows 7, the VS2010 installer installs SQL Server 2008 Express for you, so from this point I just need the Management Studio.

What I gathered from these explanations is to do the following:

1. Download the SQL Server Management Studio install fromhttp://www.microsoft.com/download/en/details.aspx?id=22973
2. Run the setup, when you get to the point where it asks you to 'Perform a new installation of SQL Server 2008' or 'Add features to an existing instance of SQL Server 2008', this part is the CONFUSING PART (HEY MICROSOFT TAKE NOTES, DON'T DO THIS KIND OF STUFF).
   As much as you want to select 'Add features to an existing instance of SQL Server 2008' DON'T!!!!
   You need to select 'Perform a new installation of SQL Server 2008'. It doesn't sound right I know - it is very confusing and counter intuitive, but this seems to be the way to install management studio. :(
3. Press next until you see the features selection portion. Heeeeeyyyy look at that, it has a check box for Management Studio. It should be selected already, if not then select it of course and press next.
4. Press Next next next next next next.. basically just install it at this point.
5. Enjoy, it has installed.

Community♦

dyslexicanabokodyslexicanaboko

I am just updating this with Microsoft SQL Server Management Studio 2008 R2 version. if you run the installer normally, you can just add Management Tools – Basic, and by clicking Basic it should select Management Tools – Complete.

That is what worked for me.

zachzach

The accepted answer was correct up until July 2011. To get the latest version, including the Service Pack you should find the latest version as described here:

For example, if you check the SP2 CTP and SP1, you'll find the latest version of SQL Server Management Studio under SP1:

Download the 32-bit (x86) or 64-bit (x64) version of the SQLManagementStudio*.exe files as appropriate and install it. You can find out whether your system is 32-bit or 64-bit by right clicking Computer, selecting Properties and looking at the System Type.

Although you could apply the service pack to the base version that results from following the accepted answer, it's easier to just download the latest version of SQL Server Management Studio and simply install it in one step.

Rob at TVSeries.comRob at TVSeries.com

For any of you still having problems as of Sept. 2012, go here: http://support.microsoft.com/kb/2527041 ..and grab the SQLManagementStudio_x(32|64)_ENU.exe (if you've already installed SQL Server 2008 Express R2), or SQL Server 2008 Express R2 with Tools, i.e. SQLEXPRWT_x64_ENU.exe or SQLEXPRWT_x32_ENU.exe (if you haven't).

From there, follow similar instructions as above (i.e. use the 'Perform new installation and add shared features' selection, as 'Management Tools - Basic' is considered a 'shared feature'), if you've already installed SQL Server Express 2008 R2 (as I had). And if you haven't done that yet, then of course you're going to follow this way as you need to install the new instance anyway.

This solved things for me, and hopefully it will for you, too!

DuncanDuncan

SQL Server Management Studio 2008 R2 Express commandline:

The answer by dyslexicanaboko hits the crucial point, but this one is even simpler and suited for command line (unattended scenarios):

(tried out with SQL Server 2008 R2 Express, one instance installed and having downloaded SQLManagementStudio_x64_ENU.exe)

As pointed out in this thread often enough, it is better to use the original SQL server setup (e.g. SQL Express with Tools), if possible, but there are some scenarios, where you want to add SSMS at a SQL derivative without that tools, afterwards:

I´ve already put it in a batch syntax here:

Remarks:

1. For 2008 without R2 it should be enough to omit the /IACCEPTSQLSERVERLICENSETERMS flag, i guess.
2. The /INDICATEPROGRESS parameter is useless here, the whole command takes a number of minutes and is 100% silent without any acknowledgement. Just look at the start menu, if the command is ready, if it has succeeded.
3. This should work for the 'ADV_SSMS' Feature (instead of 'SSMS') too, which is the management studio extended variant (profiling, reporting, tuning, etc.)

PhilmPhilm

Not the answer you're looking for? Browse other questions tagged sql-server-2008visual-studio-2010 or ask your own question.

The Microsoft SQL Server Data Mining Add-ins for Microsoft Office 2007 and 2010 can help you derive patterns and trends that exist in complex data, visualize those patterns in charts and interactive viewers, and generate rich, colorful summaries for presentation and for business analytics. These add-ins utilize the predictive analytics of SQL Server in Microsoft Excel and Microsoft Office Visio.

Note: At this time, the add-ins are only available for the 32-bit version of Microsoft Office.

In this article

Download the SQL Server Data Mining Add-ins

To download the add-ins, see Microsoft SQL Server 2008 Data Mining Add-ins for Microsoft Office.

This package includes the following two add-ins for Office Excel 2007 and 2010 (Table Analysis Tools and Data Mining Client) and one add-in for Office Visio (Data Mining Templates):

• Table Analysis Tools for Excel This add-in provides easy-to-use tasks that leverage SQL Server Data Mining to perform powerful analytics on your worksheet data.
  The 2008 version of the Data Mining Add-in adds two additional analysis features:
  • Prediction Calculator This tool generates both interactive and printable calculators for scoring new data against a desired outcome. You can use it, for example, to determine if a loan application should be approved or not based on the scores it computes for customer attributes like occupation and income.
  • Shopping Basket Analysis This tool helps you quickly analyze purchase transactions and identify sales opportunities.

How-to-videos are available for each tool; the first in the series is Getting started with the Table Analysis Tools (SQL Server Video).

For more information, see Data Mining Add-Ins for Microsoft Office on the Microsoft SQL Server 2008 web site.

Ms Sql Server 2008 Express Client Tools Download

• Data Mining Client for Excel This add-in enables advanced users to go through the full development life cycle for the data mining model within Excel by using either worksheet data or external data from SQL Server Analysis Services.
  For more information, see Basic Data Mining Tutorial.
• Data Mining Templates for Visio This add-in enables you to render and share your data mining models as the following annotatable Office Visio 2007 drawings:
  • Decision Tree diagrams based on Microsoft Decision Trees, Microsoft Linear Regression, and Microsoft Logistical Regression algorithms
    
  • Dependency Network diagrams based on the Microsoft Naive Bayes, Microsoft Decision Trees, and Microsoft Association Rules algorithms
  • Cluster diagrams based on the Microsoft Clustering algorithm
    The templates interact with data mining models stored on an instance of SQL Server Analysis Services and provide access to the underlying data in the mining model. You can manipulate the elements included in the diagrams, add or remove nodes, and filter on the data by using probabilities. You can also work with the full range of features for enhancing the diagram that are provided by Microsoft Office Visio.

Compatibility with the Power Pivot Add-in for Excel

The current release of Power Pivot does not support integration between the two add-ins.

However, the Data Mining Add-Ins can be used in the same workbook as the Power Pivot for Excel Add-in, if you have installed the 32-bit version of Office and the 32-bit version of Power Pivot.

You can use data stored in SQL Server 2008 and SQL Server 2008 R2 sources, including Analysis Services cubes. However, you cannot connect directly to the IMBI database used in a Power Pivot workbook. To use data in a Power Pivot workbook for building data models, the data must be accessible as an Excel table.