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.
For information about the new features in SQL Server 2008 R2, see What's New in SQL Server 2008 R2.
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
For information about where to get assistance with installing SQL Server 2008 R2, consult the SQL Server 2008 R2 Readme. The Readme is available from the Readme download page.
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
6.0 Reporting Services
There are no notes for this component in this release of SQL Server 2008 R2.
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:
On the Business Rule Maintenance page, select the model that contains the entity with the new name. Select the Entity, Member Type, and Attribute.
In the grid, select a business rule, and click Edit selected business rule.
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
When user and group hierarchy member permissions are combined, the effective permissions may be more restrictive than expected. Read-only permissions are taking precedence when they are assigned at a lower level than Update, even though Update permissions should always take precedence.
As a workaround, assign all hierarchy member permissions to a single group, and add the user to that group. Each user should not belong to more than one group with permissions assigned in Master Data Manager.
9.0 Upgrade Advisor
10.1 Event Flow Debugger Start Page Is Available in English Only
The Event Flow Debugger is localized into several languages; however, the content on the Start page is available only in English. There is no workaround for this issue.
10.2 Use Distinct Object Names for Installations That Do Not Use the en-US Culture
The StreamInsight metadata provider always uses the "en-US" culture. For object names created in other cultures, use distinct object names that can be uniquely identified when compared using an en-US locale.
10.3 Updated Documentation Is Available
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:
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
The following legacy files are installed with SQL Server 2008 R2. These files are unsigned and installed from a signed MSI. No action is required.
CDWTasks.dll, CustTask.dll, DTSFFile.dll, DTSPkg.dll, DTSPump.dll, DTSRun.exe, msmddo.dll, msmddo80.dll, msmdint.dll, msmdlock.dll, msmdnet.dll, msmdtsp.dll, MSOLAP80.DLL, repldts.dll, semmap.dll, SQLDMO.DLL, sqlresld.DLL.
SQL Server 2008 R2 installs a legacy version of MSClusterlib.dll as part of setup support files. This version of the file doesn’t have a valid "Company Name" and "Product Name" property.
SQL Server 2008 R2 installs the following three files. These files are not uninstalled when uninstalling the full product:
C:\Program Files\Common Files\Microsoft Shared\DW\DW20.EXE
C:\Program Files\Common Files\Microsoft Shared\DW\DWTRIG20.EXE
This behavior is expected.