How To Install SQL 2008 R2 on Windows Server 2008 R2 SP1 For Use With SCVMM 2008 R2 SP1



Before I get deep into SQL Installation let me tell you where we are starting…

I am walking through the installation of SCVMM 2008 R2 SP1 on a new server that I just setup in my demo environment.  I want to use SQL Server 2008 R2 for my deployment so I need to set that up as a prerequisite.  I figured this is a good opportunity to document the process.

I am starting with a sysprep’d Windows Server 2008 R2 Server.  I have allocated 2 processors and 512mb memory to the guest using dynamic memory.  Once I get the system up and running, I will bump up the memory to be close to what I actually need but I will leave it dynamic. 


Great… Now Let’s Get Started!!!

  • I put the DVD into a drive (actually, I am using an ISO that I attached to the virtual machine) and right-clicked on the drive in My Computer and clicked “Install or run program from your media” SQL Server Setup installs the following software components required by the product:
    • .NET Framework 3.5 SP1
    • SQL Server Native Client
    • SQL Server Setup support files
  • The first thing that happens when you launch the installation of SQL Server 2008 R2 is it checks for the proper framework.  if it is not installed, it will install it for you.  In my case, it adds .NET Framework 3.5 SP1


  • On the next screen, click Installation on the left to display the installation options.  We are then going to select New Installation or Add Features to an existing installation. 


  • On the Setup Support Rules you should be able to just click OK.  If you click Show Details it will look something like this…


  • Enter your product key then click Next
  • Accept the license agreement click Next
  • On the Setup Support Files click Install
  • On the Setup Support Rules screen, you can see that I have a couple warnings


  • The .NET warning is that I do not have Internet access on this computer.  Not a problem so I am just moving on.
  • The Firewall warning will be ignored as well.  I will go back and modify the firewall later.
  • I will just click Next and move on
  • On the Setup Role – I will keep the default SQL server Feature installation and click Next
  • On the feature selection, I am going to make many changes…


  • To use SQL Server 2008 or SQL Server 2008 R2 for the VMM database, SQL Server Management Tools must be installed on the VMM server. I also want to change the default installation location.  I am moving it to the E-Drive.  I am running in a virtual machine on Hyper-V and the SCSI bus drives are faster than the IDE Bus drives.  I also do not like putting a bunch of stuff on the OS drive.
    • Turn On Database engine Services
    • Turn on Reporting Services  (If you use reporting services, you will need to setup IIS)
    • Turn on Client Tools Connectivity
    • Turn on Client Tools SDK  (I do not think this is needed but I am adding it anyway)
    • Turn on Management Tools – Basic
      • Turn on Management Tools – Complete
    • I am also changing the location to my “E” Drive
  • On the Installation Rules you can click "Show Details" if you like then just click Neximage
  • Next is the Instance configuration…
  • for this section, I am going to tell the installer to put my instance on my E Drive.   If you do not yet have an E drive defined you can add it on the fly.  For instructions on how to do this see How To Hot Add Storage To A Hyper-V Guest–Super Simple And No Service Interruption 


  • I am not using the default instance for my deployment.  You can just leave the defaults if you like to keep things simple.  I want to create an instance called SCVMM because this will be dedicated for my SCVMM database. If you do pick your own name make sure SQL Server name does not contain more than 15 characters
  • Notice I also changed the Instance root folder to my E drive
  • Once making any changes you like, just click Next


  • On the Disk Space Requirements Screen just click Next
  • image
  • The next screen is the Server Configuration. We need to do a few things here
  • If remote SQL Server is running under the Network Service account or a domain account, you must create a Service Principal Name (SPN) for the SQL service as described in article 811889 in the Microsoft Knowledge Base at
  • On the Service Accounts Tab change the SQL Server Agent to Automatic startup.  The agent is used for backup.  Perhaps later I will do a blog post on how to setup the agent to perform backups of the databases. 
  • We are are going to use the same account for all of our services.  just click on the Use the same account for all SQL server Services button to bring up a small dialog box.  In the Account Name field select NT Authority\SYSTEM then click OK
  • We will keep the defaults for Collation so just click Next



  • On the Database engine configuration Page we have much to do…
  • On the Account Provisioning tab I am changing to Mixed Mode.  This gives me the capability to manage users from inside of SQL.  Without it users have to use Windows authentication.  Once you change to mixed mode you will need to put in a password for the “SA” account which is the internal SQL Administrator account.  You will need to use a complex password for this.  If you do not need mixed mode, you can just leave Windows authentication mode turned on.
  • You have to specify SQL Server administrators.  In my case, I clicked “Add Current User” which added ATLANTA\Administrator.  I also clicked Add to add Woodgrovebank\Domain admins and Woodgrovebank\SQL2008R2Service which is a user account I created for SQL Server.  I am not initially using this account but I want to go ahead and make it an administrator.
  • In my case I want to change the location that SQL stores my data so I am going to move to the data Directories tab


  • On the data Directories tab I am going to change the location of my data root directory.  If you have not created this drive see How To Hot Add Storage To A Hyper-V Guest–Super Simple And No Service Interruption.  Once you create the drive, you should add the folder.  In my case I like to create a folder called SQLData so I just toggled out to create the folder on my data disk.  I strongly recommend you do not put SQL Data on the C drive.  Even if you have plenty of space available.  You have been warned!!!!
  • I also changed the User database directory to be E:\SQLdata\Data
  • I changed the backup directory to be E:\SQLData\Backup
  • when I changed the Data Root directory, the Temp DB directory changed so I just kept it as is.
  • We do not need to make any changes on FILESTREAM tab so we can just click Next 


  • In the Reporting Services configuration, I will leave Install the native mode default configuration and then click Next


  • No Error reporting for me so just click Next


  • Almost done.  You can show the details on the Installation Configuration Rules if you like
  • All applicable tests should be passed so just click Next


  • On the Ready To install screen you can review your configuration and then just click Install
  • Then just let it chug for about 20 mins or so (depending on performance of your machine it could be longer)


  • We are done with the installation of SQL.  You may want to take a few minutes to read the supplemental information.  Also notice that a log file was left on the system in case you want to refer to it. When finished, you can just click Close. You probably still have the SQL Server Installation center open.  You can close that by clicking the X in the upper right corner.
  • We still have a few configuration changes we need to make.  Remember those warning messages we had in the beginning?  We need to open up a firewall port to allow SQL Traffic to pass to this computer.  There is a TechNet Article on how to do that. Configuring the Windows Firewall to Allow SQL Server Access.  More specifically, I need to open the firewall for Database Engine and Reporting Services
How to: Configure a Windows Firewall for Database Engine Access
To open a port in the Windows firewall for TCP access
  1. On the Start menu, click Run, type WF.msc, and then click OK.
  2. In the Windows Firewall with Advanced Security, in the left pane, right-click Inbound Rules, and then click New Rule in the action pane (upper right corner).
  3. In the Rule Type dialog box, select Port, and then click Next.
  4. In the Protocol and Ports dialog box, select TCP. Select Specific local ports, and then type the port number of the instance of the Database Engine, In my case we are using the default which is 1433. Click Next.
  5. In the Action dialog box, select Allow the connection, and then click Next.
  6. In the Profile dialog box, I am going to Leave Domain turned on and turn private and public off. Then click Next
  7. In the Name dialog box, type "Allow SQL 1433 Inbound” and for a description I am putting in the same.  Then click Finish.
How to: Configure a Firewall for Report Server Access
To open port 80 on Windows 7 or Windows Server 2008 R2
  1. From the Start menu, click Control Panel, click System and Security, and then click Windows Firewall. Control Panel is not configured for 'Category' view, you only need to select Windows Firewall.
  2. Click Advanced Settings.
  3. Click Inbound Rules.
  4. Click New Rule in the Actions window (upper right corner).
  5. Click Rule Type of Port.
  6. Click Next.
  7. On the Protocol and Ports page click TCP.
  8. Select Specific Local Ports and type a value of 80.
  9. Click Next.
  10. On the Action page click Allow the connection.
  11. Click Next.
  12. On the Profile page I am leaving Domain turned on and turning off private and public.  You should check the appropriate options for your environment.
  13. Click Next.
  14. On the Name page enter a name of Allow SQL ReportServer (TCP on port 80)
  15. Click Finish.
  • If you would also like to open other ports like ICMP (Ping) and remote management you can find step by step instructions at Allow Remote Desktop Services and Ping Through Firewall on Windows Server 2008 R2 or Windows 7
  • Also if you are using this SQL Server for VMM ensure that TCP port 445 is not blocked. VMM uses port 445 to populate the database instances from the remote server. If port 445 is blocked, you can enter the name of the SQL instance manually so it is not a big show stopper.

After you open the port and before you confirm whether remote users can access the report server on the port that you open, you must grant user access to the report server through role assignments on Home and at the site level. You can open a port correctly and still have report server connections fail if users do not have sufficient permissions. For more information, see How to: Grant User Access to a Report Server (Report Manager) in SQL Server Books Online.

You can also verify that the port is opened correctly by starting Report Manager on a different computer. For more information, see Report Manager in SQL Server Books Online.

To enhance the security of your SQL Server connection, it is recommended that you enable SSL encryption by modifying the connection string as described in article 316898 in the Microsoft Knowledge Base at

When connecting remotely to SQL Server using a port other than the default port (1433), you must append the port number after the instance name using the following syntax: instance name, port.

Long post… I hope you find it useful!  Please feel free to comment!

Comments (29)
  1. Mike Hunt says:

    This was a very in depth and simple and complicatedly easy guide I highly reccomend it!!!!

  2. Michael B. says:

    I was wondering if you could. I installed, uninstalled and re-installed Microsoft SQL2008 R2. I always getting an error 26 notice when I try to connect the server. I did just about everything which was recommended on several forums.

    Do you have any advice. I am using Win7.

    my email:

  3. Praveen says:

    hi i got an error saying that you sql server 2008 r2 instalation not succesful at end of completion

  4. Jana says:

    could u help me i'm confused about using the accounts

    i'm installing sql and tfs on the same server

    i must use "install the native mode , right ?

    i have account "domain/user" could i use it as the same account for all services and for the reporting service and tfs ??

    appreciated ,,

  5. Alexandre de Santa Roza says:

    Just passed through overlooking it…and no doubt it’s easy to see how great is this material!! Thank you Very much!!!

  6. mashhud says:

    Thanxs for heip by step by step

  7. Mani says:

    Thanxs for heip by step by step, plz flow it……………..

  8. Aufi Faqih says:

    thankyou…. very helpful

  9. Mahmoud Anter says:

    i did all thing in the above but still the same problem in my Computer (Can’t install the SQL server 2008 Ex)
    PLZ how can i install it ???

  10. vidya says:

    Thankz its the most usefull infromation.Thankz a lot

  11. Erik Dwelly says:

    Thanks so much for taking this time to put this together. I really helped me out a LOT today!

  12. Vietnam - Ai Van Nguyen says:

    thank you…. very helpful

  13. sgar baba says:

    This was a very in depth and simple and complicatedly easy guide I highly reccomend it..THNAKS

  14. wf.msc is not working on windows xp says:

    Hi. In windows xp there is no such run command wf.msc. Please tell me that how do i fix it now. I searched very much but could not get the answer. wf.msc is running windows vista and on windows 7 probably. Please guide me for it.

  15. chaitanya says:

    Thanks u so much for being descriptive.

  16. sunny says:

    thanks sir

  17. Ankita says:


  18. maddy says:

    Really good explanation.

  19. Pratik1 says:

    its vry helpful

  20. baba says:

    Thanks —- very helpfull

  21. bala says:

    Its Very Usefull.. Thanks a lot.

  22. sunny says:

    I always getting an error 26 notice when I try to connect the server. Plz help me my email is

  23. Sarab Alani says:

    I found it useful batter than long book, it is easy and direct . Thank you so much

  24. Sarab Alani says:

    I found it useful batter than long book, it is easy and direct . Thank you so much

  25. show box says:

    Thanks for the great info. I really loved this. I would like to apprentice at the same time as you amend your web site, how could i subscribe for a blog site?
    For more info on showbox please refer below sites:
    Latest version of Showbox App download for all android smart phones and tablets. – It’s just 2 MB file you can easily get it on your android device without much trouble. Showbox app was well designed application for android to watch movies and TV shows, Cartoons and many more such things on your smartphone.
    For showbox on iOS (iPhone/iPad), please read below articles:
    Showbox for PC articles:
    There are countless for PC clients as it is essentially easy to understand, simple to introduce, gives continuous administration, effectively reasonable. it is accessible at completely free of expense i.e., there will be no establishment charges and after establishment
    it doesn’t charge cash for watching films and recordings. Not simply watching, it likewise offers alternative to download recordings and motion pictures. The accompanying are the strides that are to be taken after to introduce Showbox application on Android. The above
    all else thing to be done is, go to the Security Settings on your Android telephone, Scroll down and tap on ‘Obscure sources’.
    Movie Box, an esteemed movies application in which you can find stacks of programs and films. The guide is given here to download Movie Box app to Android and to Apple iOS 9.0.2, iOS 8.4/8.3 and also for the lower versions without Jailbreak.
    Please do login to Showbox application with the help of Ymail. You can login in Ymail from here –
    Sign Up & Do registration for latest movies on Showbox application

  26. Razeen says:

    Great step by step guide.. very helpful. Thanks

  27. JC says:

    Very nice demo, Very good one for the beginners. Thanks for sharing useful presentation.

Comments are closed.

Skip to main content
Real Time Web Analytics