April 11, 2010 at 7:49 am
Hello,
I tried to install sql service pack 3 for sql server 2005 enterprise version.
Installation failed with the following error:
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 3282
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB955706_sqlrun_sql.msp.log
Error Number : 29537
Error Description : MSP Error: 29537 SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]INSERT failed because the following SET options have incorrect settings: 'ARITHABORT'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or query notifications and/or xml data type methods.. To continue, correct the problem, and then run SQL Server Setup again.
When sql server was rebooted, I see the version is changed now to Microsoft SQL Server 2005 - 9.00.4035.00 (Intel X86) Nov 24 2008 13:01:59 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
For now I have brought the sql server online as the maintenance window is over. However, i am trying to understand what this means and how is this going to affect the stability of sql server.
Also, which component do I need to rinstall service pack?
Any help or insight will be greatly appreciated.
Thanks a lot,
Nikki:unsure:
April 12, 2010 at 3:20 am
Nikki-395727 (4/11/2010)
Also, which component do I need to rinstall service pack?
See this log file on the server:
C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt
April 12, 2010 at 5:43 am
From the error message I'd say either the server or one/some of the databases have SET ARITHABORT OFF in their properties. Check BOL for the behaviours ARITHABORT affects. You need to find out where and why that property has been set that way and find a different way of getting the desired behaviour. Then you can SET ARITHABORT ON and try rerunning the service pack.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply