Wednesday, September 02, 2009 1:01 AM
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 6:41 AMModeratorThe 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
Thursday, September 03, 2009 6:56 PMHi 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.
Let me knpow if you have any further questions.
Please Vote & "Mark As Answer" if this post is helpful to you.
Thursday, October 15, 2009 2:40 PMHi,
On this site (unfotunately in German):
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
Sunday, October 18, 2009 6:33 PMNo. 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
Tuesday, October 20, 2009 12:39 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?
Thursday, March 15, 2012 1:20 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.