Re: SQL Server 2005 Express Adv. Edition Installation error 2259:Database table(s) update failed

Hi Athena,

Try the following steps:

1.) Make sure that the following services are running. Any services required by any SANs you may have or services required by network adapters also need to be left online. All other services should be stopped.

Alerter
Cluster Service
Computer Browser
Com+ Application Service
Cryptographic Services
DHCP Client
Distributed File System
Distributed Link Tracking Client
Distributed Link Tracking Server
DNS Client
Event Log
IPSEC Policy Agent
License Logging Service
Logical Disk Manager
Messenger
Net Log on
Network Connectors
NTLM Security Support Provider
Plug and Play
Process Control
Remote Procedure Call (RPC) Locator
Remote Procedure Call (RPC) Service
Remote Registry Service
Removable Storage
Security Accounts Manager
Server
Spooler
Task Scheduler
TCP/IP NetBIOS Helper
Telephony
Time Service
Windows Management Instrumentation Driver Extensions
Windows Time Service
Workstation


2.) Make sure that you do not have compressed drives that need to be accessed during installation. If you do have compressed drives, decompress them.

3.) Make sure that all drives in question have enough space for the installation.

4.) Run msconfig. One of the tabs is called Services. Here you will get a list of available services together with the name of their "manufacturer". Disable all those not belonging to Microsoft. Note you need to disable them not stop them.

5.) Restart the machine.

6.) Make sure that the account you are using has admin privileges on the local machine and that it has FULL CONTOL privileges on the DATA folder of SQL Server (normally C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data).

7.) Run wmimgmt.msc. Right-click on "WMI Control (Local)" and select Properties from the context menu. Click on the Security tab. Expand Root. Expand Microsoft. Expand SqlServer. Click on ServerEvents then click on the Security button. Make sure that the account you are using to run setup has full control on this namespace and all child namespaces.

8.) Set the following registry key value 0:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\Setup\Resume

9.) Temporarily turn off any Anti-Virus software.

10.) Clean out the %TEMP% folder.

11.) Re-run setup


Hope this helps.


Jonathan




Athena wrote:
Hello,

When I try to install SQL Server 2005 Express Adv. Edition I am getting an error, code 2259: database table(s) update failed. How can I fix this error? I need step by step instructions please. Thank you.

Athena

Product Language:English
Version:SQL Server 2005 SP2 - Express Edition w/ Advanced Services
Category:Setup
Operating System:Windows Vista
Operating System Language:US English
Steps to Reproduce:Either Windows install or manual install creates the error.
Error log files are attached.
Actual Results:Error 2259
Platform :32
File Attachments:


Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Professional (Build 6000)
Time : Wed Sep 05 16:34:44 2007


Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Professional (Build 6000)
Time : Wed Sep 05 16:34:44 2007

SERVER : Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.
Machine : SERVER
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_SERVER_SQLSupport_1.log
--------------------------------------------------------------------------------

Machine : SERVER
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_SERVER_SQLNCLI_1.log
--------------------------------------------------------------------------------

Machine : SERVER
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.3042.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_SERVER_SqlWriter_1.log
--------------------------------------------------------------------------------

Machine : SERVER
Product : SQL Server Database Services
Error : The installer has encountered an unexpected error. The error code is 2259. Database: Table(s) Update failed
--------------------------------------------------------------------------------

Machine : SERVER
Product : Microsoft SQL Server 2005
Product Version : 9.2.3042.00
Install : Failed
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_SERVER_SQL.log
Last Action : ValidateUpgrade
Error String : The installer has encountered an unexpected error. The error code is 2259. Database: Table(s) Update failed
Error Number : 2259
--------------------------------------------------------------------------------


.