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


Top 5 Contributors of the Month
david stephan
Asad Ali
Fauzul Azmi
Post New Web Links

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

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :
 

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


View Complete Post


More Related Resource Links

SQL Server 2005 Management Studio error and cannot re-install client tools too system.serviceModel e

  

Hi,

got some regular OS patches today and voila:

sql management studio error: appidpackage failed to open connection dialog

Have tried to re-install client tools:

F:\>start /wait \setup.exe /qb REINSTALL=SQL_Tools90 REINSTALLMODE=OMUS

Success
The following error occurred:
Configuration system failed to initialize

Error result: -2068774911
Result facility code: 1201
Result error code: 1

Please review the summary.txt log for further details
The following error occurred:
Configuration system failed to initialize

Error result: -2068774911
Result facility code: 1201
Result error code: 1

Please review the summary.txt log for further details

Unhandled Exception: Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastru
ctureException: Configuration system failed to initialize ---> System.Configurat
ion.ConfigurationErrorsException: Configuration system failed to initialize --->
 System.Configuration.ConfigurationErrorsException: Unrecognized configuration s
ection system.serviceModel. (C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Confi
g\machine.config line 146)
   at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignor
eLocal)
   at System.Configuration.BaseC

SQL Server 2005 Management Studio error and cannot re-install client tools too system.serviceModel e

  

Hi,

got some regular OS patches today and voila:

sql management studio error: appidpackage failed to open connection dialog

Have tried to re-install client tools:

F:\>start /wait \setup.exe /qb REINSTALL=SQL_Tools90 REINSTALLMODE=OMUS

Success
The following error occurred:
Configuration system failed to initialize

Error result: -2068774911
Result facility code: 1201
Result error code: 1

Please review the summary.txt log for further details
The following error occurred:
Configuration system failed to initialize

Error result: -2068774911
Result facility code: 1201
Result error code: 1

Please review the summary.txt log for further details

Unhandled Exception: Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastru
ctureException: Configuration system failed to initialize ---> System.Configurat
ion.ConfigurationErrorsException: Configuration system failed to initialize --->
 System.Configuration.ConfigurationErrorsException: Unrecognized configuration s
ection system.serviceModel. (C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Confi
g\machine.config line 146)
   at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignor
eLocal)
   at System.Configuration.BaseC

SQL server 2005 SP2 KB921896 fails to install

  
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

Unable to install SQL Server 2005 Express: The error is (-2146885628) Cannot find object or propert

  
I am installing 2 instances of SQL Server 2005 Express for 2 different accounting packages on Windows XP SP3.  I have the first installed, after much use of the forums.  The version of setup.exe was 2005.90.2047.0. I am not able to install the second, for Microsoft Office Accounting 2009, setup.exe version 2005.90.3042.0.  The error I am getting in Summary.txt is: Error String    : 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." The error is  (-2146885628) Cannot find object or property. Error Number    : 29503 The errorlog file for MSSQL.2 has a lengthier description: 2009-09-05 23:00:32.13 Server      Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)     Feb  9 2007 22:47:07     Copyright (c) 1988-2005 Microsoft Corporation     Express Edition on Windows NT 5.1 (Build 2600: Service Pack 3) 2009-09-05 23:00:32.31 Server      (c) 2005 Microsoft Corporation. 2009-09-05 23:00:32.31 Server      All rights reserved. 2009-09-05 23:00:32.32 Server      Server process ID is 5516. 2009-09-05 23:00:32.32 Server      Authentication mode is MIXED. 2009-09-05 23:00:32.35 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\ERRORLOG'. 2009-09-05 23:00:32.38 Server      Regi

SQL Server install error 1310 system error 80

  
When installing SQl server 2008 I am getting a 1310 error, system error 80 on the Microsft.analyisservices.adomdclient.dll.The install is being done by the adminstrator but is being carried out from a remote terminal.Multiple other installs have completed fine on the server and admin rights appear fine.see log  entries below for detail. Is this because we are installing remotely? or is there another reason that anyone can suggestThanks. AssemblyCopy(SourceName=tgns2gue.dll|Microsoft.AnalysisServices.AdomdClient.dll,SourceCabKey=AS_Microsoft_AnalysisServices_AdomdClient_dll_32,DestName=Microsoft.AnalysisServices.AdomdClient.dll,Attributes=0,FileSize=549912,PerTick=32768,,VerifyMedia=1,,,,,ComponentId={14537205-2B1A-4615-B8F3-7247E33A7485},IsManifest=1,,,AssemblyMode=0,)MSI (s) (C8:14) [16:07:09:728]: Source for file 'tgns2gue.dll' is uncompressed, at 'E:\x64\setup\sql_common_core_msi\Windows\Gac_32\'.MSI (s) (C8:14) [16:07:09:728]: Note: 1: 1305 2: E:\x64\setup\sql_common_core_msi\Windows\Gac_32\tgns2gue.dll 3: 1 MSI (s) (C8:14) [16:07:09:728]: Note: 1: 1310 2: 80 3: Microsoft.AnalysisServices.AdomdClient.dll MSI (s) (C8:4C) [16:07:48:759]: I/O on thread 6100 could not be cancelled. Error: 1168MSI (s) (C8:4C) [16:07:48:759]: I/O on thread 5992 could not be cancelled. Error: 1168MSI (s) (C8:4C) [16:07:48:759]: I/O on thread 3996 could not be cancelled. Error: 1168MSI (s) (C8:

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

/qn ADDLOCAL=all REBOOT=ReallySuppress DISABLENETWORKPROTOCOLS=2 SQLAUTOSTART=1 SECURITYMODE=SQL SAPWD=123

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 will NOT install! 1603 error!

  

Greetings! I have no idea where to post this, but I thought maybe someone here could aid me! I'm nearly ready to throw my computer out the window.

I am attempting to get Bioware's Dragon Age"Origins toolset to function, but it requires SQL Server 2005. But every time I attempt to install it, I get a critical error.

I am running Framework .NET 2.0, Service Pack 3, and an OS of Windows XP. I have tried installing them all and reinstalling, to no avail. I also checked to make sure I have permissions on the folders [ to the best of my limited knowledge ]. 

Here is the log.

Microsoft SQL Server 2005 Setup beginning at Sun Oct 03 03:43:09 2010
Process ID      : 2004
C:\Program Files\Dragon Age\tools\sqlexpr\setup.exe Version: 2005.90.4035.0
Running: LoadResourcesAction at: 2010/9/3 3:43:8
Complete: LoadResourcesAction at: 2010/9/3 3:43:8, returned true
Running: ParseBootstrapOptionsAction at: 2010/9/3 3:43:8
Loaded DLL:C:\Program Files\Dragon Age\tools\sqlexpr\xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2010/9/3 3:43:9, returned true
Running: ValidateWinNTAction at: 2010/9/3 3:43:9
Complete: ValidateWinNTAction at: 2010/9/3 3:43:9, returned true
Running: ValidateMinOSAction at: 2010/9/3 3:43:9
Complete: ValidateMinOSAction at: 2010/9/3

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:

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&

Microsoft SQL Server 2005 Express Edition Service Pack 3 (KB955706) windows update install error 0xD

  
I have tried several times to use Windows Update to install the SQL Server 2005 Express Edition Service Pack 3 (KB955706) but it keeps failing.  When I check the install history all I get is error code 0xD59

I have Windows XP SP2 on a Core 2 Duo Dell Vostro 1500

Can I install SQL Server 2005 Express edition on Linux system?

  

Hi,

  I have a requirement to use free source database so i have choosen Sql server 2005 express edition which is available for free.Now can I install this on a linux platform and use it as a server.Does it require any tools or drivers to install on linux and to work as if on windows pc?

Can anyone please help me on this? Any help is much appreciated.

Thanks in advance

Sri.


SQL Server Express 2005 won't install because of fatal error from msxml6, what do I do?

  
Hey have a computer that I'm trying to install SQL Express 2005.  This system is running Windows XP SP3 and I need SQL Express 2005 inorder to run some proprietary software, it won't read SQL Express 2008 so I have to have the 2005 version.  Every time I try and install SQL Express 2005 it fails on msxml6.  Basically it says that msxml6 is already installed.  When I go and try to uninstall msxml6 I get the message "fatal error installing msxml6".  How can I get past this because I'm not trying to install it I'm attempting to uninstall it?

how to install 32 bit sql server 2005 express in 64 bit windows 7 operating system?

  
how to install 32 bit sql server 2005 express in 64 bit windows 7 operating system?

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 Transactional Replication Fails to Publish Stored Procedure Containing an Index Crea

  

I've experienced a bizarre problem with a SQL Server 2005 Transactional Publication. The issue is this: If the publication contains an article that is a stored procedure that contains a create index statement, then there is an error thrown when attempting to replicate the schema of the stored procedure to a subscriber.

The behavior is very odd, because even if the create index statement is commented out, it still gives the exception, and it will only work if it is removed altogether.

Here is the exact error that's being returned:

Command attempted: GRANT EXECUTE ON [dbo].[usp_Test] TO [CompanyDatabase_access]

(Transaction sequence number: 0x00000170000008B9000500000000, Command ID: 5)

Error messages: Cannot find the object 'usp_Test', because it does not exist or you do not have permission. (Source: MSSQLServer, Error number: 15151) Get help: http://help/15151 Cannot find the object 'usp_Test', because it does not exist or you do not have permission. (Source: MSSQLServer, Error number: 15151) Get help: http://help/15151

The error is accurate, because when I check on the subscriber, the stored procedure wasn't created as expected... but that was the purpose of the publication...

how i can install sql server in my system

  

which edition of sql server  are best for me  Developer edition or express editon for development purpose.

i try to install last time sql server in my system but not successful so what i do for get the sql server in my system.


Categories: 
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