Article ID: 905786 - View products that this article applies to.
Beta InformationThis article discusses a Beta release of a Microsoft product. The information in this article is provided as-is and is subject to change without notice.
No formal product support is available from Microsoft for this Beta product. For information about how to obtain support for a Beta release, see the documentation that is included with the Beta product files, or check the Web location where you downloaded the release.
This article describes changes to the Readme.txt file for Microsoft SQL Server 2005 September Community Technology Preview (CTP).
Information that has changedThe following information has changed or has become available since the ReadmeSQL2005.htm file for SQL Server 2005 September Community Technology Preview was published.
Note Unless otherwise stated, these items will be resolved in the final release of SQL Server 2005.
The default language for the SQL Server System Administrator loginWhen you install or upgrade to Microsoft SQL Server 2005, the default language for the SQL Server System Administration ("sa") login account is set to the language that was selected during Setup or during the upgrade. To change the default language for the SQL Server System Administrator login account, you must run the sp_defaultlanguage stored procedure and then run the dbcc freesystemcache command.
Unlike the earlier versions of Microsoft SQL Server, you cannot change the default language for the SQL Server System Administrator login account by using the sp_configure stored procedure. In SQL Server 2005, the sp_configure stored procedure changes only the default language on the server.
To change the default language for the SQL Server System Administrator login account in Microsoft SQL Server 2005, follow these steps:
The "Start services at the end of setup" check box does not have any effectThe Start services at the end of setup check box does not have any effect when you upgrade to SQL Server 2005 September CTP from SQL Server 2005 June CTP by using the Build Cleanup Wizard. When you click to clear the Start services at the end of setup check box, the SQL Server service is started. This check box is located on the Service Account page in the Wizard.
The "Error and Usage Reporting" configuration tool does not open Help documentationA localized version of the Error and Usage Reporting configuration tool does not open its Help documentation when you press the HELP key on the keyboard. To view this Help documentation, follow these steps:
Setup does not remove SQL Server 2005 September CTP Books OnlineSetup does not remove SQL Server 2005 CTP Books Online when you try to remove Books Online by using the Add or Remove Programs item in Control Panel.
To reinstall Books Online after Setup does not remove it, follow these steps:
Pause or stop database mirroring before you upgrade either partnerDatabase mirroring does not work if one of the partners is running SQL Server 2005 September CTP and if the other partner is running SQL Server 2005 June CTP. Before you upgrade either partner, follow these steps:
Remove the SQL Server 2005 components for versions that are earlier than SQL Server 2005 June CTPRemove the SQL Server 2005 components for versions that are earlier than SQL Server 2005 June CTP in the following order:
SQL Server backward compatibility components are not installed in certain scenariosSQL Server backward compatibility components are not installed in certain scenarios. Therefore, some features may not work correctly, and errors may occur. To resolve this issue, manually install the SQL Server Backward Compatible .msi file.
To do this on x86-based or 64-bit native SQL Server 2005-based servers, follow these steps:
PivotTable Services is not included in SQL Server 2005 September CTPPivotTable Services is not included in SQL Server 2005 September CTP but can be downloaded. The following files are available for download from the Microsoft Download Center:
Download the PivotTable Services for x86 Package (ptslite.exe) - 4940 KB package now.
Collapse this imageExpand this image
For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:
119591Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.
(https://support.microsoft.com/kb/119591/ )How to obtain Microsoft support files from online services
Information that is not correctly documented in the ReadmeSQL2005.htm fileThe following items were not correctly documented in the Readme.txt file for SQL Server 2005 September Community Technology Preview.
Visual Studio 2005, .NET Framework SDK, and the MSDN LibrarySQL Server September 2005 CTP is designed to integrate with Visual Studio 2005 Release Candidate (RC) and the version of the .NET Framework 2.0 SDK that is associated with Visual Studio 2005 RC. Section 4.3 of the September CTP readme file states that developers can get separate copies of the MSDN Library and the .NET Framework SDK. One of the September CTP Setup dialog boxes includes a link to a location for the .NET Framework SDK. For Visual Studio 2005 RC, these documentation sets are not available as separate downloads. Developers can get them only with a copy of Visual Studio 2005 RC.
Section 5.7 of the readme states that you can order Visual Studio 2005 RC DVDs through a fulfillment Web site. This is not correct.
MSDN Universal, MSDN Enterprise, and MSDN Professional subscribers can download Visual Studio 2005 RC from the following Microsoft Web site:
Section 3.5.17, "Restrictions for Service Accounts on a Failover Cluster" no longer appliesSection 3.5.17, "Restrictions for Service Accounts on a Failover Cluster" no longer applies to SQL Server 2005 September CTP.
Section 5.1.3, "Documentation on Casting XML Data to a String or Binary Type," has incorrect informationIn SQL Server 2005 Books Online, the "Serialization of XML Data" topic incorrectly states that the syntax CONVERT (stringtype, xmlvalue, 1) can be used to avoid the entitization of white-space characters. This is incorrect; this functionality is not implemented in this CTP release. The functionality is available in the Sept CTP.
The title bar for SQL Server Books Online incorrectly refers to SQL Server 2005 June CTPThe title bar for SQL Server Books Online incorrectly refers to SQL Server 2005 June CTP. Books Online has been updated for SQL Server 2005 September CTP.
Error and Usage Reporting dialog box may report directory error on 64-bit computersIf you are operating in a 64-bit environment, you may receive an error message if you try to change settings on the Advanced Properties tab of the Error and Usage Reporting dialog box. This behavior may occur when the Error Report Location field for Other (x86) components is blank. We recommend that you provide a valid directory on the local drive. This may be the same as the directory specified for the other component.
Article ID: 905786 - Last Review: May 11, 2007 - Revision: 6.7