.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Cannot install SP4 for SQL 2005 for one instance

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :


I have 7 instances in my SQL Server 2005 Express edition.
Just one instance I cannot update with SP4.

Below the error from the summary.txt file.


Product                   : Express Database Services (KLUWER2005)
Product Version (Previous): 4035
Product Version (Final)   :
Status                    : Failure
Log File                  :
SQL Express Features      : SQL_Data_Files,SQL_Engine,SQL_SharedTools
Error Number              : 11016
Error Description         : SQL Server not responsive prior to running Repl post script procedure

I have tried many things but no results yet.

* SP4 from Windows update --> Failed.
* Clear C:\Windows\SoftwareDistribution and try Windows Update again --> Failed.
* Set Resume key in the register have the value at 0 (HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<instancename>\Setup\Resume) --> Fai

View Complete Post

More Related Resource Links

SQL Server 2005 Standard edition install fails; An instance with the same name.../


Good Morning

I am trying to install SQL Server 2005 onto Windows Server 2003 Small Business Edition. Previously SQL Server 2000 from the SBE disk was installed, automatic updates are enabled.

I have selected the default instance and everything I try results in the error:

An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.

Log file says;

Machine         : ISAINTERNET
Product         : Microsoft SQL Server 2005
Product Version : 9.00.1399.06
Install         : Failed
Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0002_ISAINTERNET_SQL.log
Last Action     : DetectInstanceClash
Error String    : An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.
Error Number    : 28086

Ian Smith

How to Install MSDTC on a multi Instance SQL Server Fail OverCluster (SQL 2005 & Windows 2003 R2 x64


I am installing 2 SQL instances on a fail over cluster.

Currently I have my Quorum and DTC resources on the default Group and the 2 sql instances on 2 other groups.

In this way would the DTC resource  be available for both the SQL groups or is there any other way i should go about doing this ?

install another instance of sql 2005 express


how do i create another instance (for WSUS) using sql 2005 express onto my server that already has an existing instance setup and running (for Acronis backups)


How do I install SQL Server 2005 JDBC driver

I'm an new bie to "SQL Server 2005 JDBC Driver". I have downloaded SQL Server 2005 JDBC driver and extracted it to C:\Program Files\Microsoft SQL Server 2005 JDBC Driver\. Is the installation complete now? How can I use this driver from my application? If there is a step-by-step instruction on whether we need to run some scripts in SQL Server or to configure some system variables, it would be great. Thanks in advance for your time in this.Cheeeeerrzzzz! S@kthi http://blogs.msdn.com/sqlsakthi | http://twitter.com/PowerSakthi Mark as Answer if it helps. This posting is provided "AS IS" with no warranties and confers no rights.

SQL-DMO Install on SQL Server 2005 Express Client

I am installing a Client side SQL 2005 Express that needs SQL-DMO. The Client computer does not have SQL Server 2005 Express installed. I have installed all the MDAC and .Net 2.0. The command line I'm using to try and install the SQL-DMO and XML modules is: SQLEXPR_ADV ADDLOCAL=Tools_Legacy,SQLXML I get a message something like 'SQL Server 2005 Version does not support this install option.' How do I get SQL-DMO installed on a SQL Server 2005 Express Client computer?

Instance and Default connection properties on SQL Server 2005

We had a sql server fail and I have been having troubles.  I compared the connection properties on the server properties and noticed that multiple default settings are no longer set.  So I'm wondering if during the failure these could have some gotten flipped.  DB's that worked all of a sudden don't work and we had to migrate to a different instance.  I have never changed any of the setings below and wonder what impact they would have if I changed them back to the default of an installed instance? ansi warning is checked ansi padding is checked ANSI NULLS is checked arithmetic abort is checked quoted identified is checked No Count is checked concat null yields null is checked Could anyone tell me how clearing these checked options will impact my db?   -- Paul Bergson MVP - Directory Services MCITP: Enterprise Administrator MCTS, MCT, MCSE, MCSA, Security+, BS CSci 2008, Vista, 2003, 2000 (Early Achiever), NT4 http://www.pbbergs.com    Twitter @pbbergs Please no e-mails, any questions should be posted in the NewsGroup This posting is provided "AS IS" with no warranties, and confers no rights.

Unable to install SP3 on SQL 2005 due to Database Services language being blank

Hi all,   I have an issue that requires me to upgrade to a later SP (currently on RTM), but when I try to install SP3 Database Services cannot be ticked. Upon inspection I see that its reporting "This update requires language ENU.  The language for this product instance MSSQLSERVER is . Download the upadte for langage .", when I check teh Language field to the right it is blank, other parts however are fine and can be upgraded. Can you advise please as I don't know how to manually set the language (which is reported inside SQL itself as English (United Kingdom)) and I cannot un/reinstall. Thanks, John

SQl server 2005 install failed on Windows XP pro sp3 due to msxml 6 sp2

Summary log: Microsoft SQL Server 2005 9.00.4035.00 ============================== OS Version      : Microsoft Windows XP Professional Service Pack 3 (Build 2600) Time            : Tue Aug 24 20:16:01 2010   Machine         : D3F2LN81 Product         : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.4035.00 Install         : Successful Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0005_D3F2LN81_SQLSupport_1.log -------------------------------------------------------------------------------- Machine         : D3F2LN81 Product         : Microsoft SQL Server Native Client Product Version : 9.00.4035.00 Install         : Successful Log File        : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0005_D3F2LN81_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine         : D3F2LN81 Product&nb

Microsoft SQL Server 2005 Express Edition Service Pack 3 (KB955706) - will not download.install on W

I have tried and tried unsuccessfully to get this download to install properly. I get no error message at all but it quite clearly is not working properly. This has all ready taken me hours and hours of my time with no success (after following the fixes mentioned on this site). I look forward to suggestions at to how to proceed that may actually work. Many thanks cdbc81

SQL Server 2005: Install reporting services - which version?

Hello - I installed SQL Server 2005 as part of an SBS2008 install. I need to install reporting services, but now I'm having trouble identifying which version (X64 or X86) I'm running. Is there an easy way of figuring out which installation disk I need to insert for SQL Server 2005? Thanks, Nick.

Which SQL Server 2005 Express Edition Service Pack to Install?

I have Windows 2008 Small Business Server Standard Edition.  When I scan for updates I get two different SQL service packs showing up, with the same KB955706 number.  I'm wondering which I should install, or if both, what order to install them in?  The first one is labeled: Microsoft SQL Server 2005 Express Edition Service Pack 3 The second one is labeled: Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack 3 For applications, I have Blackbaud The Financial Edge v7.78 (accounting package for clubs) installed that uses SQL Server 2005 Express Edition for its database engine.  The new upgrade for this software requires SP3 which is why I need to know which service pack to install.  Also, please let me know if there are any tricks to getting the service packs installed on 2008 SBS Standard Edition.  I know sometimes registry settings need to be changed for SQL service packs to be installed properly. Thank you for your help.  

Can't install SQL 2005 SP3

Hi,   i am not able to Update the SQl Server Std. SP2 to Sp3 Can you pls. help me ?   Best Regards Property(S): SqlPackageId = 1 Property(S): ProductName = Microsoft SQL Server 2005 Property(S): ProductNameSetup = Setup für Microsoft SQL Server 2005 Property(S): RemoveFeatureList = SQL_Engine,SQL_Data_Files,SQL_Replication,SQL_FullText,SQL_SharedTools,SQL_BC_DEP Property(S): QuotedSqlLogonUser = BBT-SRV01\Administrator Property(S): RSGUIDVALUE = {c0d294a7-3bd9-40ad-b45a-2d25bbb97a6d} Property(S): ProgramFilesFolder.D20239D7_E87C_40C9_9837_E70B8D4882C2 = C:\Programme\ Property(S): ModuleID_SQLBASE = D20239D7_E87C_40C9_9837_E70B8D4882C2 Property(S): InstanceName.D20239D7_E87C_40C9_9837_E70B8D4882C2 = TRUMPF Property(S): ProgramMenuFolder.ConfigurationTools1031 = C:\Dokumente und Einstellungen\All Users\Startmenü\Programme\ Property(S): DW20PATH_CPUTYPEX86 = X86 Property(S): WindowsFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E = C:\WINDOWS\ Property(S): SystemFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E = C:\WINDOWS\system32\ Property(S): WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E = C:\WINDOWS\ Property(S): SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E = C:\WINDOWS\system32\ Property(S): WindowsFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E = C:\WINDOWS\ Property(S): SystemFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E = C:\WINDOWS\system32\ Property(S): Win

Problem to install MS SQL 2005 on Window 7 Operating System

Hi, I recently have problem to install MS SQL 2005 on Window 7 Operating System. Setup showing an error for compitability issues. When click on to button to check for solution online, after a while it pop up that No solutions found for Microsoft SQL Server 2005. Any one know solution for this? Is is possible to install Microsoft SQL Server 2008 on Window 7 and migrate data from Microsoft SQL Server 2005 to 2008? Please advice. Appreciate your help. Thanks.

named instance sql server 2008 install on cluster

I have a production two-node cluster with sql server 2008 sp1 cu7 running over windows server 2008 sp2. If I were to install a new named instance on this live environment, would it impair the default sql server instance functionality? I'm not referring to processor/io while the install is in progress. My question specifically is would the install process by its nature bring down the default instance. I'm pretty sure it won't, but don't see any documentation that would confirm this. thanks.

Cannot Install SQL Server 2005 Express due to MSXML 6 sp2

Got an XP Sp3 box - uninstalled SQL server 2008 Express r2.  Now I'm trying to install SQL server 2005 and am getting the ol' MSXML 6 SP2 error which is keeping SQL Server 2005 from installing.  Last time this happend there was the handy Installer Clean Up Utility but now you go to http://support.microsoft.com/kb/290301 and it's gone.  So what is the solution now?  Everything I've googled says to use the installer cleaner but it doesn't exist now so what now?

2005 Install Error - SQLBROWSERACCOUNT

Hello experts - I am trying an ATTENDED install of SQL Server 2005 Enterprise edition, on Windows 2003 sp2, nd receive the following: TITLE: Microsoft SQL Server 2005 Setup ------------------------------   SQL Server Setup has determined that the following account properties are not specified:  'SQLBROWSERACCOUNT' . The properties specify the startup account for the services that are installed. To proceed, refer to the template.ini and set the properties to valid account names. If you are specifying a windows user account, you must also specify the password for the account.   For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.4035.00&EvtSrc=setup.rll&EvtID=28006&EvtType=sqlca%5csqlguica.cpp%40SetUnattendedSvcAccountProp%40SetUnattendedSvcAccountProp%40x6d66   ------------------------------ BUTTONS:   OK ------------------------------ If you click ok, it terminates the install.  My understanding is termplate.ini is for silent, unattended installs.  What's going oin? Dianne

Specify Instance Port Number on Command Line Install

Is there a way to specify which port we want our named SQL Express instance to run on during a command line install with no interaction from the user?  If not, is there a way we can change the dynamic port selected after the install without any user interaction?Nick's Programming Tips
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend