Changes to the Readme.txt file for SQL Server 2005 September CTP

This article describes changes to the Readme.txt file for Microsoft SQL Server 2005 September Community Technology Preview (CTP).

Information that has changed

The 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 login

When 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:

1. Run the following command:

   exec sp_defaultlanguage 'sa'
2. Then run the following command:

   'language_name'
       go
       dbcc freesystemcache('tokenandpermuserstore')
       go

3. Start a new session to see the changes.

The "Start services at the end of setup" check box does not have any effect

The 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 documentation

A 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:

1. On the Start menu of the SQL Server 2005 program group, located and then click SQL Server 2005 Books Online.
2. Click Installing SQL Server, then click Setup User Interface Reference, and then click Error and Usage Reporting Settings.

Setup does not remove SQL Server 2005 September CTP Books Online

Setup 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:

1. Click Start, click Run, type appwiz.cpl, and then click OK.
2. Click Microsoft SQL Server 2005 CTP, and then click Change.
3. Expand the Workstation Components node, and then click to clear the Books Online check box.
4. Complete the remaining steps in the Installation Wizard.
5. In the Add or Remove Programs dialog box, click Microsoft SQL Server 2005 CTP, and then click Change.
6. Expand the Workstation Components node, and then click to select the Books Online check box.
7. Complete the remaining steps in the Installation Wizard.

Pause or stop database mirroring before you upgrade either partner

Database 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:

1. Pause or stop database mirroring for every database mirroring session.
2. Upgrade both server instances.
3. Resume database mirroring.

Remove the SQL Server 2005 components for versions that are earlier than SQL Server 2005 June CTP

Remove the SQL Server 2005 components for versions that are earlier than SQL Server 2005 June CTP in the following order:

• Microsoft SQL Server "Yukon" Beta 1
• Microsoft SQL Server 2005 Beta 2
• Microsoft SQL Server 2005 Express Edition Beta 2
• Microsoft SQL Server 2005 Tools Beta 2
• Microsoft SQL Server 2005 Tools Express Edition Beta 2
• Microsoft SQL Server 2005 Data Transformation Services Beta 2
• Microsoft SQL Server 2005 Analysis Services Beta 2
• Microsoft SQL Server 2005 Notification Services Beta 2
• Microsoft SQL Server 2005 Reporting Services Beta 2
• Microsoft SQL Server Setup Support Files
• Microsoft SQL Native Client

SQL Server backward compatibility components are not installed in certain scenarios

SQL 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:

1. Locate and then click the SQLServer2005_BC.msi file. By default, this file is located in the \Servers\Setup folder or in the \Tools\Setup folder.
2. Right-click SQLServer2005_BC.msi, and then click Install.

To do this on Microsoft Windows-on-Windows 64-bit SQL Server 2005-based servers, follow these steps:

1. Locate and then click the SqlServer2005_BC_x64.msi file. By default, this file is located in the \Servers\Setup folder or in the \Tools\Setup folder.
2. Right-click SqlServer2005_BC_x64.msi, and then click Install.

PivotTable Services is not included in SQL Server 2005 September CTP

PivotTable 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.

For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base: Microsoft 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.

Information that is not correctly documented in the ReadmeSQL2005.htm file

The 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 Library

SQL 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 applies

Section 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 information

In 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 CTP

The 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 computers

If 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.