SQL Server 2008 articles, fixes and updates

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft SQL Server 2008 that have been released in March 2009. The list is daily updated.

955721 A replication job does not run successfully in SQL Server 2008, and you may see a message that resembles the following when you view the replication agent status: "The replication agent has not logged a progress message in 10 minutes." Q955721 KB955721 March 27, 2009
969521 SQL Server 2008 Cluster installation Fails with Validation error “The cluster validation either has not been run or contains errors or failures in the validation report. Refer to KB953748 or SQL Server Books Online for working around this issue.” Q969521 KB969521 March 25, 2009
968784 FIX: A key on an EKM provider is created successfully even if the provider does not support the algorithm that is used to create the key in SQL Server 2008 Q968784 KB968784 March 19, 2009
956215 The Databases folder may take longer than expected to open when you expand the folder in Object Explorer in SQL Server 2008 Management Studio Q956215 KB956215 March 19, 2009
956214 Error message when you expand the Databases folder in Object Explorer in SQL Server 2008: "The server principal '<X>' is not able to access the database '<Y>' under the current security context (Microsoft SQL Server, Error:916)" Q956214 KB956214 March 19, 2009
956212 Error message when you try to use a SQL Server 2008 Reporting Services instance: "The report server has encountered a configuration error" Q956212 KB956212 March 19, 2009
956211 The output for list report items from the XML renderer changes when you upgrade to SQL Server 2008 reports Q956211 KB956211 March 19, 2009
956210 The "Remove log entries older than this many days" value may not be saved correctly on the Logging tab of the Server Properties dialog box in SQL Server 2008 Reporting Services Q956210 KB956210 March 19, 2009
956180 Error message when you click the "Tell me more about this issue and how to resolve it" link for flagged components in SQL Server 2008 Upgrade Advisor: "The page cannot be displayed" Q956180 KB956180 March 19, 2009
956174 Error message when you try to assign rights to your user account on a server that is running SQL Server 2008: "Windows NT user or group '<DOMAIN_NAME>\<USER_NAME>' not found" Q956174 KB956174 March 19, 2009
956173 Error message when you try to uninstall SQL Server 2008 Reporting Services: "An error has occurred: Access to the path '<Path of perf-ReportServer-rsctr.dll>' is denied" Q956173 KB956173 March 19, 2009
956171 The property description for the "Enable Ad Hoc Reporting" option is incorrect when you use the SQL Server 2008 Reporting Services Add-in Q956171 KB956171 March 19, 2009
956159 Report Manager may not run after you upgrade to SQL Server 2008 Reporting Services on a computer that is running an x86-based version of Windows XP Q956159 KB956159 March 19, 2009
956157 The Reporting Services subscriptions are not processed in SQL Server 2008 Reporting Services or in SQL Server 2005 Reporting Services Q956157 KB956157 March 19, 2009
956156 Error message when you upgrade from SQL Server Reporting Services 2008 Release Candidate 0 to SQL Server Reporting Services 2008: "Click 'Retry' to retry the failed action" Q956156 KB956156 March 19, 2009
956150 FIX: An image that is nested in a Tablix cell in SQL Server 2008 Reporting Services is displayed incorrectly when the Sizing property of the image is set to AutoSize Q956150 KB956150 March 19, 2009
956149 You cannot use the "Extension" parameter of the device information settings to change the file name extension of an exported .csv report file in SQL Server 2008 Reporting Services Q956149 KB956149 March 19, 2009
956143 Error message when you try to set up SQL Server 2008: "The application has requested the Runtime to terminate it in an unusual way" Q956143 KB956143 March 19, 2009
956142 You receive an error message when you perform the remove node operation on an active SQL Server 2008 node in a clustered instance of SQL Server Q956142 KB956142 March 19, 2009
956141 You receive a "The Collation specified by SQL Server is not supported" error message when you try to install SQL Server 2008 Q956141 KB956141 March 19, 2009
956138 FIX: You cannot upgrade a non-English instance of SQL Server 2000 Reporting Services to SQL Server 2008 Reporting Services Q956138 KB956138 March 19, 2009
956093 When you try to upgrade SQL Server 2005 Reporting Services or SQL Server 2000 Reporting Services to SQL Server 2008, Upgrade Advisor does not detect upgrade deficiencies that are later detected by Setup Q956093 KB956093 March 19, 2009
956092 Error message when you install an instance of SQL Server 2008 Reporting Services on a domain controller: "On a domain controller, you cannot use the built-in Windows service accounts (Local Service or Network Service) as service accounts" Q956092 KB956092 March 19, 2009
956042 Error message when you try to render a report to an XML document in SQL Server 2008 Reporting Services: "An XML element with the name 'elementname' already exists inside of the current parent node (rrElementNameCollision)" Q956042 KB956042 March 19, 2009
956033 The GetValue() method returns a value that differs from the value that you set for a column of the DateTime data type when you use the SqlDataRecord object in a CLR object in SQL Server 2008 Q956033 KB956033 March 19, 2009
956030 Error message when you try to deploy a report to a server that is running Windows SharePoint Services in SQL Server 2008 Business Intelligence Development Studio: "Error rsInvalidItemName: The name of the item 'Data%20Sources' is not valid" Q956030 KB956030 March 19, 2009
956029 When you enable the UseValueAsLabel property for a data field in a 3-D Stacked Area chart or in a 100% Stacked Area chart in SQL Server 2008 Reporting Services, the data labels do not appear in the chart Q956029 KB956029 March 19, 2009
956028 Description of the unsupported Dundas features in SQL Server 2008 Reporting Services Q956028 KB956028 March 19, 2009
956027 Some Dundas Chart features are missing after you convert a SQL Server 2005 Reporting Services report to SQL Server 2008 Reporting Services Q956027 KB956027 March 19, 2009
956026 How to use the new functionalities of the SQL Server 2008 version of SMO in an application that uses the SQL Server 2005 version of SMO Q956026 KB956026 March 19, 2009
956024 Error message when you try to create a WMI event alert by using the sp_add_alert stored procedure in SQL Server 2008: "The @wmi_query could not be executed in the @wmi_namespace provided" Q956024 KB956024 March 19, 2009
956023 You receive an error message when you use a template to create a cube or a dimension in a non-English version of SQL Server 2008 Analysis Services Q956023 KB956023 March 19, 2009
956022 A query whose WHERE clause references a spatial column may return an incorrect or empty result in Microsoft SQL Server 2008 Q956022 KB956022 March 19, 2009
956020 The SQL Server 2008 Reporting Services component is not successfully installed Q956020 KB956020 March 19, 2009
956019 The Setup program ignores the ASCOLLATION property if you specify the ASCOLLATION property when you install SQL Server 2008 Analysis Services at the command prompt Q956019 KB956019 March 19, 2009
956018 Description of how the CDC feature uses the encoding of the __$operation column in SQL Server 2008 Q956018 KB956018 March 19, 2009
956017 You cannot resume a database mirroring session after you perform a rolling upgrade from SQL Server 2005 to SQL Server 2008 if the mirrored database contains a full-text index Q956017 KB956017 March 19, 2009
956016 Error message after you upgrade an instance of SQL Server that is configured as a distributor to SQL Server 2008: "The version of SQL Server used to download the Oracle package code does not match the version of SQL Server running at the distributor" Q956016 KB956016 March 19, 2009
956015 Error message when you try to reinstall SQL Server 2005 after you uninstall a clustered instance of SQL Server 2008: "This application has failed to start because the application configuration is incorrect" Q956015 KB956015 March 19, 2009
956012 The SQL Server Installation Wizard incorrectly lets you change the startup type when you install a clustered instance of SQL Server 2008 Q956012 KB956012 March 19, 2009
956010 Error message when you close the SQL Server Installation Center after you remove the last instance of SQL Server 2008 on a server: "Unable to generate a temporary class" Q956010 KB956010 March 19, 2009
956007 The network name resource and the IP address resource are not removed after you remove a node that you could not install as a SQL Server 2008 failover cluster Q956007 KB956007 March 19, 2009
955974 The SQL Server 2008 Installation Wizard has the "Named instance" option pre-selected when you try to upgrade the default instance Q955974 KB955974 March 19, 2009
955973 You might receive this error message when you try to upgrade to SQL Server 2008 on a computer that is running Windows Server: "Access to the path '<Path>\perf-MSSQL$SQL2008sqlctr.dll' is denied" Q955973 KB955973 March 19, 2009
955972 You cannot change the SQL Server 2008 engine service account to a domain user on a Windows Server 2003 domain controller Q955972 KB955972 March 19, 2009
955969 Error message when you try to change a service account in SQL Server 2008 Integration Services on a Windows Server 2008-based domain controller: "WMI Provider Error" Q955969 KB955969 March 19, 2009
955960 You cannot add a new node to a failover cluster on the "Cluster Node Configuration" page in SQL Server 2008 Q955960 KB955960 March 19, 2009
955953 Changes to an Integration Services Data Mining Model Training destination are not saved in SQL Server 2008 Q955953 KB955953 March 19, 2009
955952 Error message when you try to uninstall SQL Server 2008 Reporting Services on an RODC: "System.Runtime.InteropServices.COMException (0x80070032): The request is not supported. (Exception from HRESULT: 0x80070032)" Q955952 KB955952 March 19, 2009
955951 Error message when you try to upgrade to SQL Server 2008 Reporting Services on an RODC: "The request is not supported. (Exception from HRESULT: 0x80070032)" Q955951 KB955951 March 19, 2009
955949 FIX: Cluster upgrade to SQL Server 2008 fails when SQL Server 2005 cluster nodes have different installed features Q955949 KB955949 March 19, 2009
955948 FIX: When you install a clustered instance of SQL Server 2008, account validation fails even though you have specified the correct domain account and password Q955948 KB955948 March 19, 2009
955943 FIX: The Processes pane in the Activity Monitor incorrectly shows sessions as head blockers in SQL Server 2008 Q955943 KB955943 March 19, 2009
955865 The installation fails when you specify a group name as a service account when you try to install SQL Server 2008 Q955865 KB955865 March 19, 2009
955864 The recovery model is displayed as a number in the properties pane of the Object Explorer Details page in SQL Server 2008 Q955864 KB955864 March 19, 2009
955863 Microsoft SQL Server 2008 may not start after you install it in the root directory of an NTFS volume Q955863 KB955863 March 19, 2009
955851 The CLR is initialized when you query some catalog views or when you run the SQLdiag command prompt utility (Sqldiag.exe) in SQL Server 2008 Q955851 KB955851 March 19, 2009
955849 Error message in SQL Server 2008 when you run an XQuery query that uses a leading colon (:) in a step expression: "Syntax error near ':', expected a step expression" Q955849 KB955849 March 19, 2009
955848 You cannot start the SQL Server service of SQL Server 2008 after you follow the instructions in SQL Server 2008 Books Online to move the Resource database files Q955848 KB955848 March 19, 2009
955827 Error message when you try to repair an instance of SQL Server 2008 or of of SQL Server 2008 R2: "The process cannot access the file because it is being used by another process" Q955827 KB955827 March 19, 2009
955826 Error message when you try to run a query in SQL Server 2008 or in SQL Server 2008 R2: "Msg 916, Level 14, State 1, Line 1" Q955826 KB955826 March 19, 2009
955825 The SQL Server resources fail when you try to detach a SQL Server 2008 or SQL Server 2008 R2 database whose files are available at the root of a cluster shared disk on Windows Server 2008 Q955825 KB955825 March 19, 2009
955824 The processing is slow when you run a data mining association model in a SQL Server 2008 Analysis Services cube Q955824 KB955824 March 19, 2009
955823 Data mining classification results are inconsistent when you use SQL Server 2008 data mining add-ins for the 2007 Microsoft Office system Q955823 KB955823 March 19, 2009
955817 The server that is running SQL Server 2008 Reporting Services stops responding when you use the "Asynchronous Processing = True" setting in the connection string property to generate a report Q955817 KB955817 March 19, 2009
955815 You receive a NullReferenceException error message when you try to add a new node to a SQL Server 2008 Failover Cluster installation Q955815 KB955815 March 19, 2009
955811 When you use SQL Server 2008 Reporting Services, the ReportingServicesService.exe process may stop responding during CLR garbage collection Q955811 KB955811 March 19, 2009
955810 Error message when you use the Mozilla Firefox version 3.0 browser to log on to a report server in SQL Server 2008 Reporting Services: "Access is Denied" Q955810 KB955810 March 19, 2009
955809 Error message when you try to download the Report Builder client in SQL Server 2008 Reporting Services: "HTTP 500 (Internal Error)" Q955809 KB955809 March 19, 2009
955808 You receive a blank screen in Internet Explorer when you exceed the chances that you are given to enter correct credentials to log on to a report server in SQL Server 2008 Reporting Services Q955808 KB955808 March 19, 2009
955802 Query Designer in SQL Server 2008 does not display keywords in color, and carriage returns are displayed as small squares or vertical bars, when you create an MDX query Q955802 KB955802 March 19, 2009
955793 Error message when you try to install SQL Server 2008: "Setup cannot copy the file" Q955793 KB955793 March 19, 2009
955783 You cannot add an active node to a failover cluster after you upgrade the passive node in the failover cluster to SQL Server 2008 from SQL Server 2000 or from SQL Server 2005 Q955783 KB955783 March 19, 2009
955781 When you install SQL Server 2008, SQL Server Setup retries the installation of a component when some Windows Installer error codes are returned Q955781 KB955781 March 19, 2009
955770 You cannot upgrade an instance of SQL Server 2005 to SQL Server 2008 by using the command prompt Q955770 KB955770 March 19, 2009
955764 The checkpoint for the registry subkey that is associated with SQL Server Agent is not added when you repair the SQL Server 2008 cluster instance Q955764 KB955764 March 19, 2009
955762 You receive errors when you try to migrate script tasks that were created by using SQL Server 2008 Release Candidate 0 or SQL Server 2008 Community Technology Preview Q955762 KB955762 March 19, 2009
955761 Error message when you use the SYS.DM_FTS_FDHOSTS command to return information on the current activity of the filter daemon host for an instance of SQL Server 2008: "A system assertion check has failed" Q955761 KB955761 March 19, 2009
955760 Error message when you try to run the SQL Server 2008 Setup program: "Setup was unable to open the file" Q955760 KB955760 March 19, 2009
955758 Error message when you try to add a node to a failover cluster by using the AddNode action in the setup command when you install SQL Server 2008: "Password specified for well known NT account NT AUTHORITY\LOCAL SERVICE" Q955758 KB955758 March 19, 2009
955756 Error message in the SQL Server 2008 log file viewer when you evaluate a policy whose evaluation mode is not valid: "Unexpected value for enumeration type AutomatedPolicyEvaluationMode" Q955756 KB955756 March 19, 2009
955724 Error message when you try to run an Integration Services package in SQL Server 2008: "DTS_E_CANTCREATESPOOLFILE" Q955724 KB955724 March 19, 2009
955718 Error message when you use the “sp_fulltext_resetfdhostaccount” stored procedure in SQL Server 2008: “Error 2812. Could not find stored procedure 'sp_fulltext_resetfdhostaccount'” Q955718 KB955718 March 19, 2009
955716 Some columns incorrectly display the "date" column data type after you use the SQL Server Import and Export Wizard to import data from SQL Server 2008 Q955716 KB955716 March 19, 2009
955712 You cannot view the properties of the "Surface Area Configuration for Reporting Services" facet in SQL Server 2008 that on a Windows Vista-based computer or on a Windows Server 2008-based computer Q955712 KB955712 March 19, 2009
955711 You receive an exception error message instead of a relevant error message when you try to change the state of a SQL Server service by using SQL Server Management Studio in SQL Server 2008 Q955711 KB955711 March 19, 2009
955709 How to create a shared package configuration file in SQL Server 2008 Integration Services Q955709 KB955709 March 19, 2009
955667 A repair operation fails when you repair a stand-alone instance of SQL Server 2008 that is installed on a node of a server cluster Q955667 KB955667 March 19, 2009
955666 Error message when you try to install SQL Server 2008 if the path of the SQL Server 2008 installation media contains a number sign (#) character: "Could not load file or assembly '<Path>\Microsoft.SQL.Chainer.PackageData.dll' or one of its dependencies" Q955666 KB955666 March 19, 2009
955647 How to configure the polling interval that is used by SQL Server Management Studio in SQL Server 2008 Q955647 KB955647 March 19, 2009
955646 Error message when you try to run an SSIS package in SQL Server 2008: "The package cannot execute because it contains tasks that failed to load" Q955646 KB955646 March 19, 2009
955643 A delimited flat file is parsed incorrectly when you use the Flat File source or a Flat File connection manager in SQL Server 2008 Q955643 KB955643 March 19, 2009
955638 You receive a SQL Server 2005 connection failure error message when you try to connect to an instance of SQL Server 2008 in SQL Server Management Studio Q955638 KB955638 March 19, 2009
955636 The SQL Server 2008 Integrated Services OLE DB Source adapter may obtain only the first row of a source table when you use a Sybase Adaptive Server Enterprise OLE DB provider Q955636 KB955636 March 19, 2009
955634 SSIS imports only one row into the dataflow when you use the ASE OLE DB provider from Sybase as the source in SQL Server 2008 Q955634 KB955634 March 19, 2009
955632 The SSIS performance counter is no longer available in the Performance Monitor after you upgrade to Windows Server 2008 Q955632 KB955632 March 19, 2009
955631 Error message when you try to run a SQL Server 2008 tool at a command prompt after you upgrade to SQL Server 2008 from SQL Server 2005: "The SSIS Runtime object could not be created" Q955631 KB955631 March 19, 2009
955630 When you try to use SQL Server 2008 Business Intelligence Development Studio to create an Integration Services Connections project, the project is not created Q955630 KB955630 March 19, 2009
955629 You receive an error message when you run an application, script, or functionality from an earlier SQL Server installation that uses common language runtime features in SQL Server 2008 or in SQL Server 2008 R2: "A .NET Framework error occurred" Q955629 KB955629 March 19, 2009
955627 You cannot run the Data Profile Viewer in SQL Server 2008 on a computer that is running a 64-bit version of Windows Q955627 KB955627 March 19, 2009
955624 You may be unable to upgrade SQL Server 2000 to SQL Server 2008 when you run SQL Server 2005 and SQL Server 2000 on the same computer Q955624 KB955624 March 19, 2009
955620 A SQL Server 2005 Integration Services package that contains a Script task or a Script component does not run in SQL Server 2008 Q955620 KB955620 March 19, 2009
955525 Error message when you build an SSIS package in SQL Server 2008: "Name 'Dts' is not declared" Q955525 KB955525 March 19, 2009
955511 The setup Summary.txt file reports a failure when you upgrade to SQL Server 2008 from SQL Server 2005 or from version 5 or version 6 of SQL Server 2008 CTP Q955511 KB955511 March 19, 2009
955509 Upgrade to SQL Server 2008 fails in a multi-node cluster environment when a remote node is paused Q955509 KB955509 March 19, 2009
955508 An error message contains invalid DatasetName data when you generate a report in SQL Server 2008 Reporting Services Q955508 KB955508 March 19, 2009
955507 If you select the Import option on the Full-Text Upgrade Option page of the SQL Server 2008 installation wizard during an upgrade from SQL Server 2000, the computer's performance decreases Q955507 KB955507 March 19, 2009
955505 Error message when you use a startup script to start the SQL Server PowerShell provider in SQL Server 2008: "Set-Location: Object reference not set to an instance of an object" Q955505 KB955505 March 19, 2009
955495 Incorrect characters appear in a SQL Server Reporting Services report after you export it to a PDF file Q955495 KB955495 March 19, 2009
955492 You may receive errors when you perform tests that are documented in the Windows Server 2008 Software Logo Test Framework document for SQL Server 2008 Q955492 KB955492 March 19, 2009
955463 Error message in the Detail_ComponentUpdate.txt file when you try to install SQL Server 2008: "Action 'PassPidBackFromComponentUpdate' threw an exception during execution" Q955463 KB955463 March 19, 2009
955431 You cannot create a new instance of SQL Server in the SQL Server Installation Wizard when you upgrade to SQL Server 2008 from SQL Server 2000 Q955431 KB955431 March 19, 2009
955405 The Setup.exe program is unable to remove security code groups that were created during the installation of SQL Server 2008 Q955405 KB955405 March 19, 2009
955402 Incorrect warning message when you downgrade SQL Server 2008: "The selected instance of SQL Server is a valid downgrade scenario" Q955402 KB955402 March 19, 2009
955401 SQL Configuration Manager that is running on a Windows Server 2008-based domain controller does not restrict the change of a SQL Server 2008 engine service account to either a Network Service or a Local Service Q955401 KB955401 March 19, 2009
955395 Error message that states that the Setup program cannot install Windows Installer 4.5 when you try to install SQL Server 2008 Q955395 KB955395 March 19, 2009
955394 You may have to restart the computer multiple times when you install SQL Server 2008 Q955394 KB955394 March 19, 2009
955393 The upgrade to SQL Server 2008 may not be successful Q955393 KB955393 March 19, 2009
955391 The SQL Server 2000 default instance overwrites the SQL Server 2008 installation when you install SQL Server 2008 and SQL Server 2000 by using the default instance name Q955391 KB955391 March 19, 2009
955389 How SQL Server 2008 updates what feature usage data to collect Q955389 KB955389 March 19, 2009
954515 The information pane on the Disk Space Requirements page reports an insufficient space error when you install SQL Server 2008 Q954515 KB954515 March 19, 2009
969200 How to return uniqueidentifier initialized with NEWSEQUENTIALID() function to the .Net client Q969200 KB969200 March 18, 2009
969159 SQL Server 2005 and SQL Server 2008 Websync Internet timeouts may not show any symptoms in Replication Monitor Q969159 KB969159 March 17, 2009
967614 FIX: You may receive incorrect data when you run a query in which SQL Server uses an indexed view in the execution plan in SQL Server 2008 Q967614 KB967614 March 17, 2009
963036 Cumulative update package 4 for SQL Server 2008 Q963036 KB963036 March 17, 2009
968795 SQL Server merge replication to SSCE fails with error: HTTP header information is either corrupted or missing in the transport message Q968795 KB968795 March 9, 2009
955795 You cannot run SQL Server 2005 custom report items after you upgrade to SQL Server 2008 Reporting Services Q955795 KB955795 March 9, 2009

SQL Server 2008 articles, fixes and updates - March 2009