November 21, 2008 at 10:40 am
Hi.
My name is Fabian.
I have an SQL Server 2000 SP4 running on a Windows 2000 SP4.
In another Computer i have a WSUS running under a Windows 2003 SP2.
All was working perfectly fine.
Today in the SQL Server 2000 SP4 PC there was a a Windows Update waiting for Instalattion:
Security Update for SQL SERVER 2000 Service Pack 4 (KB948110)
I installed it and gives me a fail. All the other Updates that where waiting were installed without problems.
i reset the Computer and now SQL Server 2000 SP4 cant start.
The Event Viewer Error and the Error that SQL Server 2000 Gives me:
http://img230.imageshack.us/my.php?image=eventviewersqlsq6.jpg
The WindowsUpdate.log in win directory: (the "Secutiry Updaye for SQL Server 2000 Service Pack 4 (KB948110)" part)
••••••••••••••••••••••••••••••••••••••••••••••••••••••••••
2008-11-2113:20:54:625 960428AU#############
2008-11-2113:20:54:625 960428AU## START ## AU: Install updates
2008-11-2113:20:54:625 960428AU#########
2008-11-2113:20:54:625 960428AU # Initiating manual install
2008-11-2113:20:54:625 960428AU # Approved updates = 3
2008-11-2113:20:54:635 960428AU<<## SUBMITTED ## AU: Install updates / installing updates [CallId = {35090F79-6FA7-4FC5-9FE9-5E31F3DBA5ED}]
2008-11-2113:20:54:645 9605f0Agent*************
2008-11-2113:20:54:645 9605f0Agent** START ** Agent: Installing updates [CallerId = AutomaticUpdates]
2008-11-2113:20:54:645 9605f0Agent*********
2008-11-2113:20:54:645 9605f0Agent * Updates to install = 3
2008-11-2113:20:54:815 9605f0Agent * Title = Security Update for Microsoft XML Core Services 6.0 Service Pack 2 (KB954459)
2008-11-2113:20:54:815 9605f0Agent * UpdateId = {DBD5738F-4495-4C9C-9428-C6CFC5F1A831}.103
2008-11-2113:20:54:815 9605f0Agent * Bundles 1 updates:
2008-11-2113:20:54:815 9605f0Agent * {A119A1B7-E8C1-4EA2-BF76-0CC3C976F97E}.103
2008-11-2113:20:54:815 9605f0Agent * Title = Microsoft .NET Framework 2.0: x86 (KB829019)
2008-11-2113:20:54:815 9605f0Agent * UpdateId = {46A0B6F7-B283-45F8-9CCB-C8E3B4EC332C}.100
2008-11-2113:20:54:815 9605f0Agent * Bundles 1 updates:
2008-11-2113:20:54:815 9605f0Agent * {35A466A4-B96E-49EA-B873-4BEF68B9C2D6}.100
2008-11-2113:20:54:815 9605f0Agent * Title = Security Update for SQL Server 2000 Service Pack 4 (KB948110)
2008-11-2113:20:54:815 9605f0Agent * UpdateId = {AA7434FF-7DC8-4953-8E20-C67090A0BF6E}.103
2008-11-2113:20:54:815 9605f0Agent * Bundles 1 updates:
2008-11-2113:20:54:815 9605f0Agent * {0A9D7652-18B0-4ACB-9243-CF74E2DB5F72}.103
2008-11-2113:20:55:696 9605f0AgentWARNING: LoadLibrary failed for srclient.dll with hr:8007007e
2008-11-2113:20:55:706 9605f0HandlerAttempting to create remote handler process as DIGICARD\FOlender in session 1
2008-11-2113:20:56:117 9605f0DnldMgrPreparing update for install, updateId = {A119A1B7-E8C1-4EA2-BF76-0CC3C976F97E}.103.
2008-11-2113:20:56:237 996548Misc=========== Logging initialized (build: 7.2.6001.784, tz: -0200) ===========
2008-11-2113:20:56:237 996548Misc = Process: C:\WINNT\system32\wuauclt.exe
2008-11-2113:20:56:237 996548Misc = Module: C:\WINNT\system32\wuaueng.dll
2008-11-2113:20:56:237 996548Handler:::::::::::::
2008-11-2113:20:56:237 996548Handler:: START :: Handler: Command Line Install
2008-11-2113:20:56:237 996548Handler:::::::::
2008-11-2113:20:56:237 996548Handler : Updates to install = 1
2008-11-2113:21:07:374 996548Handler : Command line install completed. Return code = 0x00000000, Result = Succeeded, Reboot required = false
2008-11-2113:21:07:374 996548Handler:::::::::
2008-11-2113:21:07:374 996548Handler:: END :: Handler: Command Line Install
2008-11-2113:21:07:374 996548Handler:::::::::::::
••••••••••••••••••••••••••••••••••••••••••••••••••••••••••
I have the Backup off all the databases that where running on it, but i prefer not to reinstall all SQL Server. ¿Is there a solution to these problem?
Bye!
PD: Sorry for my poor English, im from Argentina!
November 21, 2008 at 10:45 am
The security update requires it to be installed with the 'sa' account for it to be successful. Once that is done, reboot the system and go to services and check if MSSQLSERVICE is running or not..ALSO MAKE SURE YOU HAVE RIGHTS TO START SQL SERVER
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 21, 2008 at 10:47 am
What are you seeing in the application log? Right click on my computer (on the server), manage, application log.... There should be some errors associated with the SQL Server process starting up.
If there is not anything clear that you can search out I would burn a call to MS. I know the cost is there to consider but, when you consider the downtime associated with trying to work through a bad install, the call will definitely be cheaper.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 21, 2008 at 10:51 am
The call to MICROSOFT is FREE OF COST...under MS policy, SUPPORT for SECURITY UPDATES is at NO COST...make sure you let them know this, also make sure you installed it the right way as is said in the article ...Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 21, 2008 at 10:53 am
Yeah, I was thinking that since it was an install process that was failing but didn't want to get hopes up if it wasn't going to come to pass that way.
Thanks for the correction!
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
November 21, 2008 at 10:53 am
Helps posting links..:hehe:
http://support.microsoft.com/KB/948110
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
November 21, 2008 at 10:58 am
Guess what my server admin tried installing it on our production env and the updates failed. When he brought it to my knowledge I researched on it to find out it would fail if not done under 'sa' account. It will take a month or two for us to find another maintenance window as it is a 24X7 and I don't have 2-3 hours to spend with Microsoft on it...all they say is, do this do that....I say is why make it trivial to begin with and then have us call you and spend so much time just because some installs fail......
Fabian, I think MS will fix it for you buddy..not to worry, as long as you have backups..but I hope this downtime doesn't make your manager furious..
Thanks!!
The_SQL_DBA
MCTS
"Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply
