installed cumulative hotfix build 3186 server service not starting

Question

installed cumulative hotfix build 3186 server service not starting

sunshine-587009

SSCrazy Eights

Points: 8981
More actions
April 1, 2008 at 1:56 pm

#120901

Anyone else experiencing this? It fails to install on the database services.
¤ §unshine ¤

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Tommy Bollhofer SSChampion Points: 14940 More actions · Answer 1

I'm running 3186 and ran into this on one of our instances. I just applied the hotfix on the database engine during the second pass without error.. Does it give you a specific error message? Have you looked through the log files (i.e. C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\). Good luck 🙂

Tommy

Follow @sqlscribe

sunshine-587009 SSCrazy Eights Points: 8981 More actions · Answer 2

I tried re-running and it did not work. I found this in the hotfix log

04/01/2008 14:46:37.109 Warning: Product HotFixNS is missing LCID value

Also this in the app events

Event Type:Error

Event Source:MSSQL$servername

Event Category:(2)

Event ID:5173

Date:4/1/2008

Time:3:33:35 PM

User:N/A

Computer:servername

Description:

One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupted and should be restored from a backup.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Data:

0000: 35 14 00 00 10 00 00 00 5.......

0008: 17 00 00 00 43 00 48 00 ....C.H.

0010: 49 00 2d 00 53 00 51 00 I.-.S.Q.

0018: 4c 00 2d 00 30 00 36 00 L.-.0.6.

0020: 5c 00 41 00 46 00 53 00 \.A.F.S.

0028: 44 00 45 00 56 00 45 00 D.E.V.E.

0030: 44 00 57 00 30 00 31 00 D.W.0.1.

0038: 00 00 07 00 00 00 6d 00 ......m.

0040: 61 00 73 00 74 00 65 00 a.s.t.e.

0048: 72 00 00 00 r...

and

Event Type:Error

Event Source:MsiInstaller

Event Category:None

Event ID:1023

Date:4/1/2008

Time:2:44:54 PM

User:me

Computer:servername

Description:

Product: Microsoft SQL Server 2005 - Update 'Hotfix 3186 for SQL Server Database Services 2005 ENU (KB936252)' could not be installed. Error code 1603. Additional information is available in the log file C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB936252_sqlrun_sql.msp.log.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Data:

0000: 7b 45 42 37 36 42 32 31 {EB76B21

0008: 38 2d 38 46 43 35 2d 34 8-8FC5-4

0010: 31 44 46 2d 39 46 31 46 1DF-9F1F

0018: 2d 37 46 46 33 45 30 34 -7FF3E04

0020: 34 38 33 38 33 7d 20 7b 48383} {

0028: 36 43 38 33 39 33 38 35 6C839385

0030: 2d 45 35 36 41 2d 34 32 -E56A-42

0038: 35 37 2d 42 38 37 42 2d 57-B87B-

0040: 31 42 43 44 43 39 39 34 1BCDC994

0048: 33 38 43 39 7d 20 31 36 38C9} 16

0050: 30 33 03

Let me see what I find in these.

¤ §unshine ¤

sunshine-587009 SSCrazy Eights Points: 8981 More actions · Answer 3

That KB article it mentions says something about the file name SQLServer2005-KB936252-x86-ENU.exe. But no fix.

¤ §unshine ¤

Tommy Bollhofer SSChampion Points: 14940 More actions · Answer 4

Are your system databases in the default location prior to installation? Will it start in single user mode (http://msdn2.microsoft.com/en-us/library/ms180965.aspx)?

Tommy

Follow @sqlscribe