Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Trying to install SQL Server 2008 Standard R2 on Windows Server 2008 Standard R2

Answered Trying to install SQL Server 2008 Standard R2 on Windows Server 2008 Standard R2

  • Saturday, January 05, 2013 10:17 AM
     
     
    Sign In to Vote
    0

    I have a PC that I installed Windows Server on, did all the maintenance.

    We needed to install SQL Server so that we could run the accounting system we purchased.

    The configuration was supposed be the server, a local client running Windows 7 and a remote client using VPN.

    When we (the accounting software technical guy, since I am a novice with Server) attempted to install SQL Server we ran into the invalid edition issue.

    In order to complete the accounting software install, we opted to install Express Advanced which seemed to install fine and completed the accounting installation. The local client is not having any issues in using the accounting package. BUT we are using the free SQL Server instead of the $800 Standard version.

    I have several questions (and I am sure that I will think of others as I get educated):

    1- What am I losing with Express Advanced compared to Standard?

    2- Should we have ordered a different set of software?

    3- How does one go about setting up a Domain Controller?

    I would appreciate any and all help.

    Thanks.

     

All Replies

  • Saturday, January 05, 2013 4:26 PM
     
     Answered
    Sign In to Vote
    0

    Hi Richard,

    You have a lot of questions. Let me start with the basics,

    1. SQL Server Express should do if this is a basic setup.
    Main points: Express databases can have a max size of 10 GB (per database). You can have multiple databases in a single SQL instance though.
    For DB-Administration, assuming you are using SQL 2012, you get the full blown Management Studio for free, if you install SP1.
    You don't get high availability features like clustering, mirroring etc with Express.

    You can find more details in this comparison chart
    http://msdn.microsoft.com/en-us/library/cc645993.aspx

    2. Can you be a little more specific?

    3. You need a windows server license to begin with, looks like you have this already. Here are some article that provide step-by-step instructions with screenshot showing how to setup a domain controller (applies to Windows 2008/2008 R2)

    http://www.elmajdal.net/win2k8/setting_up_your_first_domain_controller_with_windows_server_2008.aspx
    http://www.windowsnetworking.com/articles-tutorials/windows-server-2008/Running-Windows-Server-2008-R2-Installing-Creating-Lab-Domain-Controller-Part1.html

    HTH.

    Patience is a Virtue... So is "Delayed IO" :) Need SQL Server help? Visit my website: http://www.theSQLDude.com