Question

SQLServer 2008 SP1 install failed

Asked by: ksfok

I have a SQLServer 2008  dev version running on a dev box. If SQLServer 2008 SP1 install failed, what can I do about it? Thanks.

This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.

Subscribe now for full access to Experts Exchange and get

Instant Access to this Solution

  • Plus...
  • 30 Day FREE access, no risk, no obligation
  • Collaborate with the world's top tech experts
  • Unlimited access to our exclusive solution database
  • Never be left without tech help again

Subscribe Now

Asked On
2009-10-26 at 18:01:54ID24845792
Topic

SQL Server 2008

Participating Experts
3
Points
500
Comments
16

Trusted by hundreds of thousands everyday for fast, accurate and reliable tech support.

  • "The time we save is the biggest benefit of Experts Exchange to Warner Bros. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange." Mike Kapnisakis, Warner Bros.
  • "Our team likes having a resource that is more secure than just using Google and most experts using this service really know their stuff. It's nice to look here first versus using Google." Dayna Sellner, Lockheed Martin
  • "Anytime that I've been stumped with a problem, 9 out of 10 times Experts Exchange has either the accepted solution or an open discussion of the potential solution to the problem." Kenny Red, eBay Inc.

See what Experts Exchange can do for you.

Got a question?

We've got the answer.

Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.

Screenshot of Experts Exchange Knowledgebase

Need individual assistance?

Our experts are ready to help.

If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.

Screenshot of Experts Exchange Knowledgebase

Want to learn from the best?

Read articles from industry experts.

Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.

Screenshot of an Article

Working on a long term project?

Store your work and research.

Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.

Screenshot of Experts Exchange Knowledgebase

Access the answers to your technology questions today.

Subscribe Now

30-day free trial. Register in 60 seconds.

What Makes Experts Exchange Unique?

Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Trusted by the world's most respected brands.

image of each brand's logo

Faithfully serving IT professionals since 1996.

Experts Exchange Logo

Try it out and discover for yourself.

Subscribe Now

30-day free trial. Register in 60 seconds.

Related Solutions

  1. dblink to Microsoft SQLServer
    I am needing to reference tables in a Microsoft SQLServer database. I have tried reading the documentation of setting up dblinks. It claims Oracle should be able to read any external file or database. So I have tried configuring my access using the following login and code. ...
  2. DBase to SqlServer
    How would one go about doing this? I have a dbase export file with an .dbf extension but I'm not sure how to import it into sqlServer. Any ideas?
  3. Odd Access 2003 / SQLServer 2000 / ODBC Problem
    I'm not sure whether this should go here or in the SQLServer area, but since we're using both, I'll post it here. We're using Access 2003 to link to SQLServer 2000 tables via an ODBC connection. When adding the connection, all tests complete successfully. We can then link ...
  4. Switch to SQLServer from Access
    I have written a program that has been used for some time by about 14 users. These users are scattered over a large geographic area in Western Australia and will not have Internet access. The current program uses MS Access as its database. As the size of the database is incre...

Free Tech Articles

  1. WARNING: 5 Reasons why you should NEVER fix a computer for free.
    It is in our nature to love the puzzle. We are obsessed. The lot of us. We love puzzles. We love the challenge. We thrive on finding the answer. We hate disarray. It bothers us deep in our soul. W...
  2. SCCM OSD Basic troubleshooting
    SCCM 2007 OSD is a fantastic way to deploy operating systems, however, like most things SCCM issues can sometimes be difficult to resolve due to the sheer volume of logs to sift through and the dispe...
  3. Migrate Small Business Server 2003 to Exchange 2010 and Windows 2008 R2
    This guide is intended to provide step by step instructions on how to migrate from Small Business Server 2003 to Windows 2008 R2 with Exchange 2010. For this migration to work you will need the fo...
  4. Create a Win7 Gadget
    This article shows you how to create a simple "Gadget" -- a sort of mini-application supported by Windows 7 and Vista. Gadgets can be dropped anywhere on the desktop to provide instant information, ...
  5. Outlook continually prompting for username and password
    There have been a lot of questions recently regarding Outlook prompting for a username and password whilst using Exchange 2007. There are a few reasons why this would happen and I will try to cover t...
  6. Backup Exchange 2010 Information Store using Windows Backup
    There seems to be quite a lot of confusion around the ability to backup Exchange 2010 using the built in Windows Backup feature. This stems from the omission of this feature prior to Exchange 2007 s...

Cloud Class Webinars

  1. Avoiding Bugs in Microsoft Access
    Alison Balter takes and in-depth look at avoiding bugs in Access. In this webinar you will learn about using the immediate window to debug your applications, invoking the debugger, using breakpoints to troubleshoot, stepping through code, setting the next statement to execute, ...
  2. Top 10 Best New Features in Visio 2010
    Scott Helmers gives live demonstrations of the top 10 new features in Visio 2010. This webinar will teach you how to create compelling diagrams by adding shapes to the page with a single click, linking the shapes in a diagram to data in Excel (or SQL Server, or SharePoint), ...
  3. IT Consultant Business Secrets Revealed
    Michael Munger, Experts Exchange tech pro and IT consultant, pulls back the curtain on his very successful businesses and answers question on every IT consultant and business owner should know about. He shares secrets on what he did to solve the 5 most common problems in IT, ...
  4. Disaster Recovery and Business Continuity
    Quest CTO, Mike Billon, gives an overview of the steps involved in building a dunamic disaster recovery plan. Through case studies and an examination of software/hardware tooles for monitoring and testing, you'll gain a better understandin of where you are, where you want ...
  5. Organize Your Visio Diagrams with Containers and Lists
    Scott Helmers uses cross functional flowcharts, wireframe diagrams, data graphic legends and seating charts to teach you: how to ustilize all three new structured diagram components in Visio 2010, the best practices for organizeing shapes in previous version of Visio, how to organize ...
  6. How to Us Objects, Properties, Events and Methods in Microsoft Access
    Alison Dalter gives an in-depbth look at objects, properties, events and methods in Microsoft Access. In this webinar you will learn about using the object browser, referring to objects, working with properties and methods, working with object variables, understanding the ...

Join the Community

Give a Little. Get a Lot.

Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.

Join the Community

Answers

 

by: rrjegan17Posted on 2009-10-26 at 18:13:46ID: 25668500

Kindly post the exact error message so that we can help you out..

 

by: HainKurtPosted on 2009-10-26 at 18:31:11ID: 25668546

probably it is best to get backup of existing databases, uninstall completely, reboot, install sp1  and restore databases...

 

by: geek_vjPosted on 2009-10-26 at 19:56:22ID: 25668826

Hi, for most of the errors, we have workarounds like modifying the registry etc. So, depending on the error message, we can look at various options of fixing the errors. Rolling back the service pack is the last option.

Kindly post the exact error message to fix it better and faster

 

by: ksfokPosted on 2009-10-26 at 23:24:51ID: 25669499

Sorry I didn't see any error details except "install failed"

 

by: geek_vjPosted on 2009-10-26 at 23:34:32ID: 25669536

Pls check in the event viewer during that specific time frame of installation.

 

by: ksfokPosted on 2009-10-26 at 23:44:01ID: 25669573

Where can I find the  event viewer?

 

by: geek_vjPosted on 2009-10-26 at 23:49:10ID: 25669585

Please click Start button and type eventvwr

It opens the event viewer. In that please check the buttons - Application and System to get the exact error during the specific time frame

 

by: ksfokPosted on 2009-10-30 at 15:58:26ID: 25707305

I  am afraid my event viewer got messed up, Please see attached file and advise.

 

by: ksfokPosted on 2009-10-30 at 16:00:48ID: 25707314

Can I still use SQL2008 without SP1? What am I going to miss?

 

by: geek_vjPosted on 2009-10-31 at 06:27:15ID: 25709677

From the event vwr image, it looks like your windows time is incorrect. Please try resetting your system time to the current time to get the exact error messages in event viewer.

>>Can I still use SQL2008 without SP1? What am I going to miss?

SP1 resolved some bugs which exist in SQL Server 2008 version and you can view the release notes of SQL Server 2008 SP1 to know the exact issues which were resolved in SP1.

If you are planning to install SQL 2008 initially, then at a later point of time if you find any issues/bugs, you can install SP1.

Coming to your initial question-
>>If SQLServer 2008 SP1 install failed, what can I do about it?

Before installation, you need to make sure to take backups of all databases and take a system state backup to get the system intact in case of any issues.

Also, depending on the errors, we have many proven solutions to correct the same.

Hope this helps!

 

by: rrjegan17Posted on 2009-10-31 at 06:40:56ID: 25709715

>> I  am afraid my event viewer got messed up, Please see attached file and advise.

It didn't list any error message and contains only informational messages.
Kindly post the error message which you obtained while you did the SP1 installation so that it contain some more information to help you fix it out.

 

by: ksfokPosted on 2009-10-31 at 22:08:34ID: 25712689


Overall summary:
Final result:                  The patch installer has failed to update the shared features. To determine the reason for failure, review the log files.
Exit code (Decimal):           -2068709375
Exit facility code:            1202
Exit error code:               1
Exit message:                   A failure was detected for a previous installation, patch, or repair for instance 'MSSQLSERVER' during configuration for features [SQL_Replication_Core_Inst,SQL_Engine_Core_Inst,MPT_AGENT_CORE_CNI,SQL_FullText_Adv,]. In order to apply this patch package (KB968369), you must resolve any issues with the previous operation that failed. View the summary.txt log to determine why the previous operation failed.
Start time:                    2009-10-27 16:07:15
End time:                      2009-10-27 16:18:37
Requested action:              Patch
Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20091027_160705\Detail.txt
Exception help link:           http%3a%2f%2fgo.microsoft.com%2ffwlink%3fLinkId%3d20476%26ProdName%3dMicrosoft%2bSQL%2bServer%26EvtSrc%3dsetup.rll%26EvtID%3d50000%26ProdVer%3d10.0.2531.0%26EvtType%3d0x7281D40D%400xC2B0B50B%401202%401
Machine Properties:
Machine name:                  KAM
Machine processor count:       2
OS version:                    Windows XP
OS service pack:               Service Pack 3
OS region:                     United States
OS language:                   English (United States)
OS architecture:               x86
Process architecture:          32 Bit
OS clustered:                  No
Product features discovered:
Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered
  Sql Server 2005      SQLEXPRESS           MSSQL.2                        Database Engine Services                 1033                 Express Edition      9.3.4053        No        
Sql Server 2005      SQLEXPRESS           MSSQL.2                        SharedTools                              1033                 Express Edition      9.3.4053        No        
Sql Server 2005                                                          Tools                                    1033                 Developer Edition    9.3.4035        No        
Sql Server 2005                                                          ToolsClient                              1033                 Developer Edition    9.3.4035        No        
Sql Server 2005                                                          ToolsClient\Connectivity                 1033                 Developer Edition    9.3.4035        No        
Sql Server 2005                                                          ToolsDocument                            1033                 Developer Edition    9.3.4035        No        
Sql Server 2005                                                          ToolsDocument\BOL                        1033                 Developer Edition    9.3.4035        No        
Sql Server 2005                                                          NS                                       1033                 Developer Edition    9.3.4035        No        
Sql Server 2008      MSSQLSERVER          MSSQL10.MSSQLSERVER            Database Engine Services                 1033                 Developer Edition    10.0.1600.22    No        
Sql Server 2008      MSSQLSERVER          MSSQL10.MSSQLSERVER            SQL Server Replication                   1033                 Developer Edition    10.0.1600.22    No        
Sql Server 2008      MSSQLSERVER          MSSQL10.MSSQLSERVER            Full-Text Search                         1033                 Developer Edition    10.0.1600.22    No        
Sql Server 2008      MSSQLSERVER          MSAS10.MSSQLSERVER             Analysis Services                        1033                 Developer Edition    10.0.1600.22    No        
Sql Server 2008      MSSQLSERVER          MSRS10.MSSQLSERVER             Reporting Services                       1033                 Developer Edition    10.0.1600.22    No        
Sql Server 2008      MSSQL2008            MSSQL10.MSSQL2008              Database Engine Services                 1033                 Developer Edition    10.0.1600.22    No        
Sql Server 2008      MSSQL2008            MSSQL10.MSSQL2008              SQL Server Replication                   1033                 Developer Edition    10.0.1600.22    No        
Sql Server 2008      MSSQL2008            MSSQL10.MSSQL2008              Full-Text Search                         1033                 Developer Edition    10.0.1600.22    No        
Sql Server 2008      MSSQL2008            MSAS10.MSSQL2008               Analysis Services                        1033                 Developer Edition    10.0.1600.22    No        
Sql Server 2008      MSSQL2008            MSRS10.MSSQL2008               Reporting Services                       1033                 Developer Edition    10.0.1600.22    No        
Sql Server 2008                                                          Management Tools - Basic                 1033                 Developer Edition    10.0.1600.22    No        
Sql Server 2008                                                          Management Tools - Complete              1033                 Developer Edition    10.0.1600.22    No        
Sql Server 2008                                                          Client Tools Connectivity                1033                 Developer Edition    10.0.1600.22    No        
Sql Server 2008                                                          Client Tools Backwards Compatibility     1033                 Developer Edition    10.0.1600.22    No        
Sql Server 2008                                                          Client Tools SDK                         1033                 Developer Edition    10.0.1600.22    No        
Sql Server 2008                                                          Integration Services                     1033                 Developer Edition    10.0.1600.22    No        
Package properties:
Description:                   SQL Server Database Services 2008
SQLProductFamilyCode:          {628F8F38-600E-493D-9946-F4178F20A8A9}
ProductName:                   SQL2008
Type:                          RTM
Version:                       10
SPLevel:                       1
KBArticle:                     KB968369
KBArticleHyperlink:            http://support.microsoft.com/?kbid=968369
 PatchType:                     SP
AssociateHotfixBuild:          0
Platform:                      x86
PatchLevel:                    10.1.2531.0
ProductVersion:                10.0.1600.22
GDRReservedRange:              10.0.1000.0:10.0.1099.0;10.0.3000.0:10.0.3099.0
PackageName:                   SQLServer2008-KB968369-x86.exe
Installation location:         c:\6db4dfab40dddc01358aa5f763f0\x86\setup\
User Input Settings:
ACTION:                        Patch
ALLINSTANCES:                  False
CLUSTERPASSIVE:                False
CONFIGURATIONFILE:            
  HELP:                          False
INDICATEPROGRESS:              False
INSTANCENAME:                  <empty>
QUIET:                         False
QUIETSIMPLE:                   False
X86:                           False
Rules with failures:
Global rules:
There are no scenario-specific rules.
Rules report file:               The rule result report file is not available.
Exception summary:
The following is an exception stack listing the exceptions in outermost to innermost order
Inner exceptions are being indented
Exception type: Microsoft.SqlServer.Chainer.Infrastructure.ChainerInvalidOperationException
  Message:
       
        A failure was detected for a previous installation, patch, or repair for instance 'MSSQLSERVER' during configuration for features [SQL_Replication_Core_Inst,SQL_Engine_Core_Inst,MPT_AGENT_CORE_CNI,SQL_FullText_Adv,]. In order to apply this patch package (KB968369), you must resolve any issues with the previous operation that failed. View the summary.txt log to determine why the previous operation failed.
  Data:
      ChainerInvalidOperationExceptionData = ProductInstallProperty
    DisableWatson = true
  Stack:
        at Microsoft.SqlServer.Configuration.MsiExtension.ProductInstallProperty.CheckFailedConfiguration()
      at Microsoft.SqlServer.Configuration.MsiExtension.ProductInstallProperty.CollectProductData()
      at Microsoft.SqlServer.Configuration.FeatureTreeConfigurationBase.LoadFeatureTreeDefinitionAllInstances()
      at Microsoft.SqlServer.Configuration.FeatureTreeConfigurationBase.LoadFeatureTreeDefinition()
      at Microsoft.SqlServer.Configuration.FeatureTreeConfigurationBase..ctor(ServiceContainer context)
      at Microsoft.SqlServer.Configuration.PatchFeatureTree..ctor(ServiceContainer context)
      at Microsoft.SqlServer.Configuration.PatchFeatureTree.InitializePatchFeatureTree(ServiceContainer context)
      at Microsoft.SqlServer.Configuration.SetupExtension.InitializeUIDataAction.ExecuteAction(String actionId)
      at Microsoft.SqlServer.Chainer.Infrastructure.Action.Execute(String actionId, TextWriter errorStream)
      at Microsoft.SqlServer.Setup.Chainer.Workflow.ActionInvocation.InvokeAction(WorkflowObject metabase, TextWriter statusStream)
      at Microsoft.SqlServer.Setup.Chainer.Workflow.PendingActions.InvokeActions(WorkflowObject metaDb, TextWriter loggingStream)

 

by: geek_vjPosted on 2009-11-01 at 01:42:59ID: 25713039

>> A failure was detected for a previous installation, patch, or repair for instance 'MSSQLSERVER' during configuration for features [SQL_Replication_Core_Inst,SQL_Engine_Core_Inst,MPT_AGENT_CORE_CNI,SQL_FullText_Adv,]. In order to apply this patch package (KB968369), you must resolve any issues with the previous operation that failed. View the summary.txt log to determine why the previous operation failed.

Kindly post the summary.txt content to understand the details about why the previous operation got failed.
Until this issue is resolved, we cannot proceed with the fresh installation.

 

by: rrjegan17Posted on 2009-11-01 at 20:46:01ID: 25717112

geek_vj was correct..
Your earlier installation had some issues and it would be present in the summary.txt

 

by: ksfokPosted on 2009-11-06 at 14:53:20ID: 25763785

I plan to use a new dev box, install VS208 and SQL2008, then go online let windows update update sp. Would that be a good solution?

 

by: rrjegan17Posted on 2009-11-06 at 18:49:14ID: 25764766

If you are planning to go for a new box, then it should go fine without any issues.
Kindly make sure your Summary.txt for the initial installation of SQL Server 2008 doesn't have any issues to install SP1 successfully.

20120131-EE-VQP-002

3 Ways to Join

30-Day Free Trial

The Experts

98% positive feedback on 31,087 answers since March 2000. angeliii is a Microsoft Most Valuable Professional for his work with MS SQL Server & Develoment.

He has also proven his knowledge of Visual Basic Programming, PHP Scripting and Oracle Databases.

The Experts

97% positive feedback on 10,752 answers since July 2000. lrmoore has more than 18 years experience in the networking industry.

The six-time Mircosoft MVPs specialties include firewalls, virtual private networking, and network management.

Testimonials

"...and excellent source for support... Kind of like having your very own IT dept." Electriciansnet

Testimonials

"I was apprehensive at signing up at first. However... it has already made my life as an IT administrator much easier." JaCrews

Testimonials

"WOW! You guys have great, active, and knowledgeable people on here." moore50

Business Clients

Business Clients

In the Press

"If you’ve got a question... Experts Exchange can supply an answer.”

In the Press

"...an invaluable aid for both IT professionals and those who require tech support."

In the Press

"where IT professionals provide quick answers on just about any topic"

Business Account Plans

Loading Advertisement...