SQL Server 2005 articles, fixes and updates - October 2007

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

• 943635 You cannot rebuild system databases if you run the Setup command from a location that is not the original installation location of SQL Server 2005 Q943635 KB943635 October 31, 2007
• 940387 FIX: The direction of the string in a text box is incorrect when you open a SQL Server 2005 Reporting Services report in Internet Explorer 7 Q940387 KB940387 October 31, 2007
• 940019 Error message when you run a complex MDX query that contains the NON EMPTY clause in SQL Server 2005 Analysis Services: "The expression contains a function that cannot operate on a set with more than 4,294,967,296 tuples" Q940019 KB940019 October 31, 2007
• 938495 Slow performance when you run an MDX query that accesses the key attribute hierarchy in a parent-child dimension in SQL Server 2005 Analysis Services Q938495 KB938495 October 31, 2007
• 941742 A cube is not modified when you process the cube by using the ProcessDefault option in SQL Server 2005 Analysis Services Q941742 KB941742 October 30, 2007
• 929105 Error message when you install SQL Server 2005 Express Edition Service Pack 1 in Windows Vista: "Windows NT user or group '<COMPUTERNAME>\SQLServer2005MSSQLUser$<COMPUTERNAME>$MSSQLSERVER' not found" Q929105 KB929105 October 30, 2007
• 927165 Description of the rules for derivation of the FORMAT_STRING cell property in SQL Server 2005 Analysis Services Q927165 KB927165 October 29, 2007
• 814130 How to help secure network connectivity for SQL Server 2000 local databases Q814130 KB814130 October 29, 2007
• 306985 Error message when you connect to a cluster virtual server by using the named pipes protocol: "The machines selected for remote communication is not available at this time." Q306985 KB306985 October 29, 2007
• 942665 FIX: You cannot run some SQL Server 2005 Integration Services packages in Business Intelligence Development Studio if you also run the same packages by using the Dtexec.exe utility Q942665 KB942665 October 26, 2007
• 936892 Error message in the SQL Server Errorlog file after you upgrade SQL Server 2000 to SQL Server 2005 on a server that is running Windows Server 2003: "Unable to update password policy" Q936892 KB936892 October 26, 2007
• 841249 How to configure Windows XP Service Pack 2 (SP2) for use with SQL Server Q841249 KB841249 October 26, 2007
• 942905 FIX: Error message when you run a DML statement against a table in a SQL Server 2005 Integration Services package: "Msg 6549, Level 16, State 1, Procedure sp_FuzzyLookupTableMaintenanceInvoke, Line 0" Q942905 KB942905 October 22, 2007
• 941989 FIX: Error message when you synchronize a merge replication in a replication topology that contains two or more re-publishers in SQL Server 2005: "21997 Failed to allocate new identity range" Q941989 KB941989 October 22, 2007
• 942664 FIX: Error message when you try to build or to deploy a report server project of SQL Server 2005 Reporting Services: "This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms" Q942664 KB942664 October 19, 2007
• 942659 FIX: The query performance is slower when you run the query in SQL Server 2005 than when you run the query in SQL Server 2000 Q942659 KB942659 October 19, 2007
• 941695 FIX: After you enable the Address Windowing Extensions (AWE) feature in SQL Server 2005, access violations may occur, and SQL Server 2005 may stop responding Q941695 KB941695 October 19, 2007
• 941233 FIX: Error message when you use the SQL Server Native Client OLE DB provider to connect to an instance of SQL Server 2005: "Conversions not allowed using bcp_moretext" Q941233 KB941233 October 15, 2007
• 940870 FIX: Error message when you process the index for a partition in a cube in SQL Server 2005 Analysis Services: “Internal error: An unexpected error occurred (file 'pffilestore.cpp', line 3311, function 'PFFileStore::HandleDataPageFault')” Q940870 KB940870 October 15, 2007
• 941792 FIX: The content of a group is displayed incorrectly when you change a parameter and then you click a toggle image in SQL Server 2005 Reporting Services Q941792 KB941792 October 12, 2007
• 938786 FIX: A .NET Compact Framework 2.0-based device application that calls the SqlCeEngine.Verify method against a SQL Server 2005 Compact Edition database stops responding Q938786 KB938786 October 12, 2007
• 937792 FIX: The data mining model that you build by using the association algorithms contains only one rule in SQL Server 2005 Analysis Services Q937792 KB937792 October 12, 2007
• 942667 FIX: The Analysis Services service stops unexpectedly when you run a Multidimensional Expressions query that uses unary operators on a dimension in SQL Server 2005 Analysis Services Q942667 KB942667 October 9, 2007
• 942654 FIX: A Multidimensional Expressions query that contains a FILTER function returns an incorrect result in SQL Server 2005 Analysis Services Q942654 KB942654 October 9, 2007
• 938916 FIX: The status of the shared schedule appears as Paused after you click Resume when you use Report Manager in SQL Server 2005 Reporting Services SP2 Q938916 KB938916 October 6, 2007
• 942715 FIX: In Reporting Services together with SQL Server 2005 Service Pack 2, the "Save As Report" dialog box stops responding, or the "Open Report" dialog box stops responding in Report Builder Q942715 KB942715 October 3, 2007
• 941176 FIX: Error message when you run a query that references a column of the XML data type in SQL Server 2005: "The XML data type is damaged" Q941176 KB941176 October 3, 2007
• 941256 FIX: Error message when you run the CREATE ASSEMBLY statement to register a CLR assembly in SQL Server 2005: "An error occurred while gathering metadata from assembly '<AssemblyName>' with HRESULT 0x80131" Q941256 KB941256 October 1, 2007