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

Answer 1

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

Answer 2

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

Answer 3

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

Answer 4

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

Answer 5

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

Answer 6

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.