Microsoft KB Archive/907256

From BetaArchive Wiki
Knowledge Base


Article ID: 907256

Article Last Modified on 11/20/2007



APPLIES TO

  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Workgroup Edition



Bug #: 404955 (SQLBUDT)

SYMPTOMS

You add the full-text search service to an existing instance of Microsoft SQL Server 2005 Community Technology Preview (CTP) 16 by using one of the following methods:

  • Microsoft Office Maintenance Mode
  • An upgrade installation of the full-text search service that is taken from an edition of SQL Server 2005 that is not SQL Server 2005 CTP.

When you do this, the full-text search service does not run under the domain account that is specified for SQL Server 2005 CTP.

CAUSE

This issue occurs because the full-text search service is installing under the LocalSystem account. However, SQL Server 2005 CTP is configured to use a non-LocalSystem account.

RESOLUTION

To resolve this issue, you must change the full-text search service account after you have installed the full-text search service.

To change the full-text search service account, follow these steps:

  1. On the Start menu, point to Programs, click Microsoft SQL Server 2005 CTP, click Configuration Tools, and then click SQL Server Configuration Manager.
  2. Right-click the Full Text Search service.
  3. Select Properties.
  4. Type the new account information.


STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

Steps to reproduce the behavior

  1. Set up SQL Server 2005 September CTP to use a non-LocalSystem account.
  2. Create a database.
  3. Use Add/Remove Programs to install the full-text search service.

Expected result
You expect the full-text search service to install by using the correct domain account.

Actual result
The full-text search service installs by using the incorrect domain account.

Keywords: kbtshoot kbbug kbsql2005fts kbsql2005setup KB907256