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

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

SQL server 2005 SP2 KB921896 fails to install

Posted By:      Posted Date: September 02, 2010    Points: 0   Category :Sql Server
Machine Specs: Windows XP SP3 Over 104GB HDD space available   When running the SP2 update I get "ngen.exe - Application Error" "The application failed to initialize properly (oxc0000005) Click ok.... Hit Ok it pops up a second time, hit Ok a small unexpected error message box pops up with no error code   I have tried a complete reinstall of SQL server 2005, I've tried stopping and restarting SQL services.   Reviewing the HotFix log... It fails when it attempts to pause the ngen queue 09/02/2010 09:00:29.984 Registry: Read registry key value "CustomerFeedBack", DWORD value = 0 09/02/2010 09:00:30.609 Registry: Set registry key value "EnableErrorReporting", DWORD value = 0 09/02/2010 09:00:30.609 Registry: Set registry key value "EnableErrorReporting", DWORD value = 0 09/02/2010 09:00:30.609 Registry: Set registry key value "EnableErrorReporting", DWORD value = 0 09/02/2010 09:00:30.609 Registry: Set registry key value "CustomerFeedBack", DWORD value = 0 09/02/2010 09:00:30.609 Registry: Set registry key value "CustomerFeedBack", DWORD value = 0 09/02/2010 09:00:30.609 Registry: Set registry key value "CustomerFeedBack", DWORD value = 0 09/02/2010 09:00:30.640 Locked file: Checking for locked files 09/02/2010 09:00:30.906 Locked file: C:\WINDOWS\system32\sqlncli.dll (MSSQLSERVER

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

Silent install of SQL Server 2005 fails when SQL Server 2008 is installed


We currently install SQL Server 2005 Express silently during our installation, using the following switches


We also attach a 2005-created database immediately after using the following command line (^ is a path concat operator in Installshield):

sqlcmd.exe -S .\\SQLEXPRESS -E -i \"" + svConfigPath ^ "SetupUapDB.sql\" -vmdfpath=\"" + svConfigPath ^ "UapCfg.mdf\" -vldfpath=\"" + svConfigPath ^ "UapCfg_log.ldf\" -o \"" + svConfigPath ^ "SqlCreateDB.txt\" -e

Note that we do not specify an instance name.  We ran into a situation where someone had installed SQL Server 2008 on a box using a default instance name and our install then failed.  I am considering 2 possible fixes, and have questions for both.

Fix #1: Specify an instance name.  Ideally this would install SQL Server 2005 Express side by side with SQL Server 2008, create a unique instance name and we'd be good to go right?  If yes, what is the accepted convention for specifying instance names?

Fix #2: Not sure if this is possible.  Can we detect if SQL Server 2008 is on the box, and if yes, apply our 2005 database to it instead?  In this case (tell me

sql server 2005 install on SBS2003 fails due to registry key permissions

I am posting this to hopefully help someone else that encounters the same issue in the future...

Server:  SBS 2003 Premium, with exchange and with all service packs/patches applied.
Server-name: NEWSERVER
Server migrated from: OLDSERVER
Important notes:
This server was migrated from another SBS 2003 on different HW following the instructions provided by microsoft.
The oldserver had exchange and sql 2005 installed on it.
The new server has Office Accounting 2005 installed, but I don't think that matters...

I am trying to install SQL 2005 from the SBS2003-R2 DVD onto the new server, and get the following error:

TITLE: Microsoft SQL Server 2005 Setup

SQL Server Setup failed to modify security permissions on registry key SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2\MSSQLServer\SuperSocketNetLib for user Administrator. To proceed, verify that the account and domain running SQL Server Setup exist, that the account running SQL Server Setup has administrator privileges, and that the registry key  exists on the destination drive.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&

SQL Server 2005 fails to start after install on Server 2008 R2 SP1 64-bit


New install of Server 2008 R2 64-bit upgraded to SP1.

I have SQL Server 2005, no matter how I install it, it fails to start the main SQL Service giving me the error:

"The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually.""

It then rolls back just that portion of the install and completes the install. I thought the following article might be the ticket, but no matter which SQL Server 2005 SP I try this with or which method they describe (reducing processor count, etc), I get the same error: http://support.microsoft.com/kb/954835/en-us

Is it SP1 on Server 2008 R2 that is the problem? I have found various articles online speaking of pretty much the same issue, but these are posted before SP1 and people seem to be able to get things working.

Any thoughts?

Sql server 2005 fails to install on vista home basic

I am trying to install outlook 2007 with business contact manager, but the business contact manager fails to install because sql server 2005 fails to install. Message is setup failed to install the required component of microsoft sql server cna any one help

SQL Server 2005 SP4 Install Fails - error log references replication system tables


The OS is Windows Server 2003 R2 SP2 (32 bit).  Trying to install SQL Server 2005 SP4 (current version is 9.00.4035).  All SQL products update without error, except for the Database engine.  The error listed in the summary.txt file in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix is:

Product                   : Database Services (MSSQLSERVER)
Product Version (Previous): 5000
Product Version (Final)   :
Status                    : Failure
Log File                  : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB2463332_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]Update or insert of view or function 'dbo.syspublications' failed because it contains a derived or constant field.. To continue, correct the problem, and then run SQL Serv

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?

SQL Server 2008 R2 fails after Windows XP Pro SP3 install

We recently encountered an issue with SQL Server 2008 R2 failing to run after the upgrade from Windows XP Pro SP2 to SP3. This was tested and reproduced (with varying results) on more than one computer. Steps to reproduce this. On a Windows XP Pro machine with Service Pack 2 installed, install SQL Server 2008 R2. Next upgrade Windows to Service Pack 3. Now upon opening SSMS or trying to start the SQL server service you receive the following message: "This application has failed to start because the application configuration is incorrect. Reinstalling the application may fix this problem". In some instances reinstalling/repairing SQL Server 2008 R2 does fix the issue.  In other cases the installer crashes and you need to use msizap to clean it up before you can reinstall.  In other cases you do not receive any errors at all. After testing in multiple virtual machines it looks like the cleaner the Windows install the more likely you are to run into this issue.  On machines with most or all windows updates (prior to SP3) installed you do not necessarily even get the failure.  On machines with just Windows XP Pro SP2 installed with no additional updates you get the failure every time. Obviously the SQL Server 2008 R2 prerequisites are installed in all cases in order to be able to install SQL server to begin with. Any help with this would be appre

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.  

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?

PS2007/MSSQL2008: Cannot install Microsoft SQL Server 2005 Management Objects Collection (sqlserver2

Hi folks, about 1,5 months ago I have set up a - 1 server - development environment for PS2007. I had installed all components on one Windows 2008 box. Everything worked fine, now I receive an error. •MOSS 2007 •SQL 2008 SP1 •MOPS 2007 SP2 I have done the additional installation for the cube building part according to this page http://technet.microsoft.com/en-us/library/dd285466(office.12).aspx Microsoft SQL Server Native Client (sqlncli.msi) Microsoft SQL Server 2005 Management Objects Collection (sqlserver2005_xmo.msi) Microsoft SQL Server 2005 Backwards Compatibility Components (SQLServer2005_BC.msi) Everything worked fine. Cubes were able to be built.. everything was good. In order to have Reports built I added SSRS 2008 Reporting Services Addin for MOSS (rsSharePoint_x64) Business Intelligence Development Studio (=Visual Studio for MSSQL) No CUs have been added to this box. NOW, Cube creation fails with the error: ULS LOG: [CBS] ProjectServerOlapCubeGenerator status: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server <IPADDRESS>. Error: ActiveX component can't create object 08efbc13-299a-4abe-9021-c46887ca6915 Eventlog says: SSP Name: SharedServices1 PSError: CBSASConnectionFailure (17003) Cube build failed to connect to the Analysis Services server. Verify the data source connection i

Unable to install SQL Server 2005 SP2 - Unable to install Windows Installer MSI File

I have been trying to figure out how to fix this problem for the past couple of days and I was unable to find an answer to my specific problem in the forum.My OS is Windows XP Professional SP3 on MacBook Pro, using Parallels Desktop 4.0. Every single time Windows update tries to install SQL Server 2005 SP2, it fails. I am using Business Contact Manager with Outlook 2007 and SQL Server stops randomly and I am forced to restart the software. I am not sure if it is relevant to this specific problem but I thought I would make a note of this.I have downloaded SP2 and tried to install it locally but that did not work. Here is the error message I get:OS Version: Microsoft Windows XP Professional Service Pack 3 (Build 2600)Package Language: 1033 (ENU)Package Platform: x86Package SP Level: 2Package Version: 3042Command-line parameters specified:     /quiet     /allinstancesCluster Installation: No**********************************************************************************Prerequisites Check & StatusSQLSupport: Passed**********************************************************************************Products Detected                         Language  Level  Patch Level       Platform  EditionExpress Database Services (MSSMLBIZ)      ENU       SP1    2005.090.2047.00  x86       EXPRESS**********************************************************************************Products Disqua

Uable to successfully install SQL Server 2005 (Express Edition) Service Pack 3 (KB955706)

After repeated attempts, I am unable to install the MSSQL Server 2005 (Express Edition) Service Pack 3 (KB955706).  From Live Update, the installation initializes but then reports that it was unable to install.  The first couple of times I received Error Code 0x65B, but that doesn't come up any longer. I have ACT! Database version 2007 (9.0) and it is unable to access the database to open it because it uses the MSSQL??  Also, there used to be an MSSQL icon below in my system tray, but that no longer appears.  When I reboot it will be on briefly, but then goes away.. MS Customer Support has attempted to help (Case ID SRX1135612820) but now tell me that this is beyond their expertise.  They had me try to reload MMSQL 2005 but no change. Please help! Thanks!!  Terry
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