+ Reply to Thread
Results 1 to 8 of 8
  1. Senior Member
    Join Date
    Jul 2016
    Location
    USA
    Posts
    173

    Certifications
    A+, MCP (70-410, 70-411)
    #1

    Default Installing SQL Server 2012 on Server 2012 R2 Info

    As you all should know, .NET Framework 3.5.1 is required for SQL Server 2012. In Server 2012 R2 (I don't know about 2012) SQL Server will pass all of the requirement checks for .NET 3.5.1 because version 4 or 4.5 is installed by default on Server 2012 R2. Even though you get all green check marks, the SQL Server installation will crap out complaining that 3.5.1 can't be enabled.

    To install 3.5.1 on Server 2012 R2 (This assumes you have your Server 2012 R2 installation media mounted as d)
    The easiest way: open PowerShell as admin and type the following - dism /online /enable-feature /featurename:netfx3 /all /source:d:\sources\sxs

    Or you could go through Add Roles and Features wizard, select the .NET 3.5 feature and then supply d:\sources\sxs as the source if it complains.

    Just a heads up. Being that MS revised this exam to include SQL Server 2014 material, they may ask about installing SQL 2012 on Server 2012 and 2012 R2. I wouldn't put it past them.
    Last edited by AvgITGeek; 03-29-2017 at 04:48 AM.
    Reply With Quote Quote  

  2. SS -->
  3. Senior Member greg9891's Avatar
    Join Date
    Mar 2014
    Posts
    1,033

    Certifications
    Network +, MTA: 98-366, 367,MCP, MCTS Win 7, VCP-DCV, MCSA SERVER 2012, MCTS Hyper-V
    #2
    Thanks for the update! might come in handy.
    Certs Gained 2017: 70-410, 70-411,74-409, MCSA Server 2012r2
    Upcoming: Security +, ITIL FOUNDATIONS, 70-345 Exchange Server 2016, Ccent

    “Therefore encourage one another and build each other up, just as in fact you are doing.” - 1 Thessalonians 5:11
    Reply With Quote Quote  

  4. Member
    Join Date
    Dec 2016
    Location
    Athens Greece
    Posts
    47
    #3
    how do you run powershell from the command prompt if you are in core ?
    Reply With Quote Quote  

  5. Senior Member
    Join Date
    Jul 2016
    Location
    USA
    Posts
    173

    Certifications
    A+, MCP (70-410, 70-411)
    #4
    By default it should run as administrator being you log in as administrator. In windows core, type powershell and hit enter. you should enter PS
    Reply With Quote Quote  

  6. Member
    Join Date
    Dec 2016
    Location
    Athens Greece
    Posts
    47
    #5
    i cannot enter as administrator . only option is kim_akers or other.

    I succeeded the powershell command so now i am in
    PS C:\users\kim_akers\> and i type

    PS C:\users\kim_akers\> dism /online /enable-feature /featurename:netfx3 /all /source:d:\sources\sxs

    and of course i get error that the command is wrong or the path is incorrect.
    the cd is mounted in d.

    nothing works for me. i guess i am too nube for this
    Reply With Quote Quote  

  7. Member
    Join Date
    Dec 2016
    Location
    Athens Greece
    Posts
    47
    #6
    oh wait it worked now that i tried again.

    i wander if this space before every slash is required " /" , or i was just spelling it wrongly before
    Reply With Quote Quote  

  8. Senior Member
    Join Date
    Jul 2016
    Location
    USA
    Posts
    173

    Certifications
    A+, MCP (70-410, 70-411)
    #7
    Yes. The spaces are required as it separates the switches. You can run command prompt in powershell but you can't run powershell cmdlets in the command prompt. While in powershell "ipconfig" will still work.
    Reply With Quote Quote  

  9. Senior Member
    Join Date
    Jul 2016
    Location
    USA
    Posts
    173

    Certifications
    A+, MCP (70-410, 70-411)
    #8
    Cool trick if you don't know. If you add your remote servers to server manager, you can install Roles and Features on those remote servers without touching them.

    And you will probably need to follow this when installing SQL Server 2014 on Server 2012 R2 as well. I haven't gotten to installing SQL Server 2014 yet.

    Oh ektorakos, we all started out as noobs. Don't give up, it can be frustrating but do not give up!
    Last edited by AvgITGeek; 03-31-2017 at 12:56 AM.
    Reply With Quote Quote  

+ Reply to Thread

Social Networking & Bookmarks