Link to home
Start Free TrialLog in
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
SOLUTION
Avatar of yo_bee
yo_bee
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
Avatar of Netsol-NOS
Netsol-NOS

ASKER

Thanks for your kind feedback.