Sql server 2014 with Windows server 2012 R2 - Datacenter

  • Hi

    we want to change version of our servers to these versions :

    - windows server 2012 R2 Datacenter

    - sql server 2014 (without any packs)

    Are they compatible with each other?

    thank you

  • Exactly the kind of information it's always best to go directly to the source for. This is Microsoft's documentation on the OS versions required for SQL Server 2014. The two versions you're looking at will work.

    If you install SQL Server 2014, I recommend you also install the latest cumulative update (CU6 right now). There are a number of issues that this addresses.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Thank you

    And what is "sql server 2014 RTM"

    RTM is a seperate version ?

    If I download Cumulative Update #6 is enough or I must download all of them?

  • RTM means Release to Manufacturing. It's the released product without any kind of updates or service packs applied. It's not recommended to use RTM.

    To use the cumulative update, you only need the latest. It will have the other updates included in it. Currently, we have CU6, that includes CU1-5.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • MotivateMan1394 (4/12/2015)


    Hi

    we want to change version of our servers to these versions :

    - windows server 2012 R2 Datacenter

    - sql server 2014 (without any packs)

    Are they compatible with each other?

    thank you

    SQL server 2014 is compatible with Windows 2012 R2 Datacenter edition. Please see this link for more detail

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • I Installed CUP6 .

    And when it recieved to checks , I stoped the sql server services.

    and continue ....

    But at the end It reported that the instalation done with some error.

    I saw the list and for main service (sqlserver) It was failed.

    And then advised to uninstall this and reinstall again.

    But in control panel I dont see any title about this. which program I should to remove and install again ?

    (How can I attach an image to a message?)

  • It would be very helpful to know the error.

    You can attach an image by scrolling down. There's a section below called Attachments.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply