Avatar of Netsol-NOS
Netsol-NOS
 asked on

MS SQL Server 2008 R2 Enterprise Edition on Windows Server 2008 R2 Standard Edition

Hello Team,

Is there any issue/conflicts/limitation to install MS SQL Server 2008 R2 Enterprise Edition on Windows Server 2008 R2 Standard Edition.

OR their is nothing to worry about it I guess their is memory limitation between both of them. Please suggest


Regards
Microsoft Legacy OSMicrosoft Server OSWindows Server 2008

Avatar of undefined
Last Comment
Netsol-NOS

8/22/2022 - Mon
SOLUTION
yo_bee

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER CERTIFIED SOLUTION
Ryan McCauley

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
David Todd

Hi,

Quick question? Why SQL Enterprise? And just to check, 64-bit editions of each?

SQL Standard 2008R2 has a memory limit of 64GB, but Windows 2008 standard has a memory limit of 32GB if memory is correct.

So unless you need the features of Enterprise or from some business takeover/buy-out/whatever you've been gifted an Enterprise licence, I'd suggest Standard Edition.

In the past, on 32bit editions, it was necessary to use Windows Enterprise to access additional ram.

HTH
  David
Netsol-NOS

ASKER
Thanks for your kind feedback.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck