Microsoft SQL Server 2008 R2 Web - license & software assurance

Mfg. Part: TFA-00482 | CDW Part: 2320073 | UNSPSC: 43232304
$331.99Advertised Price

Have leasing questions? Let us know how can we help.

Note: Leasing is available to businesses only. Leasing is not available to individuals.
Mon-Fri 7am-7:30pm CT
Availability:In Stock
Ships same day if ordered before 4 PM CT
  • License & software assurance
  • 1 processor
  • additional product
  • annual fee
  • MOLP: Open Value Subscription
  • level E
  • Win
View More
Product Overview
Main Features
  • License & software assurance
  • 1 processor
  • additional product
  • annual fee
  • MOLP: Open Value Subscription
  • level E
  • Win
  • All Languages
SQL Server 2008 R2 delivers several breakthrough capabilities that will enable your organization to scale database operations with confidence, improve IT and developer efficiency, and enable highly scalable and well managed business intelligence on a self-service basis for your users.

It supports data consistency across heterogeneous systems through SQL Server master data services, enabling high-scale complex event-stream processing through SQL Server StreamInsight, and supporting scale-up scenarios for the large available x64 and Itanium hardware.

Enabling administrators to centrally monitor and manage multiple database applications, instances or servers, accelerating the development and deployment of applications and providing improved support for virtualization through Hyper-V with live migration in Windows Server 2008 R2.

Expanding powerful BI tools to all users with SQL Server PowerPivot for Excel and empowering the class of business users to build and share powerful BI solutions with little or no IT support, while still enabling IT to monitor and manage user-generated BI solutions.


With the Subscription option, you pay a single price per desktop (five desktop minimum) to deploy Microsoft technology as the standard across your organization, just as with the Company-wide option. However, the Subscription option provides you with rights to run the software only during the term of the agreement with Microsoft (nonperpetual).


Microsoft's Software Assurance gives you automatic access to new technology and provides productivity benefits, support, tools, and training to help deploy and use software efficiently.

With Software Assurance, you receive access to new versions of licensed software released during the term of your agreement to deploy at your own pace. New Version Rights simplifies the procurement process and shortens the business process cycle, allowing you to reduce the costs associated with acquiring new version releases and immediately take advantage of the latest technology.
Technical Specifications
Specifications are provided by the manufacturer. Refer to the manufacturer for an explanation of the print speed and other ratings.
System Requirements
Platform: Windows

License Category: License
License Qty: 1 processor
License Type: License & software assurance
Licensing Program: MOLP: Open Value Subscription

Support Details Full Contract Period: Full-term

Brand: Microsoft
Compatibility: PC
Localization (Vendor Specific): Microsoft All Languages
Manufacturer: Microsoft Open Value Education
Model: Server 2008 R2 Web
Packaged Quantity: 1
Product Line: Microsoft SQL

Service & Support Details
Service Type: New releases update

Software Family
Microsoft Edition: Web
Microsoft Family: MS SQL Server
Microsoft Version: Non-Specific

Category: Business applications
Subcategory: Business - databases / database tools

License Pricing: Additional product , Annual fee , Volume
Pricing Level: Level E

Service & Support
Type: New releases update

Product Reviews
Rated 3.9 out of 5 by 60reviewers.
Rated 4 out of 5 by Great for small businesses however the limitations can inspire the need to upgrade to full licenses. Not always a problem however it is important to note this with expanding DB's. September 5, 2016
Rated 5 out of 5 by Provides many ways to help us organize data and process information. Valuable Features:The Microsoft SQL Server is a great and powerful data storage capable to provide many functionalities starts on free version until the power with BI resource and mirroring.Improvements to My Organization:MS SQL is a recognized data tool, it provides many ways to help us organize data and process information.Room for Improvement:MS SQL need to improve the big data functions and also own market share.Disclaimer: I am a real user, and this review is based on my own experience and opinions. August 9, 2016
Rated 4 out of 5 by The MSBI features SSAS, SSIS as well as SSRS together, has enabled us to build a data warehouse for our Enterprise. Valuable Features:I would rate MS SQL Server 4/5 for its ease of administration,rich features, Nice GUI support for all its complex features.Valuable features include:1.Management Studio (Nice GUI support for all its complex features.)2.Hot add CPU3.Configure Dynamic memory also configure MIN and MAX memory.( Very flexible)4.Replication ( Very Simple).5.Clustering (The best high availability feature available among allits compitators due to its robustness and scalability).6.SSIS ( Very rich).7.In memory OLTP in SQL Server 20128.Always On (High Availability) in SQL Server 2012Improvements to My Organization:The MSBI features SSAS, SSIS as well as SSRS together has enabled us to build a data warehouse for our Enterprise with Business Intelligence reports around the data. We have fully exploited its all complex features like Slowly Changing Dimensions in SSIS etc.Room for Improvement:I am not sure if these areas have been taken care in SQL 2012 but areas for improvement include:1.In SQL 2008 ,Data encryption is not a fully mature feature.Encryption works fine for individual rows.For handling a batch a for loop has to be written.This is not straight forward.2.Horizontal partitioning is not a fully mature feature.In horizontal partitioning Partition key has to be part of primary key.This becomes difficult to implement in already existing database.Use of Solution:14 years.Deployment Issues:No not at all.Stability Issues:No.Scalability Issues:No.Customer Service:Good.Technical Support:Good. We have had only a few issues.Previous Solutions:We were a Microsoft shop (.NET, Share point etc) primarily, hence using MS SQL Server 2008.Initial Setup:It was straightforward.Implementation Team:We implemented through in-house.Other Advice:1. Find out the right licensing mode you require (Comes with different options CAL/Server and # of CPUs and Virtualisation).2. Use the Enterprise lincencing or Standard edition or Web according to your need.3.Make use of SQL Server Clustering or LOg Shipping high availability solution, the best you can find.Disclaimer: I am a real user, and this review is based on my own experience and opinions. July 31, 2016
Rated 4 out of 5 by SQL Server is solid enough and easy to tie in with an Excel front end. Linked server to AS400 DB2 under our legacy ERP. June 30, 2016
Rated 4 out of 5 by We're able to create an end-to-end automated BI platform, but we'd prefer hosting multidimensional OLAP instances with Tabular rather than the either/or installation. Valuable Features:* Business intelligence platform* Analysis services (multidimensional and tabular)* Relational database features* Data extraction and transformation (integration services)Improvements to My Organization:It provides the ability to create an end-to-end automated BI platform through data management and provisioning, transformation and publication.Data platform development process improvement: Integrating the features of Visual Studio Team Foundation Server data projects for SQL Server development. Allows for smooth operation between development environments in conjunction with an agile process to release database changes.Room for Improvement:Hosting multidimensional OLAP instances in conjunction with Tabular, rather than the either/or installation.OLAP multidimensional ongoing maintenance - automated partitioning or interface for streamlining the mechanism within the cube and data layers.Integration Services: There is a great deal of room for improvement here in that thepackages are the least extensible part of the platform. Even with the feature ofplatform variables, since these are not easily managed and deployed. Our testers have had a great deal of difficulty swapping environments, particularly where the connection information changes (underlying database name, for example). Changing servers with identical database names is less problematic.Use of Solution:I've used it since its release in 2012 until now.Deployment Issues:No issues encountered.Stability Issues:There were some avoidable issues, primarily due to a lack of scaling in our own design.Scalability Issues:There were some avoidable issues, primarily due to a lack of scaling in our own design.Customer Service:Online information for SQL Server is extensive.Technical Support:I did not have the need to contact technical support for any reason.Previous Solutions:No, I've only used an earlier version of SQL Server.Initial Setup:It's straightforward to install a new instance, but more complex if new features are added to an existing instance. Deployment of SQL code is efficient through Visual Studio database project development methodologies.Implementation Team:I have used both in-house, and vendor teams for implementation, both with very high levels of expertise into different aspects of database development.ROI:It's very high as the data platform is business-critical.Cost and Licensing Advice:I don’t concentrate on this issue, but rather the necessary features and the version required.Other Solutions Considered:No other oprions were evaluated.Other Advice:Make sure that you have an experienced database administrator to implement the infrastructure of the solution.Disclaimer: I am a real user, and this review is based on my own experience and opinions. June 20, 2016
Rated 5 out of 5 by Was great and easy to set up and run. It is great that they have the express and community versions available, thanks! May 3, 2016
Rated 5 out of 5 by Love management studio. It makes things so easy to have a centralized area to work on the database. It has been a great help to me many times! May 3, 2016
Rated 5 out of 5 by I love that there are different versions available for different needs, this helps a lot! Thanks Microsoft for providing a variety. May 3, 2016
  • 2016-10-30 T09:55:56.356-05:00
  • bvseo_lps, prod_bvrr, vn_prr_5.6
  • cp-1, bvpage1
  • co_hasreviews, tv_60, tr_60
  • loc_en_US, sid_2320073, prod, sort_default
2 3 4 5... 8next>>
Adding to Cart...
12/10/2016 4:28:52 PM
^ Back to Top

Maximum 300 characters
An account manager will email you within one business day to confirm your request.

Your Quote has been submitted

What Happens Next? A confirmation email is on its way. Within one business day, you will be contacted by an Account Manager to finalize your quote.


Something went wrong.

Please try again later.

License Selector

    The license selector is not currently available. Please try again later.