none
MS SQL Server 2008 Client tools

    Question

  • Can i anyone tell me if the MS SQL Client tools are available for free standalone downloads without installation of complete version. Please provide the Download path

    Wednesday, September 02, 2009 1:01 AM

Answers

All replies

  • The Excel 2007 data mining tools for SQL Server 2008 Analysis Services are available here: http://www.microsoft.com/downloads/details.aspx?familyid=AF070F2C-46F4-47B6-B7BF-48979B999AEB&displaylang=en

    HTH
    Thomas Ivarsson
    Wednesday, September 02, 2009 6:41 AM
  • Hi Ankit,
    If you want to download Data Mining Add In tools the path is given by Thomas.

    However if you want to download only SQL Server Client tools below is the link.

    http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en

    Let me knpow if you have any further questions.

    Please Vote & "Mark As Answer" if this post is helpful to you.

    Cheers
    Bikash Dash
    MCDBA/MCITP
    • Proposed as answer by Bikash Dash Wednesday, September 09, 2009 5:23 AM
    • Marked as answer by Jamie MacLennan Thursday, September 10, 2009 5:06 PM
    Thursday, September 03, 2009 6:56 PM
  • Hi,

    On this site (unfotunately in German):

    http://technet.microsoft.com/de-de/library/ms345299.aspx

    it says in order to connect to a database of MS SQL Server from a different computer (than the MS Server is installed), you're supposed to open a computer that has the Client tools installed and to open Management Studio.

    Which Tools of those mentioned in the link above (http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en)
    do they actually mean ? + is it neccessary to have Management Studio installed on every client computer that wants to access the MS SQL Server database ?

    Thanks a lot for your support in advance

    Cheers

    Thursday, October 15, 2009 2:40 PM
  • No.  You only install the SQL Server tools to machines that you want admin or development access to a SQL Server.  Everyone else who is just using an application to connect to SQL Server just needs the SQL Native client.

    Moderators: Please move thread to the SQL Server Tools General forum.

    Mike Hotek BlowFrog Software, Inc. http://www.BlowFrogSoftware.com Affordable database tools for SQL Server professionals
    Sunday, October 18, 2009 6:33 PM

  • Yes, but which of the 20 installs listed on the SQL Server Client tools website would I install to get SQL Server Management Studio onto a client machine? It's not clear from the descriptions. 

    Can other tools, such as the Performance Management Tools also be installed on a client machine away from the server where SQL is installed?

    Thanks,
    Dave
    Tuesday, October 20, 2009 12:39 PM
  • I have been working with SQL Server 2005 since 2 years and have always used SQL Server Management Studio to access it. I am in a new project and here they use SQL Teradata Assistant to access SQL Server 2005.
    Though I have been able work my ways around I have noticed some t -sql commands like "print" and "go" do not work.

    I want to know and convince my new team to get sql server management studio to work with SQL Server.

    Hence I need to know the cons of using other tools instead of SQL Server Management studio.

    Thursday, March 15, 2012 1:20 PM