05/18/2010 19:48:42

This Release Notes document contains information for SQL Server 2008 R2 that supplements the SQL Server 2008 R2 Readme and Books Online documentation. This document describes behaviors that apply only to this release or that are not documented in this release of Books Online.

The Release Notes document is available only online. It is not available on the installation media. The Release Notes are updated periodically as required until the next release. The current version of this file is available on the Release Notes download page.

If you have feedback about SQL Server 2008 R2, please submit it at Microsoft SQL Server Connect.

What's New

For information about the new features in SQL Server 2008 R2, see What's New in SQL Server 2008 R2

Other Issues

If you encounter an issue with SQL Server 2008 R2 other than those listed in the release notes, you may find a solution on the Microsoft Support site for SQL Server 2008 R2.


1.0 Before You Install

1.1 Reinstalling SQL Server 2008 Books Online After Upgrade May Display Incorrect Topic Heading

If you upgrade to SQL Server 2008 R2 Books Online from SQL Server 2008 with shared components including SQL Server Books Online, and later reinstall SQL Server 2008 Books Online, you may experience minor issues, such as a default starting topic with a SQL Server 2008 R2 heading.

Stand-alone installations of SQL Server 2008 Books Online that are upgraded to SQL Server 2008 R2 Books Online and later restored to SQL Server 2008 Books Online do not exhibit this behavior.

To avoid this problem, view the SQL Server 2008 R2 Books Online content online until you are certain you want to upgrade.

1.2 SQL Server 2008 R2 Is Not Supported on the Same Platforms as SQL Server 2008

SQL Server 2008 R2 no longer supports Windows XP x86 SP2, Windows Vista original release version, Windows Vista SP1, and Windows Server 2008 SP1. Setup does not prevent you from installing SQL Server on these unsupported operating systems. If you try to install SQL Server 2008 R2 on unsupported systems, you may encounter an installation failure or a problem during upgrade. For more information, see this Knowledge Base article. We recommend that you review the hardware and software requirements to ensure that SQL Server 2008 R2 is installed on supported operating system platforms.

1.3 Installing SQL Server Books Online Requires .NET Framework 2.0

Installing SQL Server 2008 R2 Books Online on systems that only have .NET Framework 4 installed may result in error messages when clicking the Search, How Do I, and Help Favorites buttons in the Help Viewer toolbar. To avoid this behavior, install the latest version of .NET Framework 2.0.

1.4 Japanese Version of SQL Server 2008 R2 Requires Dual-Layer DVD (DVD-9) Media

The Japanese version of the SQL Server 2008 R2 release-to-manufacturing DVD image does not fit on traditional DVD-5 media. To install the Japanese version of SQL Server 2008 R2, you may download the ISO file and mount it to a virtual drive. To create an installation disk, you must a use a dual-layer DVD (DVD 9) media.


2.1 Instances of SQL Server 2000 Cannot be Enrolled into the SQL Server 2008 R2 Utility Control Point

Instances of SQL Server 2000 cannot be enrolled into the SQL Server 2008 R2 utility control point. This requirement should be checked by a validation step in the enroll instance workflow. However, if the version of the specified instance of SQL Server 2000 SP4 is less than 8.0.2055, then an encryption error occurs when attempting to connect to the instance in the first step of the enrollment workflow. If the version of the instance of SQL Server 2000 SP4 is 8.0.2055 or higher, then connection to specified instance of SQL Server 2000 SP4 succeeds. Version 8.0.2055 includes a security patch for SQL Server 2000 SP4 (available from the Download Center).


3.1 Possible Slow Startup for Computers That Are Part of a Domain If PowerPivot Is Installed

If you have the PowerPivot add-in installed on a computer that is part of a domain, Excel can take up to 60 seconds to start. Excel may crash in some situations if the network connection for the computer is slow, or if the computer has difficulty connecting to the network.


4.0 Integration Services

5.0 Replication

6.0 Reporting Services

7.0 Service Broker

8.0 Master Data Services

8.1 Changing Entity Name Breaks Related Business Rules

When you change an entity name and that entity is used in a business rule, errors occur when you try to edit the business rule. On the Business Rule Maintenance page, you receive the following error when you try to edit a field in the grid: "The entity reference is not valid. The entity was not found."

As a workaround, perform the following steps:

  1. On the Business Rule Maintenance page, select the model that contains the entity with the new name. Select the Entity, Member Type, and Attribute.

  2. In the grid, select a business rule, and click Edit selected business rule.

  3. On the Edit Business Rule page, in the Then pane, select an action and click Delete.

4. Recreate the action and click Save.

8.2 Unable to Use Model Deployment to Stage Collection Relationships for Collections of Collections

In Master Data Manager, when you use Model Deployment, collection relationships for collections of collections are not staged into new or target models. Collections must be staged manually.

8.3 Error When Validating a Version That Does Not Belong to the Model Selected on the Manage Versions Page

In Master Data Manager, on the Versions: Validate Version page, you receive the following error message when selecting a model and a version to validate: "The Version object with an ID of <ID> does not exist or access is denied."

This happens when you select a different model on the Versions: Validate Version page than the model you selected on the Manage Versions page when you first accessed the Version Management functional area.

As a workaround, return to the Home page and click Version Management. On the Manage Versions page, from the Model drop-down list, select the model that contains the version you want to validate. Then click Validate Version and attempt to validate the version again.

8.4 Overlapping Group Permissions Are Too Restrictive

9.0 Upgrade Advisor

10.0 StreamInsight

11.0 Logo Certification

11.1 AppVerifier TLS Checks Must Be Disabled When Running SQL Server

If AppVerifier Thread Local Storage (TLS) checks are enabled, SQL Server will terminate. To determine how to disable TLS checks, consult the AppVerifier documentation.

11.2 Ignore Non-blocking Logo Issues from External Files

SQL Server 2008 R2 installs the following external files. These files are showing non-blocking Logo issues. No user action is required.

The following files are showing ICE errors:

Netfx35_sqlsupport.msi - ICE61 Error, Netfx30a_x64.msi - ICE27 Error, Netfx30a_x86.msi - ICE27 Error, RGB9RAST_X86.msi ICE27 Error, RGB9RAST_X64.msi ICE27 Error, Synchronization.msi ICE61 Error, SyncServicesADO.msi ICE61 Error, Trin_aide.msi ICE61 Error, Trin_adtl.msi ICE61 Error.

The Following MSIs are using custom columns:

Netfx20_x64.msi, Netfx20_x64.msi

The following executables are not manifested:

DTSRun.exe,vshost.exe, vshost32.exe, DFUICOM.EXE, UserControlTestContainer.exe, dexplore.exe.

The following DLLs have incomplete file properties:

ddsshapeslib.dll, msddsp.dll, 8cb4vwmr.dll, Microsoft.mshtml.dll, Microsoft.Synchronization.Data.SqlServerCe.dll.

The following DLLs are installed by signed MSIs. The DLLs are not individually signed:

extensibility.dll, Microsoft.VisualStudio.ConfigurationUI.dll, Microsoft.VisualStudio.DesignUI.dll, microsoft.visualstudio.dll, Microsoft.VisualStudio.VSHelp.dll, Microsoft.VisualStudio.Windows.FormsUI.dll, Microsoft.VisualStudio.WPFFlavor.dll, Microsoft.VisualStudio.XmlEditor.dll, Microsoft.VisualStudioUI.dll, Microsoft.Windows.Design.dll, Microsoft.Windows.Design.Extensibility.dll, Microsoft.Windows.Design.Interaction.dll, Microsoft.Windows.Design.Markup.dll, Microsoft.XmlEditor.dll, Microsoft.XmlEditorUI.dll, msvcr71.dll, UserControlTestContainer.exe, VSLangProj2.dll, WindowsFormsIntegration.Design.dll, WindowsFormsIntegration.Package.dll, WinFxBrowserApplicationTemplateWizard.dll, MSADDNDR.DLL, Microsoft.mshtml.dll, msddsp.dll, USP10.DLL, adodb.dll, stdole.dll, atl80.dll, cmddef.dll, cmddefui.dll, compluslm.dll, Compsvcspkg.dll, compsvcspkgui.dll, dexplmnu.dll, dexplmui.dll, envdte.dll, envdte80.dll, mfc80.dll, MFC80CHS.DLL, MFC80CHT.DLL, MFC80DEU.DLL, MFC80ENU.DLL, MFC80ESP.DLL, MFC80FRA.DLL, MFC80ITA.DLL, MFC80JPN.DLL, MFC80KOR.DLL, mfc80u.dll, Microsoft.VisualStudio.CommandBars.dll, Microsoft.VisualStudio.DataTools.dll, Microsoft.VisualStudio.DataTools.Interop.dll, Microsoft.VisualStudio.ExportTemplateUI.dll, Microsoft.VisualStudio.TemplateWizardInterface.dll, Microsoft.VisualStudio.VSContentInstaller.dll, Microsoft.VisualStudio.VSHelp80.dll, Microsoft.Vsa.Hosting.dll, Microsoft.WizardFramework.dll, Microsoft.WizardFrameworkVS.dll msemp.dll, msempui.dll, msenv.dll, msenvui.dll, msvcp80.dll, msvcr80.dll, ProjectAggregator.dll, vdt80.dll, vdt80p.dll, vdt80pui.dll, vdt80ui.dll, vsdebug.dll, vsdebugui.dll, VSLangProj.dll, VSLangProj80.dll, vslog.dll, vslogui.dll, VsMacroHierarchyLib.dll, vsmsoui.dll, vsp.dll, vssln.dll, vsslnui.dll, VssProvider.dll, VssProviderStub.dll, VssProviderStubui.dll, VssProviderui.dll, vstlbinf.dll, VsWebSite.Interop.dll, csformatui.dll, envdte90.dll, envdte90a.dll, iisresolver.dll, Microsoft.Data.Entity.Design.dll, Microsoft.Data.Entity.Design.EntityDesigner.dll, Microsoft.Data.Entity.Design.Package.dll, Microsoft.Data.Tools.XmlDesignerBase.dll, Microsoft.JScript.AuthoringServices.dll, Microsoft.ReportDesigner.dll, Microsoft.ReportViewer.Common.dll, Microsoft.ReportViewer.WebForms.dll, Microsoft.ReportViewer.WinForms.dll, Microsoft.VisualStudio.CSharp.Services.Language.dll, Microsoft.VisualStudio.Data.Compatibility.dll, Microsoft.VisualStudio.Data.Host.dll, Microsoft.VisualStudio.Data.Interop.dll, Microsoft.VisualStudio.Data.Package.dll, Microsoft.VisualStudio.Data.Providers.Common.dll, Microsoft.VisualStudio.Data.Providers.Oracle.dll, Microsoft.VisualStudio.Data.Providers.SqlEverywhere.dll, Microsoft.VisualStudio.Data.Providers.SqlServer.dll, Microsoft.VisualStudio.Data.ServicesWizard.dll, Microsoft.VisualStudio.DataDesign.SyncDesigner.Dsl.dll, Microsoft.VisualStudio.DataDesign.SyncDesigner.DslPackage.dll, Microsoft.VisualStudio.Debugger.DataSetVisualizer.dll, Microsoft.VisualStudio.Debugger.dll, Microsoft.VisualStudio.DebuggerVisualizers.dll, Microsoft.VisualStudio.HostingProcess.Utilities.dll, Microsoft.VisualStudio.HostingProcess.Utilities.Sync.dll, Microsoft.VisualStudio.IDE.ToolboxControlsInstaller.dll, Microsoft.VisualStudio.ORDesigner.Dsl.dll, Microsoft.VisualStudio.ORDesigner.DslPackage.dll, Microsoft.VisualStudio.ToolBoxControlInstaller.dll, Microsoft.VisualStudio.Tools.Applications.Adapter.v9.0.dll, Microsoft.VisualStudio.Tools.Applications.AddInAdapter.v9.0.dll, Microsoft.VisualStudio.Tools.Applications.Contract.v9.0.dll, Microsoft.VisualStudio.Tools.Applications.DesignTime.v9.0.dll, Microsoft.VisualStudio.Tools.Applications.HostAdapter.v9.0.dll, Microsoft.VisualStudio.Tools.Applications.Hosting.v9.0.dll, Microsoft.VisualStudio.Tools.Applications.ProgrammingModel.dll, Microsoft.VisualStudio.Tools.Applications.Runtime.v9.0.dll, Microsoft.VisualStudio.Web.Application.dll, Microsoft.VisualStudio.Web.dll, Microsoft.VisualStudio.XsdDesigner.dll, Microsoft.VisualStudio.XsdDesignerPackage.dll, Microsoft.Web.Design.Client.dll, msddslmp.dll, NatDbgEEUI.dll, VSLangProj90.dll, VsWebSite.Interop90.dll, WinFxCustomControlTemplateWizard.dll, Microsoft.Data.ConnectionUI.Dialog.dll, Microsoft.Data.ConnectionUI.dll, Microsoft.VisualStudio.Data.dll, Microsoft.VisualStudio.ExportTemplate.dll, Microsoft.VisualStudio.TemplateWizard.dll, Microsoft.VisualStudio.Tools.Applications.Project.dll, mergemod.dll, custsat.dll

11.3 Ignore Non-Blocking Logo Issues from Internal Files