SQL Server 2008 R1 Client Tools

Hi SQL Server Folks,

I got a requiremet from one of my customer to install client tools but for SQL Server 2008 R1. It was very simple in SQL Server 2005 i.e. in the binaries for SQL Server 2005 you have two folders name as “Server” & “Tool” so if you want to install only client tools then simply open the folder name as “Tool” and run the setup.exe and your task is done. But in the binaries of SQL Server 2008 there is nothing like that i.e. all servers and client related components are mixed. Below is the script that I wrote to make SQL Server 2008 R1 client tool.

Open the command prompt and go in to the path where your SQL Server binaries are there for ex. C:\Gaurav\SQL Server 2008 R2 

 set source=C:\Gaurav\SQL Server 2008 R2

set dest=C:\SQLFULL_ENU_ToolsOnly

 REM Copy Root ONLY

robocopy %source% %dest%

REM Copy Root ONLY

robocopy %source%\x86 %dest%\x86 /XF fixsqlregistrykey_ia64.exe

robocopy %source%\x64 %dest%\x64 /XF fixsqlregistrykey_ia64.exe

 robocopy %source%\x86\1033 %dest%\x86\1033

robocopy %source%\x64\1033 %dest%\x64\1033

 robocopy %source%\x86\help %dest%\x86\help /S

robocopy %source%\x64\help %dest%\x64\help /S

 REM Copy redists

 robocopy %source%\x86\redist\DotNetFrameworks %dest%\x86\redist\DotNetFrameworks /S /XF *ia64*

robocopy %source%\x64\redist\DotNetFrameworks %dest%\x64\redist\DotNetFrameworks /S /XF *ia64*

 robocopy %source%\x86\redist\Powershell %dest%\x86\redist\Powershell /S /XD ia64

robocopy %source%\x64\redist\Powershell %dest%\x64\redist\Powershell /S /XD ia64

 robocopy %source%\x86\redist\Watson %dest%\x86\redist\Watson /S

robocopy %source%\x64\redist\Watson %dest%\x64\redist\Watson /S

 robocopy “%source%\x86\redist\Windows Installer” “%dest%\x86\redist\Windows Installer” /S /XD ia64

robocopy “%source%\x64\redist\Windows Installer” “%dest%\x64\redist\Windows Installer” /S /XD ia64

 REM Setup Folder and exclude folders and files that aren’t needed

robocopy %source%\x86\Setup %dest%\x86\Setup /S /XD sql_engine_core_inst_loc_msi sql_engine_core_inst_msi sql_engine_core_shared_loc_msi sql_engine_core_shared_msi /XF rsfx.msi rsSharePoint.msi sql_as.msi sql_fulltext.msi sql_is.msi sql_rs.msi sqlbrowser.msi Synchronization.msi SyncServicesADO.msi sql_as_loc.msi sql_is_loc.msi sql_rs_loc.msi sqlserver2005_bc.msi sqlwriter.msi

 robocopy %source%\x64\Setup %dest%\x64\Setup /S /XD sql_engine_core_inst_loc_msi sql_engine_core_inst_msi sql_engine_core_shared_loc_msi sql_engine_core_shared_msi /XF rsfx.msi rsSharePoint.msi sql_as.msi sql_fulltext.msi sql_is.msi sql_rs.msi sqlbrowser.msi Synchronization.msi SyncServicesADO.msi sql_as_loc.msi sql_is_loc.msi sql_rs_loc.msi sqlserver2005_bc.msi sqlwriter.msi

After running this above script your SQL Server 2008 R1 client tools are reday and it will be save in your destination location that you defined above in script, in our case this location is C:\SQLFULL_ENU_ToolsOnly .

Instructions to use SQL 2008 R1 Client Tools

  1. Copy the whole folder “SQL 2008 Client Tools”  on machine where you want to install it.
  2. For 32-bit machine open “SQL 2008 Client Tools”  folder  and open the file name as “MyConfigurationFile.ini” in Notepad. After opening it search the text as “MEDIASOURCE” and in that field specify the location where you copied “SQL 2008 Client Tools” folder and save the changes in this “MyConfigurationFile.ini” . Now search the text name as “INSTALLSHAREDWOWDIR=”C:\Program Files (x86)\Microsoft SQL Server” and delete this text from this file and save the changes in this “MyConfigurationFile.ini” .
  3.  For 64-bit machine open “SQL 2008 Client Tools”  folder  and open the file name as “MyConfigurationFile.ini” in Notepad. After opening it search the text as “MEDIASOURCE” and in that field specify the location where you copied “SQL 2008 Client Tools” folder.
  4.  Now Open the command prompt and go in to “SQL 2008 Client Tools”  folder  location and type the parameter as “Setup.exe /q /ACTION=Install /FEATURES=Tools /ConfigurationFile=MyConfigurationFile.INI” and wait to install SQL 2008 client tools.
  5.  After finishing this task go in to Start à Programs and check for “Microsoft SQL Server 2008”.

Hope it will help someone. Stay tune for more interesting SQL Server stuff’s.

Thanks.

Advertisements

2 Responses

  1. Gaurav,

    This approach might have some unforeseen drawbacks if not tested with all machine types. This approach cannot be advocated as recommended practice. Although, this is good to know what files are really useful for Client tools.

    Good job!!!

    • Som,

      I have tested this Client tools on Windows Server 2003 32 & 64-bit machines and also on Windows Server 2008 R1 and it’s installing and running fine. So if you want to deploy in your company then you have to test this first in your company environment on Lab servers. If the installation of these tools are failing then it’s very easy to troubleshoot them like any other SQL Server installation. But these tools are not suported by Microsoft.

      Anyways thanks for your concern on this and I want you to stay tune on this blog.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: