OK to install MS SQL 2008R2 64 bit STANDARD on Windows 2008R2 64 bit ENTERPRISE?

Posted on 2011-05-06
Last Modified: 2012-05-11
Our organization has standardized on Windows 2008R2 64 bit ENTERPRISE..

To save costs, we would like to install MS SQL 2008R2 64 bit STANDARD on the above box.

Any problems with this  (i.e. enterprise for OS. standard for SQL)?  (The hardware is Dell server class.)

Also, to go one level of complexity higher, we would like to consider installing the above in VMware.
Again, any known problems?

[We do not plan to do clustering of the db or anything like that.]

Question by:dpsit
    LVL 6

    Accepted Solution

    No, there are no problems with what you have mentioned. However there are some features in Enterprise that are not in Standard which you may need.
    LVL 6

    Assisted Solution

    One that I found was that with reporting services, you could not create data driven subscriptions, which I use for mailing reports.
    LVL 6

    Expert Comment

    You can always upgrade you edition at any time via the installation tool > maintenance, edition upgrade.

    Upgrade Paths\

    How to Upgrade

    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now