Windows

Quick Steps to install SQL 2008 R2 Client Tools in Windows 7

Quick Steps to install SQL 2008 R2 Client Tools in Windows 7

Highlights

  • Most SQL admins or users who need to be able to see DBs on a SQL box or need to run SQL queries from their desktop, will most likely want to have the SQL management tools installed on their workstations.
  •  This is a very straightforward install and can usually be installed in just a few minutes.
  • Mount the SQL 2008 R2 media in your optical drive or use an ISO mounting utility such as is found in our post here.

Most SQL admins or users who need to be able to see DBs on a SQL box or need to run SQL queries from their desktop, will most likely want to have the SQL management tools installed on their workstations.  This is a very straightforward install and can usually be installed in just a few minutes.

Installation

Mount the SQL 2008 R2 media in your optical drive or use an ISO mounting utility such as is found in our post here.  Once the media spins up, you will see the following options.

  • The installer will automatically run environment checks on your system before proceeding


clitools1

  • Product Key is verified

clitools3

 

 

  • Licence Agreement

clitools4

  • Support files are copied over


clitools5JPG

clitools6

clitools7

  • Below is where we can customize our installation and select to only install the Management Tools which is what we want

clitools8

  • After customizing the installation selection, we can now begin the install process.  Usually installation of the management tools doesn’t take that long and should complete without error.

clitools9

 

Final Thoughts

The management studio is a handy piece to have installed if you work with SQL DBs or queries very often.  In most environments it is way easier to use the Management studio to connect instead of RDP sessions as these can become limited.

Subscribe to VirtualizationHowto via Email 🔔

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Brandon Lee

Brandon Lee is the Senior Writer, Engineer and owner at Virtualizationhowto.com and has over two decades of experience in Information Technology. Having worked for numerous Fortune 500 companies as well as in various industries, Brandon has extensive experience in various IT segments and is a strong advocate for open source technologies. Brandon holds many industry certifications, loves the outdoors and spending time with family.

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.