SQL Server 2005 Unattended Install Bootstrapper Fails On French XP System
Jan 10, 2008
The scenario I have is as follows:
Our product ships with a bootstrapper that installs SQL Server 2005 silently for our clients - basically it's a pre-req which we load for them if it's not already installed.
The bootstrapper supplies the service account identity parameters for the SQL Server install command line in English. It supplies the local system account (NT AUTHORITYSYSTEM).
The problem occurs when we tried to install the product onto a French version of XP. We got the error message "SQL Server setup could not validate the service accounts. Either the service accounts have not been provided for all the services being installed, or the specified username or password is incorrect. For each service, specify a valid username, password, and domain, or specify a built-in system account."
Having read the page http://msdn2.microsoft.com/en-us/library/ms143504.aspx#Localized_service_names we have discovered that the system account identity has a different name for French (AUTORITE NTSYSTEM) along with some other languages ... but we're not sure how to resolve the problem.
Can anyone out there tell me whether we ...
1) Can get the machine being installed on to tell us the local system account identity so we can substitute it into our command line in the bootstrapper?
2) Have to write a different bootstrapper for each language that names the local system account identity differently?
3) Have overlooked some other solution?
Also, does anyone know how many languages and which they are that give the local system account a name that's different to "NT AUTHORITYSYSTEM"??
Thanks,
Sara
<EDIT>
Sorry, omitted a vital bit of information. The bootstrapper is written in C++.
We know the .NET code to retrieve an NT account given a well known SID. Can we do the same in C++ somehow??
</EDIT>
I have a script that performs an unattended installation of SQL Server and works fine.
However, if I un-install via the control panel all the files are removed apart from the databases that are created by me when SQl server was installed. This is good and ensures data is not deleted.
The files left over are in the following directory: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData and contains: MyDatabase.mdf MyDatabase_log.LDF
The problem I have is after performing the re-installtion of SQL server (unattended) I am unable to create a new database with the same name (in this instance called "myDatabase").
The actual files are physically there so this is the reason a new database with the same name cannot be creacted.
Again this is ok again because it ensures I cannot overwrite existing data. However I am unable to re-attach this database to SQl server so I can continue to use it!
The question is:
How do I make this database usable again after an unattended install? Is there a parameter I am missing?
Below are the commands I use that are passed to the installation of SQL Server as command line parameters:
The last four commands I have played around with but for some reason SQL Server service will not start when these are used! (This is a different issue though!).
When doing a unattended install of Microsoft SQL Server Express, I have a problem specifing the service to installed to be run under the as local system account.
I'm using: SQLACCOUNT & SQLPASSWORD parameters but it just won't work.
As default SQL Server is installed using the NETWORK SERVICE account, this causes the database to be read-only. What I want is to specifiy in the script that the service should run under the LOCAL SYSTEM account instead. This must also be OS-language independent.
I've tried:
SQLACCOUNT=NT AUTHORITYSYSTEM SQLACCOUNT=NT AUTHORITYLOCAL SYSTEM SQLACCOUNT=NT AUTHORITYLOCAL SERVICE SQLACCOUNT=SYSTEM
SQLACCOUNT=BUILT-INSYSTEM
etc.
and even some different SID as:
S-1-5-18 S-1-5-19
All with no password with the SQLPASSWORD parameter:
SQLPASSWORD=
I still getting the same error while validating the service account.
Is there someone else who knows what I'm doing wrong?
Hello All, I am trying the following script to upgrade SQL Server 2005 SP1 to SP2. I have an Active Passive cluster configuration. I have default instances of SQL Server. I am using the following script.
The sql server install fails to run. When I used the above command with just
start /wait c:1sqlserversp2SQLSERVER2005SP2-KB921896-x86-ENU.exe /quiet still the summary.txt file came with authentication success and that is all. I changed the above script and did
start /wait c:1sqlserversp2SQLSERVER2005SP2-KB921896-x86-ENU.exe /instancename=instancename of the cluster
This worked, however the install patched the passive node (DB engine, all the cluster unaware components) but failed to patch the DB engine on the Active node. I had to run the SQL Server sp2 install manually but still it did not patch the DB engine on the primary node
1. Can someone please help me with this issue as I want the unattended install to work. so it installs both active and passive node. I will post the final output and also the ADS script to do this as a bonus if this works.
Here is the summary.txt file.
********************************************************************************** Processes Locking Files Process Name Feature Type User Name PID msftesql Database Services Service 5152 MSSQLSERVER Database Services Service 4412 ResrcMon.exe Database Services Application SHOMSCSService 4688 ********************************************************************************** Product Installation Status Product : Setup Support Files Product Version (Previous): 3042 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- Product : Database Services (MSSQLSERVER) Product Version (Previous): 2153 Product Version (Final) : Status : Failure Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log Error Number : 29506 Error Description : MSP Error: 29506 SQL Server Setup failed to modify security permissions on file D:Microsoft SQL ServerMSSQL.1MSSQLData for user sqlservice. 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 exists on the destination drive. ---------------------------------------------------------------------------------- Product : Integration Services Product Version (Previous): 3042 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- Product : SQL Server Native Client Product Version (Previous): 3042 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- Product : Client Components Product Version (Previous): 3042 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- Product : MSXML 6.0 Parser Product Version (Previous): 1129 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- Product : SQLXML4 Product Version (Previous): 3042 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- Product : Backward Compatibility Product Version (Previous): 2004 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- Product : Microsoft SQL Server VSS Writer Product Version (Previous): 3042 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- ********************************************************************************** Summary One or more products failed to install, see above for details Exit Code Returned: 29506
I am having an issue with SQL 2005 unattended install, I cannot see where in the template.ini file you can specify the TCP port number for SQL 2005 to listen to I want to change it to a specific port number, I know you can do this in an unattended install on SQL 2000.
Also in an unattended install of SQL 2000 and 2005 is there any way you can specify the database and transaction logs location for new databases to be installed on another drive then the system databases. I know you can change this later in SQL server properties but I wanted this to be done during the install or is there a T-SQL script which can do this after?
This one has me scratching my head. We can install SQL Express on many different English OS without problems, but when we try it on a French OS it doesn't work. We have several French systems and SQL Express does not install on any of them. Even just running the SQLEXPR32.EXE without paramaters give the same error. We have yet to try it on other foreign OS. The command line we use to install is:
Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:28:01 2006 Function Name: SetupBootstrapOptionsScope.InstallMediaPath Source Line Number: 44
Class not registered. Failed to create CAB file due to datastore exception Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:27:59 2006 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "2232"} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:28:01 2006 Function Name: SetupBootstrapOptionsScope.HostSetup Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupBootstrapOptionsScope" Message pump returning: 2
Log Location: C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log MSP Error: 29537 SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. To continue, correct the problem, and then run SQL Server Setup again.
I tried to search internet, however, I couldn't get solution.
My SQL server 2005 is standard version, OS Windows server 2003 sp2, I am using Administrator account to install it.
I am trying to create an un-attended SQL 2005 Express install. I have successfully made my own template.ini file to install SQL the way I like but I cannot find a way to make it install with the "Ad hox remote queries" option enabled.
Is there anyway to do this? I can't seem to find any switches in the INI file to allow this.
I'm currently trying to develop an unattended installation of the Client Tools to be distributed to developers workstations.
All is well on 'clean' machines, but the problems arise when an instance of SQL Server Express is already present. The install fails, and the reason isn't clear from the log files.
I know Express installs a couple of the Client Components (like Config Manager), and I believe this is what it blocking me.
Has anyone tried this scenario?
Would I be best to REMOVE the Client_Components first, and then re-install them with SSMS etc.? Or is there a better method?
I have to leave the Express Database instance untouched as I'm not responsible for its installation or maintenance.
I am trying to install Sql Server 2005 SP2 (KB921896) on a Windows Server 2003 box that has all the other patches installed. However, the service pack fails on Databse Services and Analysis Serrvices. The Summary.txt file is listed below. I have already done some research and tried putting the NT Authority/SYSTEM in the local Administrators group but I still get the same error. Can anyone help? Thanks Time: 06/21/2007 15:30:09.610 KB Number: KB921896 Machine: PDSQL OS Version: Microsoft Windows Server 2003 family, Standard Edition Service Pack 2 (Build 3790) Package Language: 1033 (ENU) Package Platform: x86 Package SP Level: 2 Package Version: 3042 Command-line parameters specified: Cluster Installation: No
********************************************************************************** Prerequisites Check & Status SQLSupport: Passed
********************************************************************************** Products Detected Language Level Patch Level Platform Edition Setup Support Files ENU 9.2.3042 x86 Database Services (MSSQLSERVER) ENU SP1 2005.090.2047.00 x86 STANDARD Analysis Services (MSSQLSERVER) ENU SP1 2005.090.2047.00 x86 STANDARD Reporting Services (MSSQLSERVER) ENU SP2 9.00.3054.00 x86 STANDARD Notification Services ENU SP2 9.00.3054.00 x86 STANDARD Integration Services ENU SP2 9.00.3054.00 x86 STANDARD SQL Server Native Client ENU 9.00.3042.00 x86 Client Components ENU SP2 9.2.3054 x86 STANDARD MSXML 6.0 Parser ENU 6.10.1129.0 x86 SQLXML4 ENU 9.00.3042.00 x86 Backward Compatibility ENU 8.05.2004 x86 Microsoft SQL Server VSS Writer ENU 9.00.3042.00 x86
********************************************************************************** Products Disqualified & Reason Product Reason Reporting Services (MSSQLSERVER) The product instance MSSQLSERVER been patched with more recent updates. Notification Services The product instance NS been patched with more recent updates. Integration Services The product instance Integration Services been patched with more recent updates. Client Components The product instance SQL Tools been patched with more recent updates.
********************************************************************************** Processes Locking Files Process Name Feature Type User Name PID msftesql Database Services Service NT AUTHORITYSYSTEM 3464 SQLBrowser Database Services Service NT AUTHORITYSYSTEM 5276
********************************************************************************** Product Installation Status Product : Setup Support Files Product Version (Previous): 3042 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- Product : Database Services (MSSQLSERVER) Product Version (Previous): 2047 Product Version (Final) : Status : Failure Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log Error Number : 29512 Error Description : MSP Error: 29512 SQL Server Setup was unable add user NT AUTHORITYSYSTEM to local group PERSONNELALSQLServer2005SQLAgentUser$PDSQL$MSSQLSERVER. ---------------------------------------------------------------------------------- Product : Analysis Services (MSSQLSERVER) Product Version (Previous): 2047 Product Version (Final) : Status : Failure Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixOLAP9_Hotfix_KB921896_sqlrun_as.msp.log Error Number : 29512 Error Description : MSP Error: 29512 SQL Server Setup was unable add user NT AUTHORITYSYSTEM to local group PERSONNELALSQLServer2005MSOLAPUser$PDSQL$MSSQLSERVER. ---------------------------------------------------------------------------------- Product : Reporting Services (MSSQLSERVER) Product Version (Previous): 3054 Product Version (Final) : Status : NA Log File : Error Description : The product instance MSSQLSERVER been patched with more recent updates. ---------------------------------------------------------------------------------- Product : Notification Services Product Version (Previous): 3054 Product Version (Final) : Status : NA Log File : Error Description : The product instance NS been patched with more recent updates. ---------------------------------------------------------------------------------- Product : Integration Services Product Version (Previous): 3054 Product Version (Final) : Status : NA Log File : Error Description : The product instance Integration Services been patched with more recent updates. ---------------------------------------------------------------------------------- Product : SQL Server Native Client Product Version (Previous): 3042 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- Product : Client Components Product Version (Previous): 3054 Product Version (Final) : Status : NA Log File : Error Description : The product instance SQL Tools been patched with more recent updates. ---------------------------------------------------------------------------------- Product : MSXML 6.0 Parser Product Version (Previous): 1129 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- Product : SQLXML4 Product Version (Previous): 3042 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- Product : Backward Compatibility Product Version (Previous): 2004 Product Version (Final) : Status : Not Selected Log File : Error Description : ---------------------------------------------------------------------------------- Product : Microsoft SQL Server VSS Writer Product Version (Previous): 3042 Product Version (Final) : Status : Not Selected Log File : Error Description : ----------------------------------------------------------------------------------
********************************************************************************** Summary One or more products failed to install, see above for details Exit Code Returned: 29512
I'm having a problem installing SQL Server 2005 and I hope someone can give me an idea how to proceed. I have two machines and it works fine on one but fails to install on the other. The maddening thing is that the message reporting the failure gives me absolutely no feedback other than that the install failed.
I downloaded VB 2005 Express with MSDN and SQL Server 2005 Express. The .NET framework, VB and MSDN installed fine and then it failed on SQL Server. I have uninstalled and tried again several times with the same results. There's nothing unusual about my PC. It's relatively new with plenty of memory and disk storage. It's a Dell PC with a 2.4GHZ processor. There is another database product running on this system. Is that likely to be an issue?
Service Pack 2 fails to install using the Microsoft Update site. After clicking "Find solution", I got directed here.
The only error is with the Database Services (Relevant bits from the logfile):
Code Snippet
---------------------------------------------------------------------------------- Product : Database Services (MSSQLSERVER) Product Version (Previous): 1399 Product Version (Final) : Status : Failure Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log Error Number : 29528 Error Description : MSP Error: 29528 The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.
This refers to another logfile (yet again, just the interesting bits):
Code Snippet
Property(S): SQL200564Hotfix3042 = d:f13bd9da239b4b5240e6HotFixSQLFilessqlrun_sql.msp MSI (s) (FC:C0) [16:56:04:243]: Product: Microsoft SQL Server 2005 (64-bit) - Update 'Service Pack 2 for SQL Server Database Services 2005 (64-bit) ENU (KB921896)' could not be installed. Error code 1603. Additional information is available in the log file C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log.
MSI (s) (FC:C0) [16:56:04:243]: Note: 1: 1729 MSI (s) (FC:C0) [16:56:04:243]: Transforming table Error.
MSI (s) (FC:C0) [16:56:04:243]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (FC:C0) [16:56:04:243]: Transforming table Error.
MSI (s) (FC:C0) [16:56:04:258]: Transforming table Error.
MSI (s) (FC:C0) [16:56:04:258]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (FC:C0) [16:56:04:258]: Transforming table Error.
MSI (s) (FC:C0) [16:56:04:258]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (FC:C0) [16:56:04:258]: Transforming table Error.
MSI (s) (FC:C0) [16:56:04:258]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (FC:C0) [16:56:04:258]: Transforming table Error.
MSI (s) (FC:C0) [16:56:04:258]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (FC:C0) [16:56:04:258]: Transforming table Error.
MSI (s) (FC:C0) [16:56:04:258]: Transforming table Error.
MSI (s) (FC:C0) [16:56:04:258]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (FC:C0) [16:56:04:274]: Transforming table Error.
MSI (s) (FC:C0) [16:56:04:274]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (FC:C0) [16:56:04:274]: Transforming table Error.
MSI (s) (FC:C0) [16:56:04:274]: Note: 1: 2262 2: Error 3: -2147287038 MSI (s) (FC:C0) [16:56:04:274]: Product: Microsoft SQL Server 2005 (64-bit) -- Configuration failed.
MSI (s) (FC:C0) [16:56:04:274]: Attempting to delete file C:WINDOWSInstaller199c46.msp MSI (s) (FC:C0) [16:56:04:274]: Unable to delete the file. LastError = 32 MSI (s) (FC:C0) [16:56:04:274]: Cleaning up uninstalled install packages, if any exist MSI (s) (FC:C0) [16:56:04:274]: MainEngineThread is returning 1603 MSI (s) (FC:0C) [16:56:04:289]: Destroying RemoteAPI object. MSI (s) (FC:68) [16:56:04:289]: Custom Action Manager thread ending. === Logging stopped: 8-5-2007 16:56:04 === MSI (c) (9C:8C) [16:56:04:289]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1 MSI (c) (9C:8C) [16:56:04:289]: MainEngineThread is returning 1603 === Verbose logging stopped: 8-5-2007 16:56:04 ===
I've checked the locations of the file, and they are all installed in the default folder:
Is there a way to get it to install anyways? Manually trying to install it has the exact same result as Microsoft Update. Everything EXCEPT the DataBase Services is upgraded.
I'm trying to do an unattended upgrade of 2014 RTM to 2014 SP1.
It's my first attempt at an upgrade configuration file, and its failing with missing registry entry for database engine service and replication service.
Error in summary.txt is:
The registry key SOFTWAREMicrosoftMicrosoft SQL ServerMSSQL12.MSSQLSERVER2495Setup is missing
That's a valid error, as the registry only has an entry for:
I am trying to install MS SQL Server Express but the installation always fails. I have copied the summary log below and can provide more details if you require.
Hardware:P4 1.7G CPU,30G HDD space,1G memory
Microsoft SQL Server 2005 9.00.2047.00 ============================== OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600) Time : Fri Jul 21 15:08:24 2006
Machine : YANGNAN Product : Microsoft SQL Server 安装程åº?支æŒ?文件(英è¯) Product Version : 9.00.2047.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_YANGNAN_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : YANGNAN Product : Microsoft SQL Server Native Client Product Version : 9.00.2047.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_YANGNAN_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : YANGNAN Product : Microsoft SQL Server VSS 编写器 Product Version : 9.00.2047.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_YANGNAN_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : YANGNAN Product : MSXML 6.0 分æž?程åº? Product Version : 6.00.3883.15 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_YANGNAN_MSXML6_1.log -------------------------------------------------------------------------------- Machine : YANGNAN Product : SQL Server Database Services Error : The computer running SQL Server Setup does not meet minimum system requirements for this SQL Server release.Microsoft SQL Server is not supported on this operating system. For details, see Hardware and Software Requirements in the readme or in SQL Server Books Online. -------------------------------------------------------------------------------- Machine : YANGNAN Product : Microsoft SQL Server 2005 Product Version : 9.00.1399.06 Install : Failed Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_YANGNAN_SQL.log Last Action : DetectSKUOS Error String : The computer running SQL Server Setup does not meet minimum system requirements for this SQL Server release.Microsoft SQL Server is not supported on this operating system. For details, see Hardware and Software Requirements in the readme or in SQL Server Books Online. Error Number : 28018 --------------------------------------------------------------------------------
After a carefull reading of several post about this error I decided to post mine just in case it gives some clue to somebody with the knowledge I haven´t as I saw there is two kind of customers with this or very similar errors:
1. Some of them finally had success (error: 15209) installing it following the instructions in http://support.microsoft.com/kb/920114/en-us
2. Some still fighting with the problem (err: 29503).
Both errors give the same instructions, to my understand (very poor) and I followed every suggestion, but let me do some history:
1. I have 3 computers at home, all them from different makers and XP bundled on them, now all them SP2 thanks to the Updates service.
2. One has nothing extra on it. Used only to surf the net/play games and nothing more (Wife). One for work (Mine and Main), with VS 2005, Intel Pentium IV HT 3 Ghz and a Toshiba laptop with VS2005 and the same processor with not problems at all.
3. Due to former issues installing SQL server in Mine I decided finally to start from scratch, so I formatted the disk, installed XP and downloaded SP 2 and all automatic updates, then installed VS 2005 Standard and got exactly the same issue as before.
Sorry to make it long. The point is that following the instructions in MS KB documents and several posts to the letter I found out several strange things:
1. None of my computers is able to show an Address bar in Windows Explorer, when checked to be shown only produces a new greyed item in the icons bar at the very right end. If pressing F11 (full screen) then the address bar is shown and can be used.
2. Only the laptop had a folder named Protect in the indicated path.
3. None of them shows a Security tab in the Properties window of any folder or file.
4. In this thread http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=841859&SiteID=1 I thought at the very last post was the solution for my issue but then I found out another strange story: None of my computer have the "Simple file sharing" or "Use Simple file sharing" in the View label of Folder Options.
5. And this is possible the final clue: When examining the options in View label I realized that all the optios were related in my mother tongue (Spanish) whils the rest of the window was in English as I live in England and nearly all my software is in this language. Even some upgrades from MS when I was asked to choice a language I selected Spanish.
6. Only possibly I´m not the only one under these circumstances: https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=377860&SiteID=1 (Polish)
Doing Action: Do_sqlScript PerfTime Start: Do_sqlScript : Mon Dec 25 11:40:04 2006 Service MSSQLSERVER with parameters '-m SqlSetup -Q -qLatin1_General_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Mon Dec 25 11:40:05 2006 Service failed unexpectedly (1067) Error Code: 0x8007042b (1067) Windows Error Text: The process terminated unexpectedly. Source File Name: sqlsetuplibservice.cpp Compiler Timestamp: Wed Oct 26 16:37:52 2005 Function Name: sqls::Service::Start Source Line Number: 301
Setting status of unmanaged components and removing unmanaged resources Do_sqlScript SqlScriptHlpr Start service MSSQLSERVER
Error Code: 1067 MSI (s) (F0!A4) [11:40:16:500]: Product: Microsoft SQL Server 2005 Express Edition -- Error 29503. 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 (1067) The process terminated unexpectedly. .
Error 29503. 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 (1067) The process terminated unexpectedly. . <Failure Type='Fatal' Error='1067'> <EndFunc Name='LaunchFunction' Return='1067' GetLastError='203'> MSI (s) (F0:4C) [11:40:16:578]: User policy value 'DisableRollback' is 0 MSI (s) (F0:4C) [11:40:16:578]: Machine policy value 'DisableRollback' is 0 Action ended 11:40:16: InstallFinalize. Return value 3.
7. The only difference between my laptop and desktop computers is that in regional settings Laptop has English for Regional options whilst desktop had Spanish.
Tried to change in desktop to English wont produce success installing SQL Server Express so I think there are more deep changes/corrections to do.
Those changes from English to Spanish is some XP windows are not coming from the first install, as the laptop came installed, so they should be produced after some upgrade were I was offered to download a regional version (SP 2?).
Hopefully this long post will give to some body with more brains and knowledge than me to get a work around to this problem, other than reformat, install and download SP 2 this time in English.
Setup has detected a problem with Microsoft .Net Framework installation and cannot proceed. Microsoft .Net Framework 2.0 is either not installed on this system or is corrupt.
I cannot uninstall 2.0, as its part of the Vista. I have tried repairing it.
I tried downloading 2.0 and installing it, but it says that its allready installed.
I was able to install Visual Studio with Sql Server 2005 express.
I am stuck. Is the case that Sql install dosent know about the latest version of 2.0 that came with vista ?
In C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFiles SQLSetup0001_MYSERVER_Core(Local).log I have the following error: ============= Error: Action "ReportChainingResults" threw an exception during execution. One or more packages failed to install. Refer to logs for error details. : 3 Error Code: 0x80070003 (3) Windows Error Text: The system cannot find the path specified. Source File Name: sqlchainingsqlchainingactions.cpp Compiler Timestamp: Thu Nov 16 20:31:57 2006 Function Name: sqls::ReportChainingResults:erform Source Line Number: 3521 ---- Context ----------------------------------------------- sqls::HostSetupPackageInstallerSynch:ostCommit sqls::HighlyAvailablePackage:reInstall led due to cancel code received from cancel source: 29539 Error: Failed to add file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_MYSERVER_.NET Framework 2.0.log" to cab file : "C:SQLEXPRsetup.cab" Error Code : 2 Running: UploadDrWatsonLogAction at: 2008/2/18 18:14:45 Message pump returning: 3 ============ The file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_MYSERVER_.NET Framework 2.0.log" does not exist.
What I've tried so far: 1. Using Add/Remove Programs, uninstall the following: A. Microsoft SQL Server Native Client B. Microsoft SQL Server Setup Support Files (English) C. Microsoft SQL Server VSS Writer D. Microsoft .NET Framework 2.0 (based on a post elsewhere that this resolved someone else problem) 2. Verified that the following Registry Keys were removed: A. HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServer B. HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server C. HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Native Client (If they were not, I deleted them manually.)
When I was asked to help, the SSE installation had already been attempted 4 times. Part of their resolution attempts had been to install .NET 3.0, but I have not yet re-installed that. It appears that .NET is still the culprit. Here is some information on the system: Host Name: MYSERVER OS Name: Microsoft(R) Windows(R) Server 2003, Standard Edition OS Version: 5.2.3790 Service Pack 2 Build 3790 OS Manufacturer: Microsoft Corporation OS Configuration: Standalone Server OS Build Type: Multiprocessor Free Registered Owner: User Registered Organization: MY LLC Product ID: 69712-OEM-4411902-02111 Original Install Date: 8/30/2007, 3:29:16 PM System Up Time: 0 Days, 2 Hours, 1 Minutes, 56 Seconds System Manufacturer: Dell Computer Corporation System Model: PowerEdge 840 System Type: X86-based PC Processor(s): 2 Processor(s) Installed. [01]: x86 Family 6 Model 15 Stepping 2 GenuineIntel ~2133 Mhz [02]: x86 Family 6 Model 15 Stepping 2 GenuineIntel ~2133 Mhz BIOS Version: DELL - 1 Windows Directory: C:WINDOWS System Directory: C:WINDOWSsystem32 Boot Device: DeviceHarddiskVolume2 System Locale: en-us;English (United States) Input Locale: en-us;English (United States) Time Zone: (GMT-07:00) Mountain Time (US & Canada) Total Physical Memory: 4,095 MB Available Physical Memory: 3,626 MB Page File: Max Size: 5,976 MB Page File: Available: 5,665 MB Page File: In Use: 311 MB Page File Location(s): C:pagefile.sys Domain: WORKGROUP Logon Server: \MYSERVER Hotfix(s): 79 Hotfix(s) Installed. [01]: File 1 [02]: File 1 [03]: File 1 [04]: File 1 [05]: File 1 [06]: File 1 [07]: File 1 [08]: File 1 [09]: File 1 [10]: File 1 [11]: File 1 [12]: File 1 [13]: File 1 [14]: File 1 [15]: File 1 [16]: File 1 [17]: File 1 [18]: File 1 [19]: File 1 [20]: File 1 [21]: File 1 [22]: File 1 [23]: File 1 [24]: File 1 [25]: File 1 [26]: File 1 [27]: File 1 [28]: File 1 [29]: File 1 [30]: File 1 [31]: File 1 [32]: File 1 [33]: File 1 [34]: File 1 [35]: File 1 [36]: File 1 [37]: Q147222 [38]: KB933854 - QFE [39]: Q936181 [40]: IDNMitigationAPIs - Update [41]: NLSDownlevelMapping - Update [42]: KB925398_WMP64 [43]: KB937143-IE7 - Update [44]: KB938127-IE7 - Update [45]: KB939653-IE7 - Update [46]: KB942615-IE7 - Update [47]: KB944533-IE7 - Update [48]: KB921503 - Update [49]: KB924667-v2 - Update [50]: KB925876 - Update [51]: KB925902 - Update [52]: KB926122 - Update [53]: KB927891 - Update [54]: KB929123 - Update [55]: KB930178 - Update [56]: KB931784 - Update [57]: KB932168 - Update [58]: KB933360 - Update [59]: KB933729 - Update [60]: KB933854 - Update [61]: KB935839 - Update [62]: KB935840 - Update [63]: KB936021 - Update [64]: KB936357 - Update [65]: KB936782 - Update [66]: KB937143 - Update [67]: KB938127 - Update [68]: KB941202 - Update [69]: KB941568 - Update [70]: KB941569 - Update [71]: KB941644 - Update [72]: KB942763 - Update [73]: KB943055 - Update [74]: KB943460 - Update [75]: KB943485 - Update [76]: KB944653 - Update [77]: KB946026 - Update [78]: KB948496 - Update [79]: XpsEPSC
My next thought is to try this: http://groups.google.com/group/microsoft.public.windowsupdate/msg/4d76de7769d04493 Does anyone have any better suggestions? Is the .NET Framework the likely problem here?
I am trying to install MS SQL Server Express but the installation always fails. I have copied the summary log below and can provide more details if you require. Web Developer and C# Express install OK.
I have been trying to install this for around 2 weeks now with no luck ... I even had the PC formatted and rebuilt but the install still fails. If it installed and worked before, i cannot understand why it doesn't work now. The summary log is provided below:
Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600) Time : Thu Jun 22 10:42:08 2006
GLKD2396800 : The current system does not meet recommended hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online. Machine : GLKD2396800 Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : GLKD2396800 Product : Microsoft SQL Server Native Client Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : GLKD2396800 Product : Microsoft SQL Server VSS Writer Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : GLKD2396800 Product : MSXML 6.0 Parser Product Version : 6.00.3883.8 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_MSXML6_1.log -------------------------------------------------------------------------------- Machine : GLKD2396800 Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQLSupport_2.log -------------------------------------------------------------------------------- Machine : GLKD2396800 Product : Microsoft SQL Server Native Client Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQLNCLI_2.log -------------------------------------------------------------------------------- Machine : GLKD2396800 Product : MSXML 6.0 Parser Product Version : 6.00.3883.8 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_MSXML6_2.log -------------------------------------------------------------------------------- Machine : GLKD2396800 Product : SQL Server Database Services 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." -------------------------------------------------------------------------------- Machine : GLKD2396800 Product : SQL Server Database Services 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." -------------------------------------------------------------------------------- Machine : GLKD2396800 Product : Microsoft SQL Server 2005 Express Edition Product Version : 9.00.1399.06 Install : Failed Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_SQL.log Last Action : InstallFinalize 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 (1067) The process terminated unexpectedly. Error Number : 29503 -------------------------------------------------------------------------------- Machine : GLKD2396800 Product : Microsoft SQL Server 2005 Tools Express Edition Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_GLKD2396800_Tools.log --------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
When I was trying to SQL Server 2005 Express SP2 (November CTP) on Vista RTM, setup failed on the Database Services component with the following log messages:
SQL service MSSQL$SQLEXPRESS started successfully waiting for SQL service to accept client connectionsService MSSQL$SQLEXPRESS started at Sat Nov 18 09:21:28 2006SQL_SUCCESS_WITH_INFO (1) in OdbcConnection::connectsqlstate=01000, level=-1, state=-1, native_error=5701, msg=[Microsoft][SQL Native Client][SQL Server]Changed database context to 'master'.sqlstate=01000, level=-1, state=-1, native_error=5703, msg=[Microsoft][SQL Native Client][SQL Server]Changed language setting to us_english.SQL_SUCCESS_WITH_INFO (1) in OdbcStatement::execute_batchsqlstate=01000, level=0, state=1, native_error=5701, msg=[Microsoft][SQL Native Client][SQL Server]Changed database context to 'master'.SQL_SUCCESS_WITH_INFO (1) in OdbcStatement::execute_batchsqlstate=01000, level=0, state=1, native_error=15457, msg=[Microsoft][SQL Native Client][SQL Server]Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.SQL_SUCCESS_WITH_INFO (1) in OdbcStatement::execute_batchsqlstate=01000, level=0, state=1, native_error=15457, msg=[Microsoft][SQL Native Client][SQL Server]Configuration option 'default language' changed from 0 to 0. Run the RECONFIGURE statement to install.sqlstate=01000, level=0, state=1, native_error=15457, msg=[Microsoft][SQL Native Client][SQL Server]Configuration option 'default full-text language' changed from 1033 to 1033. Run the RECONFIGURE statement to install.SQL_SUCCESS_WITH_INFO (1) in OdbcStatement::execute_batchsqlstate=01000, level=0, state=1, native_error=15457, msg=[Microsoft][SQL Native Client][SQL Server]Configuration option 'show advanced options' changed from 1 to 0. Run the RECONFIGURE statement to install.SQL_ERROR (-1) in OdbcStatement::execute_batchsqlstate=42000, level=11, state=1, native_error=15401, msg=[Microsoft][SQL Native Client][SQL Server]Windows NT user or group 'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS' not found. Check the name again.sqlstate=42000, level=16, state=1, native_error=15007, msg=[Microsoft][SQL Native Client][SQL Server]'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS' is not a valid login or you do not have permission. Error Code: 0x80073c29 (15401)Windows Error Text: Source File Name: libodbc_statement.hCompiler Timestamp: Wed Aug 2 16:21:02 2006 Function Name: OdbcStatement::execute_batch@CnfgSQL@80Source Line Number: 91---- Context -----------------------------------------------Connecting to SQL ServerExecuteSqlCommandsUSE [master ]<Started SQL statement: Sat Nov 18 09:21:28 2006>declare @ServerName nvarchar(255) if not exists (select * from sysservers) begin select @ServerName = Convert(nvarchar(255), SERVERPROPERTY(N'ServerName')) execute sys.sp_addserver @ServerName, local end<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>ALTER DATABASE model SET RECOVERY SIMPLE<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>EXEC sp_configure N'show advanced options', 1 RECONFIGURE WITH OVERRIDE<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>DECLARE @Name AS nvarchar(128), @LangID AS smallint SELECT @Name=name, @LangID=langid FROM syslanguages WHERE lcid=1033 EXEC sp_defaultlanguage N'sa', @Name EXEC sp_configure N'default language', @LangID EXEC sp_configure N'default full-text language', 1033 RECONFIGURE WITH OVERRIDE<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>EXEC sp_configure N'show advanced options', 0 RECONFIGURE WITH OVERRIDE<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>EXEC sys.sp_grantlogin N'BUILTINAdministrators' EXEC sys.sp_addsrvrolemember N'BUILTINAdministrators', N'sysadmin'<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>EXEC sys.sp_grantlogin N'NT AUTHORITYSYSTEM' EXEC sys.sp_addsrvrolemember N'NT AUTHORITYSYSTEM', N'sysadmin'<Finished SQL statement: Sat Nov 18 09:21:28 2006><Started SQL statement: Sat Nov 18 09:21:28 2006>EXEC sys.sp_grantlogin N'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS' EXEC sys.sp_addsrvrolemember N'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS', N'sysadmin'Originial error was 80073c29 (15401)Do_sqlScriptSqlScriptHlprError Code: 15401MSI (s) (98:50) [09:21:30:219]: I/O on thread 3236 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3300 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3652 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3424 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3244 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3544 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3064 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 3428 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 2000 could not be cancelled. Error: 1168MSI (s) (98:50) [09:21:30:219]: I/O on thread 1740 could not be cancelled. Error: 1168MSI (s) (98!78) [09:21:30:219]: Product: Microsoft SQL Server 2005 -- Error 29521. SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Windows NT user or group 'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS' not found. Check the name again.. Refer to the server error logs and Setup logs for detailed error information.Error 29521. SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Windows NT user or group 'TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS' not found. Check the name again.. Refer to the server error logs and Setup logs for detailed error information.
TEHBOXSQLServer2005MSSQLUser$TEHBOX$SQLEXPRESS exists and contains NT AUTHORITYNETWORK SERVICE when the error occurs.
Any suggestions on how to get SQL Server to install on Vista?
I have been trying to install SQL Server 2005 developer version on my second laptop IBM Thinkpad Windows XP PRO, for the first time. All other components installed successfully except the database. I 've tried selecting the named instance and default instance it didn't make any difference. I have a Admin role on the laptop and as a service id I selected my user id. password and domain. I am running the setup behind my company's firewall.
The error in the log is :
Doing Action: Do_UpdateETWMOFWithGUID PerfTime Start: Do_UpdateETWMOFWithGUID : Wed May 09 11:07:46 2007 <Func Name='Do_UpdateETWMOFWithGUID'> Calling installSqlEvent Trance The arguments that are passed to InstallSqlEventTrace are InstanceName: SQLSERVER2005 , ProductCodeL: {2373A92B-1C1C-4E71-B494-5CA97F96AA19} , BinPath: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn INFO: Checking installed version INFO: Writing MOF file ERROR: Unable to open registry key: HRESULT = 0x80070005, Key = SYSTEMCurrentControlSetControlWMISecurity
The value returned is -2147024891 <EndFunc Name='Do_UpdateETWMOFWithGUID' Return='1603' GetLastError='0'> PerfTime Stop: Do_UpdateETWMOFWithGUID : Wed May 09 11:07:46 2007 Gathering darwin properties for failure handling. Error Code: 1603
MSI (s) (88!E0) [11:09:48:898]: Product: Microsoft SQL Server 2005 -- Error 29528. The setup has encountered an unexpected error while Updating Installed Files. The error is: Fatal error during installation.
Error 29528. The setup has encountered an unexpected error while Updating Installed Files. The error is: Fatal error during installation.
I have tried to attach the log but I think it is too big. I cannot post this message.
Please let me know another way to send the log file.
I am trying to setup Sql server 2005 express edition but ı getting an error message that cannot install. The Logfile is below.
Thanks...
Cagri
Microsoft SQL Server 2005 9.00.3042.00 ============================== OS Version : Home Edition (Build 6000) Time : Tue Sep 04 22:44:28 2007
Machine : QUIETUS-PC Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.3042.00 Install : Successful Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0007_QUIETUS-PC_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : QUIETUS-PC Product : Microsoft SQL Server Native Client Product Version : 9.00.3042.00 Install : Successful Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0007_QUIETUS-PC_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : QUIETUS-PC Product : Microsoft SQL Server VSS Writer Product Version : 9.00.3042.00 Install : Successful Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0007_QUIETUS-PC_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : QUIETUS-PC Product : SQL Server Database Services Error : SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Windows NT user or group 'QUIETUS-PCSQLServer2005MSSQLUser$QUIETUS-PC$SQLEXPRESS' not found. Check the name again.. Refer to the server error logs and Setup logs for detailed error information. -------------------------------------------------------------------------------- Machine : QUIETUS-PC Product : Microsoft SQL Server 2005 Express Edition Product Version : 9.2.3042.00 Install : Failed Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0007_QUIETUS-PC_SQL.log Last Action : InstallFinalize Error String : SQL Server Setup failed to execute a command for server configuration. The error was {Microsoft}{SQL Native Client}{SQL Server}Windows NT user or group 'QUIETUS-PCSQLServer2005MSSQLUser$QUIETUS-PC$SQLEXPRESS' not found. Check the name again.. Refer to the server error logs and Setup logs for detailed error information. Error Number : 29521
During an install of SQL Server 2005 Express setting the sa password does not work consistently. The install is being run as administrator and I am using an .ini file to pass the settings,
and while most times it works correctly, occasionally, maybe 4 out of 10 times it fails to set the password and I have been unable to find any warnings or errors in the logs it generates.
We are coming up on release and this is causing us some real problems. Does anyone have any ideas, something I could look at?
In the last step of installing the SQL Server 2005 Express edition I get the following error:
Doing Action: Do_sqlScript PerfTime Start: Do_sqlScript : Thu Jun 21 19:38:35 2007 Service MSSQL$SQLEXPRESS with parameters '-d"c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamaster.mdf" -l"c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamastlog.ldf" -m SqlSetup -Q -qLatin1_General_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Jun 21 19:38:35 2007 Service failed unexpectedly (1814) Error Code: 0x80070716 (1814) Windows Error Text: The specified resource name cannot be found in the image file. Source File Name: sqlsetuplibservice.cpp Compiler Timestamp: Wed Jun 14 16:29:04 2006 Function Name: sqls:ervice:tart Source Line Number: 301
Do_sqlScript SqlScriptHlpr Start service MSSQL$SQLEXPRESS
Error Code: 1814 MSI (s) (80!08) [19:39:58:265]: Product: Microsoft SQL Server 2005 Express Edition -- Error 29503. 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 (1814) The specified resource name cannot be found in the image file. .
Error 29503. 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 (1814) The specified resource name cannot be found in the image file. . <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_sqlScript PerfTime Start: Do_sqlScript : Thu Jun 21 19:39:58 2007 Service MSSQL$SQLEXPRESS with parameters '-d"c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamaster.mdf" -l"c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamastlog.ldf" -m SqlSetup -Q -qLatin1_General_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Jun 21 19:39:58 2007 Service failed unexpectedly (1814) Error Code: 0x80070716 (1814) Windows Error Text: The specified resource name cannot be found in the image file. Source File Name: sqlsetuplibservice.cpp Compiler Timestamp: Wed Jun 14 16:29:04 2006 Function Name: sqls:ervice:tart Source Line Number: 301
Hi, I've just tried to install SQL Server 2005 Standard and I'm getting an error that I can't find any information on. In the log, I find Error 29503. A message after it indicates that it couldn't start the server.
I'm trying to install "SQL Server 2005 Express Edition SP2" on a newly installed XP Pro SP2 machine. I downloaded "SQLEXPR32.EXE" (38,220,656 bytes) from the Microsoft site.
At the beginning of the setup the installation program scans my system -- no problems or warnings. Everything looks fine and ready to go.
During installation I uncheck, "Hide advanced configuration options" simply because I want to change the default instance name. Aside from changing the default instance name I make no other changes to the default installation configuration.
The installation begins but when it tries to comes to the "SQL Native Client" portion of the installation I get the following error dialog message:
"An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'."
Below I've included the setup log file of the SQL Native Client portion of the setup. I've looked through the log file but didn't see anything obviously wrong until the error occurs toward the end.
Does anyone have an idea of what might be causing this to happen? I've install SSE many times in the past with no problems.
Thanks
Code Snippet
=== Verbose logging started: 6/10/2007 23:03:13 Build type: SHIP UNICODE 3.01.4000.4039 Calling process: C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe === MSI (c) (C0:8C) [23:03:13:093]: Resetting cached policy values MSI (c) (C0:8C) [23:03:13:093]: Machine policy value 'Debug' is 0 MSI (c) (C0:8C) [23:03:13:093]: ******* RunEngine: ******* Product: {F9B3DD02-B0B3-42E9-8650-030DFF0D133D} ******* Action: ******* CommandLine: ********** MSI (c) (C0:8C) [23:03:13:093]: Client-side and UI is none or basic: Running entire install on the server. MSI (c) (C0:8C) [23:03:13:093]: Grabbed execution mutex. MSI (c) (C0:8C) [23:03:13:093]: Cloaking enabled. MSI (c) (C0:8C) [23:03:13:093]: Attempting to enable all disabled priveleges before calling Install on Server MSI (c) (C0:8C) [23:03:13:093]: Incrementing counter to disable shutdown. Counter after increment: 0 MSI (s) (D0:94) [23:03:13:109]: Grabbed execution mutex. MSI (s) (D0:B4) [23:03:13:109]: Resetting cached policy values MSI (s) (D0:B4) [23:03:13:109]: Machine policy value 'Debug' is 0 MSI (s) (D0:B4) [23:03:13:109]: ******* RunEngine: ******* Product: {F9B3DD02-B0B3-42E9-8650-030DFF0D133D} ******* Action: ******* CommandLine: ********** MSI (s) (D0:B4) [23:03:13:109]: Machine policy value 'DisableUserInstalls' is 0 MSI (s) (D0:B4) [23:03:13:109]: End dialog not enabled MSI (s) (D0:B4) [23:03:13:109]: Original package ==> C:WINDOWSInstaller1d32b7a.msi MSI (s) (D0:B4) [23:03:13:109]: Package we're running from ==> C:WINDOWSInstaller1d32b7a.msi MSI (s) (D0:B4) [23:03:13:125]: APPCOMPAT: looking for appcompat database entry with ProductCode '{F9B3DD02-B0B3-42E9-8650-030DFF0D133D}'. MSI (s) (D0:B4) [23:03:13:125]: APPCOMPAT: no matching ProductCode found in database. MSI (s) (D0:B4) [23:03:13:125]: MSCOREE already loaded, using loaded copy MSI (s) (D0:B4) [23:03:13:125]: Machine policy value 'DisablePatch' is 0 MSI (s) (D0:B4) [23:03:13:125]: Machine policy value 'AllowLockdownPatch' is 0 MSI (s) (D0:B4) [23:03:13:125]: Machine policy value 'DisableLUAPatching' is 0 MSI (s) (D0:B4) [23:03:13:125]: Machine policy value 'DisableFlyWeightPatching' is 0 MSI (s) (D0:B4) [23:03:13:125]: APPCOMPAT: looking for appcompat database entry with ProductCode '{F9B3DD02-B0B3-42E9-8650-030DFF0D133D}'. MSI (s) (D0:B4) [23:03:13:125]: APPCOMPAT: no matching ProductCode found in database. MSI (s) (D0:B4) [23:03:13:125]: Transforms are not secure. MSI (s) (D0:B4) [23:03:13:125]: Command Line: STPSETUPTHREADID=2000 STPSETUPPROCESSID=1472 EXTERNALCONTROL=1 ADDLOCAL=ALL SKIPPENDINGREBOOTCHECK=1 APPGUID={2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F} REBOOT=ReallySuppress CURRENTDIRECTORY=C:Program FilesMicrosoft SQL Server90Setup Bootstrap CLIENTUILEVEL=3 CLIENTPROCESSID=1472 MSI (s) (D0:B4) [23:03:13:125]: PROPERTY CHANGE: Adding PackageCode property. Its value is '{8225F098-4183-422F-B208-3018904DFA0C}'. MSI (s) (D0:B4) [23:03:13:125]: Product Code passed to Engine.Initialize: '{F9B3DD02-B0B3-42E9-8650-030DFF0D133D}' MSI (s) (D0:B4) [23:03:13:125]: Product Code from property table before transforms: '{F9B3DD02-B0B3-42E9-8650-030DFF0D133D}' MSI (s) (D0:B4) [23:03:13:125]: Product Code from property table after transforms: '{F9B3DD02-B0B3-42E9-8650-030DFF0D133D}' MSI (s) (D0:B4) [23:03:13:125]: Product registered: entering maintenance mode MSI (s) (D0:B4) [23:03:13:125]: PROPERTY CHANGE: Adding ProductState property. Its value is '5'. MSI (s) (D0:B4) [23:03:13:125]: PROPERTY CHANGE: Adding ProductToBeRegistered property. Its value is '1'. MSI (s) (D0:B4) [23:03:13:125]: Package name retrieved from configuration data: 'sqlncli.msi' MSI (s) (D0:B4) [23:03:13:125]: Determined that existing product (either this product or the product being upgraded with a patch) is installed per-machine. MSI (s) (D0:B4) [23:03:13:140]: Note: 1: 2262 2: AdminProperties 3: -2147287038 MSI (s) (D0:B4) [23:03:13:140]: Machine policy value 'DisableMsi' is 0 MSI (s) (D0:B4) [23:03:13:140]: Machine policy value 'AlwaysInstallElevated' is 0 MSI (s) (D0:B4) [23:03:13:140]: User policy value 'AlwaysInstallElevated' is 0 MSI (s) (D0:B4) [23:03:13:140]: Product {F9B3DD02-B0B3-42E9-8650-030DFF0D133D} is admin assigned: LocalSystem owns the publish key. MSI (s) (D0:B4) [23:03:13:140]: Product {F9B3DD02-B0B3-42E9-8650-030DFF0D133D} is managed. MSI (s) (D0:B4) [23:03:13:140]: Running product '{F9B3DD02-B0B3-42E9-8650-030DFF0D133D}' with elevated privileges: Product is assigned. MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding STPSETUPTHREADID property. Its value is '2000'. MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding STPSETUPPROCESSID property. Its value is '1472'. MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding EXTERNALCONTROL property. Its value is '1'. MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding ADDLOCAL property. Its value is 'ALL'. MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding SKIPPENDINGREBOOTCHECK property. Its value is '1'. MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding APPGUID property. Its value is '{2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}'. MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding REBOOT property. Its value is 'ReallySuppress'. MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding CURRENTDIRECTORY property. Its value is 'C:Program FilesMicrosoft SQL Server90Setup Bootstrap'. MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding CLIENTUILEVEL property. Its value is '3'. MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding CLIENTPROCESSID property. Its value is '1472'. MSI (s) (D0:B4) [23:03:13:140]: TRANSFORMS property is now: MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding PRODUCTLANGUAGE property. Its value is '1033'. MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding VersionDatabase property. Its value is '301'. MSI (s) (D0:B4) [23:03:13:140]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoApplication Data MSI (s) (D0:B4) [23:03:13:140]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoFavorites MSI (s) (D0:B4) [23:03:13:140]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoNetHood MSI (s) (D0:B4) [23:03:13:140]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoMy Documents MSI (s) (D0:B4) [23:03:13:140]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoPrintHood MSI (s) (D0:B4) [23:03:13:156]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoRecent MSI (s) (D0:B4) [23:03:13:156]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoSendTo MSI (s) (D0:B4) [23:03:13:156]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoTemplates MSI (s) (D0:B4) [23:03:13:156]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersApplication Data MSI (s) (D0:B4) [23:03:13:156]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoLocal SettingsApplication Data MSI (s) (D0:B4) [23:03:13:156]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoMy DocumentsMy Pictures MSI (s) (D0:B4) [23:03:13:156]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuProgramsAdministrative Tools MSI (s) (D0:B4) [23:03:13:156]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuProgramsStartup MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuPrograms MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart Menu MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersDesktop MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoStart MenuProgramsAdministrative Tools MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoStart MenuProgramsStartup MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoStart MenuPrograms MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoStart Menu MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoDesktop MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersTemplates MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:WINDOWSFonts MSI (s) (D0:B4) [23:03:13:187]: Note: 1: 2898 2: MS Sans Serif 3: MS Sans Serif 4: 0 5: 16 MSI (s) (D0:B4) [23:03:13:187]: PROPERTY CHANGE: Adding Privileged property. Its value is '1'. MSI (s) (D0:B4) [23:03:13:187]: PROPERTY CHANGE: Adding USERNAME property. Its value is 'Tony'. MSI (s) (D0:B4) [23:03:13:187]: Note: 1: 1402 2: HKEY_CURRENT_USERSoftwareMicrosoftMS Setup (ACME)User Info 3: 2 MSI (s) (D0:B4) [23:03:13:187]: PROPERTY CHANGE: Adding Installed property. Its value is '00:00:00'. MSI (s) (D0:B4) [23:03:13:187]: PROPERTY CHANGE: Adding DATABASE property. Its value is 'C:WINDOWSInstaller1d32b7a.msi'. MSI (s) (D0:B4) [23:03:13:187]: PROPERTY CHANGE: Adding OriginalDatabase property. Its value is 'C:WINDOWSInstaller1d32b7a.msi'. MSI (s) (D0:B4) [23:03:13:187]: Note: 1: 2205 2: 3: PatchPackage MSI (s) (D0:B4) [23:03:13:187]: Machine policy value 'DisableRollback' is 0 MSI (s) (D0:B4) [23:03:13:187]: User policy value 'DisableRollback' is 0 MSI (s) (D0:B4) [23:03:13:187]: PROPERTY CHANGE: Adding UILevel property. Its value is '2'. === Logging started: 6/10/2007 23:03:13 === MSI (s) (D0:B4) [23:03:13:187]: PROPERTY CHANGE: Adding Preselected property. Its value is '1'. MSI (s) (D0:B4) [23:03:13:187]: PROPERTY CHANGE: Adding ACTION property. Its value is 'INSTALL'. MSI (s) (D0:B4) [23:03:13:187]: Doing action: INSTALL MSI (s) (D0:B4) [23:03:13:187]: Running ExecuteSequence MSI (s) (D0:B4) [23:03:13:187]: Doing action: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E Action start 23:03:13: INSTALL. MSI (s) (D0:B4) [23:03:13:203]: PROPERTY CHANGE: Adding WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWS'. Action start 23:03:13: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E. MSI (s) (D0:B4) [23:03:13:203]: Doing action: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E Action ended 23:03:13: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (D0:B4) [23:03:13:203]: PROPERTY CHANGE: Adding SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSsystem32'. Action start 23:03:13: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E. MSI (s) (D0:B4) [23:03:13:203]: Doing action: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E Action ended 23:03:13: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (D0:B4) [23:03:13:203]: PROPERTY CHANGE: Adding WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWS'. Action start 23:03:13: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E. MSI (s) (D0:B4) [23:03:13:203]: Doing action: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E Action ended 23:03:13: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (D0:B4) [23:03:13:203]: PROPERTY CHANGE: Adding SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSsystem32'. Action start 23:03:13: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E. MSI (s) (D0:B4) [23:03:13:203]: Doing action: LaunchConditions Action ended 23:03:13: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E. Return value 1. Action start 23:03:13: LaunchConditions. MSI (s) (D0:B4) [23:03:13:203]: Doing action: FindRelatedProducts Action ended 23:03:13: LaunchConditions. Return value 1. MSI (s) (D0:B4) [23:03:13:203]: Skipping FindRelatedProducts action: not run in maintenance mode Action start 23:03:13: FindRelatedProducts. MSI (s) (D0:B4) [23:03:13:203]: Skipping action: CA_SetRefCountUpgradeFlag (condition is false) MSI (s) (D0:B4) [23:03:13:203]: Skipping action: CA_SetRefCountNewerFoundFlag (condition is false) MSI (s) (D0:B4) [23:03:13:203]: Doing action: IsPendingRebootKey Action ended 23:03:13: FindRelatedProducts. Return value 0. MSI (s) (D0:44) [23:03:13:218]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSIA9.tmp, Entrypoint: IsPendingReboot MSI (s) (D0:3C) [23:03:13:218]: Generating random cookie. MSI (s) (D0:3C) [23:03:13:234]: Created Custom Action Server with PID 2372 (0x944). MSI (s) (D0:70) [23:03:13:312]: Running as a service. MSI (s) (D0:70) [23:03:13:328]: Hello, I'm your 32bit Impersonated custom action server. Action start 23:03:13: IsPendingRebootKey. No PendingFileRenameOperations MSI (s) (D0:B4) [23:03:13:343]: Skipping action: CA_ErrorDifferentLang (condition is false) MSI (s) (D0:B4) [23:03:13:343]: Skipping action: SetWOW (condition is false) MSI (s) (D0:B4) [23:03:13:343]: Skipping action: SetWOWAppendCustomPath (condition is false) MSI (s) (D0:B4) [23:03:13:343]: Skipping action: SetWOWINSTALLSQLSHAREDDIR_CUSTOMPATH (condition is false) MSI (s) (D0:B4) [23:03:13:343]: Skipping action: SetWOWINSTALLSQLSHAREDDIR_CUSTOMPATH_ADD (condition is false) MSI (s) (D0:B4) [23:03:13:343]: Skipping action: Sqlmsirc_ValidateAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false) MSI (s) (D0:B4) [23:03:13:343]: Skipping action: Sqlmsirc_RefCountAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false) MSI (s) (D0:B4) [23:03:13:343]: Skipping action: Sqlmsirc_BackupAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false) MSI (s) (D0:B4) [23:03:13:343]: Skipping action: Sqlmsirc_RegisterAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false) MSI (s) (D0:B4) [23:03:13:343]: Skipping action: Sqlmsirc_RestoreAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false) MSI (s) (D0:B4) [23:03:13:343]: Doing action: AppSearch Action ended 23:03:13: IsPendingRebootKey. Return value 1. Action start 23:03:13: AppSearch. MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2262 2: Signature 3: -2147287038 MSI (s) (D0:B4) [23:03:13:359]: PROPERTY CHANGE: Adding REDISTINSTALLEDVERSION property. Its value is '9.00.3042.00'. MSI (s) (D0:B4) [23:03:13:359]: Skipping action: SkipInstallCA (condition is false) MSI (s) (D0:B4) [23:03:13:359]: Skipping action: CA_ErrorPendingReboot (condition is false) MSI (s) (D0:B4) [23:03:13:359]: Skipping action: CCPSearch (condition is false) MSI (s) (D0:B4) [23:03:13:359]: Skipping action: RMCCPSearch (condition is false) MSI (s) (D0:B4) [23:03:13:359]: Doing action: ValidateProductID Action ended 23:03:13: AppSearch. Return value 1. Action start 23:03:13: ValidateProductID. MSI (s) (D0:B4) [23:03:13:359]: Skipping action: Sqlmsirc_CheckLanguage.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false) MSI (s) (D0:B4) [23:03:13:359]: Doing action: CostInitialize Action ended 23:03:13: ValidateProductID. Return value 1. MSI (s) (D0:B4) [23:03:13:359]: Machine policy value 'MaxPatchCacheSize' is 10 Action start 23:03:13: CostInitialize. MSI (s) (D0:B4) [23:03:13:359]: PROPERTY CHANGE: Adding ROOTDRIVE property. Its value is 'D:'. MSI (s) (D0:B4) [23:03:13:359]: PROPERTY CHANGE: Adding CostingComplete property. Its value is '0'. MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2205 2: 3: Patch MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2205 2: 3: PatchPackage MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2205 2: 3: MsiPatchHeaders MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2205 2: 3: __MsiPatchFileList MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2205 2: 3: PatchPackage MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2228 2: 3: PatchPackage 4: SELECT `DiskId`, `PatchId`, `LastSequence` FROM `Media`, `PatchPackage` WHERE `Media`.`DiskId`=`PatchPackage`.`Media_` ORDER BY `DiskId` MSI (s) (D0:B4) [23:03:13:359]: Doing action: FileCost Action ended 23:03:13: CostInitialize. Return value 1. MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2262 2: Class 3: -2147287038 MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2262 2: Extension 3: -2147287038 MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2262 2: TypeLib 3: -2147287038 Action start 23:03:13: FileCost. MSI (s) (D0:B4) [23:03:13:359]: Doing action: IsolateComponents Action ended 23:03:13: FileCost. Return value 1. Action start 23:03:13: IsolateComponents. MSI (s) (D0:B4) [23:03:13:375]: Doing action: CostFinalize Action ended 23:03:13: IsolateComponents. Return value 0. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding OutOfDiskSpace property. Its value is '0'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding OutOfNoRbDiskSpace property. Its value is '0'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding PrimaryVolumeSpaceAvailable property. Its value is '0'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding PrimaryVolumeSpaceRequired property. Its value is '0'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding PrimaryVolumeSpaceRemaining property. Its value is '0'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding EULA.84118FFB_F307_45F3_B5BC_3A4F8261108D property. Its value is 'C:Program FilesMicrosoft SQL Server90EULA'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Modifying SystemFolder property. Its current value is 'C:WINDOWSsystem32'. Its new value: 'C:WINDOWSsystem32'. MSI (s) (D0:B4) [23:03:13:375]: Note: 1: 2205 2: 3: Patch MSI (s) (D0:B4) [23:03:13:375]: Note: 1: 2262 2: Condition 3: -2147287038 MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding TARGETDIR property. Its value is 'D:'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Modifying SystemFolder property. Its current value is 'C:WINDOWSsystem32'. Its new value: 'C:WINDOWSsystem32'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding VSINSTALLDIR property. Its value is 'C:Program FilesMicrosoft Visual Studio 8'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding VSINSTALLROOT property. Its value is 'C:Program FilesMicrosoft Visual Studio 8'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding SqlShared property. Its value is 'C:Program FilesMicrosoft SQL Server'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding Ver.06870705_8636_410E_B591_FEE8962A550E property. Its value is 'C:Program FilesMicrosoft SQL Server90'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding SqlSDK.06870705_8636_410E_B591_FEE8962A550E property. Its value is 'C:Program FilesMicrosoft SQL Server90SDK'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding SqlSDKLib.06870705_8636_410E_B591_FEE8962A550E property. Its value is 'C:Program FilesMicrosoft SQL Server90SDKLib'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding SqlSDKLibPlatformTarget.06870705_8636_410E_B591_FEE8962A550E property. Its value is 'C:Program FilesMicrosoft SQL Server90SDKLibx86'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding SqlInclude.06870705_8636_410E_B591_FEE8962A550E property. Its value is 'C:Program FilesMicrosoft SQL Server90SDKInclude'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding Ver90.84118FFB_F307_45F3_B5BC_3A4F8261108D property. Its value is 'C:Program FilesMicrosoft SQL Server90'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Modifying EULA.84118FFB_F307_45F3_B5BC_3A4F8261108D property. Its current value is 'C:Program FilesMicrosoft SQL Server90EULA'. Its new value: 'C:Program FilesMicrosoft SQL Server90EULA'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding INSTALLSQLSHAREDDIR property. Its value is 'C:Program FilesMicrosoft SQL Server'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding SqlVer property. Its value is 'C:Program FilesMicrosoft SQL Server90'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding SqlTools property. Its value is 'C:Program FilesMicrosoft SQL Server90Tools'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding SqlToolsBin property. Its value is 'C:Program FilesMicrosoft SQL Server90ToolsBinn'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding WinSxsDirectory.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxs'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding policydir_ul.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_51e427d4'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding payload.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_51e427d4'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding WinSxsManifests.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsManifests'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding WinSxsPolicies.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsPolicies'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding policydir.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsPoliciesx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_x-ww_77c24773'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding payload_ul.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsx86_policy.8.0.microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.42_none_5c4003bc63e949f6'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding WinSxsDirectory.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxs'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding policydir_ul.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_0de06acd'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding WinSxsPolicies.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsPolicies'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding policydir.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsPoliciesx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_x-ww_4428b63a'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding WinSxsManifests.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsManifests'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding payload.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_0de06acd'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding payload_ul.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsx86_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.42_none_db5f52fb98cb24ad'. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding VSRetarget property. Its value is 'C:Program FilesMicrosoft SQL Server90ToolsBinn'. MSI (s) (D0:B4) [23:03:13:375]: Target path resolution complete. Dumping Directory table... MSI (s) (D0:B4) [23:03:13:375]: Note: target paths subject to change (via custom actions or browsing) MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: TARGETDIR , Object: D: MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WindowsFolder , Object: C:WINDOWS MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SystemFolder , Object: C:WINDOWSsystem32 MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: ProgramFilesFolder , Object: C:Program Files MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: VSINSTALLDIR , Object: C:Program FilesMicrosoft Visual Studio 8 MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: VSINSTALLROOT , Object: C:Program FilesMicrosoft Visual Studio 8 MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SqlShared , Object: C:Program FilesMicrosoft SQL Server MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: Ver.06870705_8636_410E_B591_FEE8962A550E , Object: C:Program FilesMicrosoft SQL Server90 MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SqlSDK.06870705_8636_410E_B591_FEE8962A550E , Object: C:Program FilesMicrosoft SQL Server90SDK MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SqlSDKLib.06870705_8636_410E_B591_FEE8962A550E , Object: C:Program FilesMicrosoft SQL Server90SDKLib MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SqlSDKLibPlatformTarget.06870705_8636_410E_B591_FEE8962A550E , Object: C:Program FilesMicrosoft SQL Server90SDKLibx86 MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SqlInclude.06870705_8636_410E_B591_FEE8962A550E , Object: C:Program FilesMicrosoft SQL Server90SDKInclude MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: Ver90.84118FFB_F307_45F3_B5BC_3A4F8261108D , Object: C:Program FilesMicrosoft SQL Server90 MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: EULA.84118FFB_F307_45F3_B5BC_3A4F8261108D , Object: C:Program FilesMicrosoft SQL Server90EULA MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: INSTALLSQLSHAREDDIR , Object: C:Program FilesMicrosoft SQL Server MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SqlVer , Object: C:Program FilesMicrosoft SQL Server90 MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SqlTools , Object: C:Program FilesMicrosoft SQL Server90Tools MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SqlToolsBin , Object: C:Program FilesMicrosoft SQL Server90ToolsBinn MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWS MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWSsystem32 MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WinSxsDirectory.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxs MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: policydir_ul.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_51e427d4 MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: payload.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_51e427d4 MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WinSxsManifests.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsManifests MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WinSxsPolicies.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsPolicies MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: policydir.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsPoliciesx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_x-ww_77c24773 MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: payload_ul.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsx86_policy.8.0.microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.42_none_5c4003bc63e949f6 MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWS MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWSsystem32 MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WinSxsDirectory.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxs MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: policydir_ul.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_0de06acd MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WinSxsPolicies.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsPolicies MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: policydir.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsPoliciesx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_x-ww_4428b63a MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WinSxsManifests.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsManifests MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: payload.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_0de06acd MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: payload_ul.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsx86_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.42_none_db5f52fb98cb24ad MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: VSRetarget , Object: C:Program FilesMicrosoft SQL Server90ToolsBinn Action start 23:03:13: CostFinalize. MSI (s) (D0:B4) [23:03:13:375]: Doing action: ARPInstallLocation.9B634CFE_9A39_4508_9CA8_D8DE65A7B8AD Action ended 23:03:13: CostFinalize. Return value 1. MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding ARPINSTALLLOCATION property. Its value is 'C:WINDOWSsystem32'. Action start 23:03:13: ARPInstallLocation.9B634CFE_9A39_4508_9CA8_D8DE65A7B8AD. MSI (s) (D0:B4) [23:03:13:375]: Doing action: IsDotNet20Installed Action ended 23:03:13: ARPInstallLocation.9B634CFE_9A39_4508_9CA8_D8DE65A7B8AD. Return value 1. MSI (s) (D0:50) [23:03:13:390]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSIAA.tmp, Entrypoint: IsDotNetFramework20Installed Action start 23:03:13: IsDotNet20Installed. Feature SQL_SNAC_CORE install action does not match 2. Not all features are being removed. MSI (s) (D0!90) [23:03:13:421]: PROPERTY CHANGE: Deleting EnableDotNetCheck property. Its current value is '0'. MSI (s) (D0!90) [23:03:13:421]: PROPERTY CHANGE: Adding DOTNETCOREPATH property. Its value is '1'. Either there are no .NET Framework assemblies present in MsiAssembly table or they do not require the GAC, no need to check for the .NET Framework MSI (s) (D0:B4) [23:03:13:421]: Skipping action: CA_ErrorPrereqDotNet (condition is false) MSI (s) (D0:B4) [23:03:13:421]: Skipping action: CA_SetARPINSTALLLOCATION (condition is false) MSI (s) (D0:B4) [23:03:13:421]: Doing action: SetODBCFolders Action ended 23:03:13: IsDotNet20Installed. Return value 1. MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2205 2: 3: ODBCDriver MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2228 2: 3: ODBCDriver 4: SELECT `ComponentId`,`Description`,`Directory_`, `ActionRequest`, `Installed`, `Attributes` FROM `ODBCDriver`, `Component` WHERE `ODBCDriver`.`Component_` = `Component` AND (`ActionRequest` = 1 OR `ActionRequest` = 2) MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2205 2: 3: ODBCTranslator MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2228 2: 3: ODBCTranslator 4: SELECT `ComponentId`,`Description`,`Directory_`, `ActionRequest`, `Installed`, `Attributes` FROM `ODBCTranslator`, `Component` WHERE `ODBCTranslator`.`Component_` = `Component` AND (`ActionRequest` = 1 OR `ActionRequest` = 2) Action start 23:03:13: SetODBCFolders. MSI (s) (D0:B4) [23:03:13:421]: Doing action: MigrateFeatureStates Action ended 23:03:13: SetODBCFolders. Return value 0. MSI (s) (D0:B4) [23:03:13:421]: Skipping MigrateFeatureStates action: not run in maintenance mode Action start 23:03:13: MigrateFeatureStates. MSI (s) (D0:B4) [23:03:13:421]: Doing action: InstallValidate Action ended 23:03:13: MigrateFeatureStates. Return value 0. MSI (s) (D0:B4) [23:03:13:421]: Feature: SQL_SNAC_CORE; Installed: Local; Request: Local; Action: Local MSI (s) (D0:B4) [23:03:13:421]: Feature: SQL_SNAC_SDK; Installed: Absent; Request: Local; Action: Local MSI (s) (D0:B4) [23:03:13:421]: Component: RedistVersionReg.C3E5819B-5744-41E9-BEF2-12652D7B9053; Installed: Local; Request: Null; Action: Null MSI (s) (D0:B4) [23:03:13:421]: Component: Redist_Uninstall_RegKey.E63C6774-A4E8-4A1A-A090-567FE0DA2FBF; Installed: Local; Request: Null; Action: Null MSI (s) (D0:B4) [23:03:13:421]: Component: License_SQLNCLI_ENU.txt.84118FFB_F307_45F3_B5BC_3A4F8261108D; Installed: Local; Request: Null; Action: Null MSI (s) (D0:B4) [23:03:13:421]: Component: sqlncli.dll.9B634CFE_9A39_4508_9CA8_D8DE65A7B8AD; Installed: Local; Request: Null; Action: Null MSI (s) (D0:B4) [23:03:13:421]: Component: RedistQFEKey.9B634CFE_9A39_4508_9CA8_D8DE65A7B8AD; Installed: Local; Request: Null; Action: Null MSI (s) (D0:B4) [23:03:13:421]: Component: sqlnclir.rll.A0C5BB09_6818_43E8_AF1C_A1C3C70B210C; Installed: Local; Request: Null; Action: Null MSI (s) (D0:B4) [23:03:13:421]: Component: sqlncli.chm.A0C5BB09_6818_43E8_AF1C_A1C3C70B210C; Installed: Local; Request: Null; Action: Null MSI (s) (D0:B4) [23:03:13:421]: Component: uplevel.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E; Installed: Local; Request: Null; Action: Null MSI (s) (D0:B4) [23:03:13:421]: Component: downlevel_manifest.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E; Installed: Local; Request: Null; Action: Null MSI (s) (D0:B4) [23:03:13:421]: Component: downlevel_payload.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E; Installed: Local; Request: Null; Action: Null MSI (s) (D0:B4) [23:03:13:421]: Component: nosxs.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E; Installed: Local; Request: Null; Action: Null MSI (s) (D0:B4) [23:03:13:421]: Component: uplevel.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E; Installed: Local; Request: Null; Action: Null MSI (s) (D0:B4) [23:03:13:421]: Component: downlevel_manifest.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E; Installed: Local; Request: Null; Action: Null MSI (s) (D0:B4) [23:03:13:421]: Component: msmd.h.06870705_8636_410E_B591_FEE8962A550E; Installed: Absent; Request: Local; Action: Local MSI (s) (D0:B4) [23:03:13:421]: Component: oledbdm.h.06870705_8636_410E_B591_FEE8962A550E; Installed: Absent; Request: Local; Action: Local MSI (s) (D0:B4) [23:03:13:421]: Component: sqlncli.h.06870705_8636_410E_B591_FEE8962A550E; Installed: Absent; Request: Local; Action: Local MSI (s) (D0:B4) [23:03:13:421]: Component: srv.h.06870705_8636_410E_B591_FEE8962A550E; Installed: Absent; Request: Local; Action: Local MSI (s) (D0:B4) [23:03:13:421]: Component: sqlncli.lib.06870705_8636_410E_B591_FEE8962A550E; Installed: Absent; Request: Local; Action: Local MSI (s) (D0:B4) [23:03:13:421]: Component: opends60.lib.06870705_8636_410E_B591_FEE8962A550E; Installed: Absent; Request: Local; Action: Local MSI (s) (D0:B4) [23:03:13:421]: Component: __uplevel.98CB24AD_52FB_DB5F_FF1F_C8B3B9A165; Installed: Null; Request: Null; Action: Null MSI (s) (D0:B4) [23:03:13:421]: Component: __uplevel.63E949F6_03BC_5C40_FF1F_C8B3B9A165; Installed: Null; Request: Null; Action: Null MSI (s) (D0:B4) [23:03:13:421]: Component: __Redist_Uninstall_RegKey.E63C6774-A4E8-4A65; Installed: Null; Request: Null; Action: Null MSI (s) (D0:B4) [23:03:13:421]: Component: __RedistVersionReg.C3E5819B-5744-41E9-BEF265; Installed: Null; Request: Null; Action: Null MSI (s) (D0:B4) [23:03:13:421]: Component: __RedistQFEKey.9B634CFE_9A39_4508_9CA8_D8D65; Installed: Null; Request: Null; Action: Null MSI (s) (D0:B4) [23:03:13:421]: Component: __sqlncli.dll.9B634CFE_9A39_4508_9CA8_D8DE65; Installed: Null; Request: Null; Action: Null MSI (s) (D0:B4) [23:03:13:421]: Component: __sqlnclir.rll.A0C5BB09_6818_43E8_AF1C_A1C65; Installed: Null; Request: Null; Action: Null MSI (s) (D0:B4) [23:03:13:421]: Component: __downlevel_payload.98CB24AD_52FB_DB5F_FF165; Installed: Null; Request: Null; Action: Null MSI (s) (D0:B4) [23:03:13:421]: Component: __nosxs.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E165; Installed: Null; Request: Null; Action: Null MSI (s) (D0:B4) [23:03:13:421]: Component: __downlevel_manifest.98CB24AD_52FB_DB5F_FF65; Installed: Null; Request: Null; Action: Null MSI (s) (D0:B4) [23:03:13:421]: Component: __downlevel_manifest.63E949F6_03BC_5C40_FF65; Installed: Null; Request: Null; Action: Null MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2205 2: 3: BindImage MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2205 2: 3: ProgId MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2262 2: PublishComponent 3: -2147287038 MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2205 2: 3: SelfReg MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2262 2: Extension 3: -2147287038 MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2205 2: 3: Font MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2205 2: 3: Shortcut MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2262 2: Class 3: -2147287038 Action start 23:03:13: InstallValidate. MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2205 2: 3: _RemoveFilePath MSI (s) (D0:B4) [23:03:13:437]: PROPERTY CHANGE: Modifying CostingComplete property. Its current value is '0'. Its new value: '1'. MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2205 2: 3: BindImage MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2205 2: 3: ProgId MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2262 2: PublishComponent 3: -2147287038 MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2205 2: 3: SelfReg MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2262 2: Extension 3: -2147287038 MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2205 2: 3: Font MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2205 2: 3: Shortcut MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2262 2: Class 3: -2147287038 MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2727 2: MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2727 2: MSI (s) (D0:B4) [23:03:13:437]: Doing action: InstallInitialize Action ended 23:03:13: InstallValidate. Return value 1. MSI (s) (D0:B4) [23:03:13:437]: Machine policy value 'AlwaysInstallElevated' is 0 MSI (s) (D0:B4) [23:03:13:437]: User policy value 'AlwaysInstallElevated' is 0 MSI (s) (D0:B4) [23:03:13:437]: BeginTransaction: Locking Server MSI (s) (D0:B4) [23:03:13:437]: SRSetRestorePoint skipped for this transaction. MSI (s) (D0:B4) [23:03:13:437]: Server not locked: locking for product {F9B3DD02-B0B3-42E9-8650-030DFF0D133D} Action start 23:03:13: InstallInitialize. MSI (s) (D0:B4) [23:03:13:859]: Doing action: Sqlmsirc_ValidateAppGuid.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 Action ended 23:03:13: InstallInitialize. Return value 1. MSI (s) (D0:70) [23:03:13:875]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSIAB.tmp, Entrypoint: Sqlmsirc_ValidateAppGuid Action start 23:03:13: Sqlmsirc_ValidateAppGuid.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1. <Func Name='Sqlmsirc_ValidateAppGuid'> <EndFunc Name='Sqlmsirc_ValidateAppGuid' Return='0' GetLastError='0'> MSI (s) (D0:B4) [23:03:13:890]: Skipping action: Sqlmsirc_RefCountAppGuid.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false) MSI (s) (D0:B4) [23:03:13:890]: Skipping action: Sqlmsirc_BackupAppGuid.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false) MSI (s) (D0:B4) [23:03:13:890]: Skipping action: Sqlmsirc_CheckAppDependency.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false) MSI (s) (D0:B4) [23:03:13:890]: Doing action: SxsInstallCA Action ended 23:03:13: Sqlmsirc_ValidateAppGuid.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1. Return value 1. MSI (s) (D0:88) [23:03:13:906]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSIAC.tmp, Entrypoint: CustomAction_SxsMsmInstall Action start 23:03:13: SxsInstallCA. 1: sxsdelca 2: traceop 3: 1262 4: 0 1: sxsdelca 2: traceop 3: 1263 4: 0 1: sxsdelca 2: traceop 3: 1264 4: 0 1: sxsdelca 2: traceop 3: 1269 4: 0 1: sxsdelca 2: traceop 3: 1288 4: 0 1: sxsdelca 2: traceop 3: 1292 4: 0 1: sxsdelca 2: traceop 3: 1293 4: 0 1: sxsdelca 2: traceop 3: 1294 4: 0 1: sxsdelca 2: traceop 3: 1296 4: 0 1: sxsdelca 2: traceop 3: 1322 4: 0 1: sxsdelca: Skipping component 2: uplevel.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E 1: sxsdelca 2: traceop 3: 1288 4: 0 1: sxsdelca 2: traceop 3: 1292 4: 0 1: sxsdelca 2: traceop 3: 1293 4: 0 1: sxsdelca 2: traceop 3: 1294 4: 0 1: sxsdelca 2: traceop 3: 1296 4: 0 1: sxsdelca 2: traceop 3: 1322 4: 0 1: sxsdelca: Skipping component 2: downlevel_manifest.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E 1: sxsdelca 2: traceop 3: 1288 4: 0 1: sxsdelca 2: traceop 3: 1292 4: 0 1: sxsdelca 2: traceop 3: 1293 4: 0 1: sxsdelca 2: traceop 3: 1294 4: 0 1: sxsdelca 2: traceop 3: 1296 4: 0 1: sxsdelca 2: traceop 3: 1322 4: 0 1: sxsdelca: Skipping component 2: downlevel_payload.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E 1: sxsdelca 2: traceop 3: 1288 4: 0 1: sxsdelca 2: traceop 3: 1292 4: 0 1: sxsdelca 2: traceop 3: 1293 4: 0 1: sxsdelca 2: traceop 3: 1294 4: 0 1: sxsdelca 2: traceop 3: 1296 4: 0 1: sxsdelca 2: traceop 3: 1322 4: 0 1: sxsdelca: Skipping component 2: uplevel.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E 1: sxsdelca 2: traceop 3: 1288 4: 0 1: sxsdelca 2: traceop 3: 1292 4: 0 1: sxsdelca 2: traceop 3: 1293 4: 0 1: sxsdelca 2: traceop 3: 1294 4: 0 1: sxsdelca 2: traceop 3: 1296 4: 0 1: sxsdelca 2: traceop 3: 1322 4: 0 1: sxsdelca: Skipping component 2: downlevel_manifest.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E 1: sxsdelca 2: traceop 3: 1288 4: 259 1: sxsdelca 2: SxsMsmInstall completed 3: 0 4: 0 MSI (s) (D0:B4) [23:03:14:000]: Skipping action: AllocateRegistrySpace (condition is false) MSI (s) (D0:B4) [23:03:14:000]: Doing action: ProcessComponents Action ended 23:03:14: SxsInstallCA. Return value 1. Action start 23:03:14: ProcessComponents. MSI (s) (D0:B4) [23:03:14:000]: Doing action: UnpublishComponents Action ended 23:03:14: ProcessComponents. Return value 1. MSI (s) (D0:B4) [23:03:14:000]: Note: 1: 2262 2: PublishComponent 3: -2147287038 Action start 23:03:14: UnpublishComponents. MSI (s) (D0:B4) [23:03:14:000]: Doing action: MsiUnpublishAssemblies Action ended 23:03:14: UnpublishComponents. Return value 1. Action start 23:03:14: MsiUnpublishAssemblies. MSI (s) (D0:B4) [23:03:14:015]: Doing action: UnpublishFeatures Action ended 23:03:14: MsiUnpublishAssemblies. Return value 1. Action start 23:03:14: UnpublishFeatures. MSI (s) (D0:B4) [23:03:14:015]: Doing action: StopServices Action ended 23:03:14: UnpublishFeatures. Return value 1. MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2262 2: ServiceControl 3: -2147287038 Action start 23:03:14: StopServices. MSI (s) (D0:B4) [23:03:14:015]: Doing action: DeleteServices Action ended 23:03:14: StopServices. Return value 1. MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2262 2: ServiceControl 3: -2147287038 Action start 23:03:14: DeleteServices. MSI (s) (D0:B4) [23:03:14:015]: Doing action: UnregisterComPlus Action ended 23:03:14: DeleteServices. Return value 1. MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2205 2: 3: Complus MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2228 2: 3: Complus 4: SELECT `ComponentId`, `FileName`, `Component`.`Directory_`, `ExpType`, `Component`.`Action`, `Component`.`Installed` FROM `Complus`, `Component`, `File` WHERE `Complus`.`Component_` = `Component` AND `Component`.`KeyPath` = `File`.`File` AND `Action` = 0 Action start 23:03:14: UnregisterComPlus. MSI (s) (D0:B4) [23:03:14:015]: Doing action: SelfUnregModules Action ended 23:03:14: UnregisterComPlus. Return value 0. MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2205 2: 3: SelfReg MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2228 2: 3: SelfReg 4: Select `File`.`FileName`,`Component`.`Directory_`,`Component`.`Installed`, `File`.`Component_`,`SelfReg`.`File_` From `SelfReg`, `File`, `Component` Where `SelfReg`.`File_` = `File`.`File` And `File`.`Component_` = `Component`.`Component` And `Component`.`Action` = 0 Action start 23:03:14: SelfUnregModules. MSI (s) (D0:B4) [23:03:14:015]: Doing action: UnregisterTypeLibraries Action ended 23:03:14: SelfUnregModules. Return value 1. MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2262 2: TypeLib 3: -2147287038 Action start 23:03:14: UnregisterTypeLibraries. MSI (s) (D0:B4) [23:03:14:015]: Doing action: UnregisterFonts Action ended 23:03:14: UnregisterTypeLibraries. Return value 1. MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2205 2: 3: Font MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2228 2: 3: Font 4: SELECT `FontTitle`, `FileName`, `Directory_`, `Installed`From `Font`, `FileAction` Where `Font`.`File_` = `FileAction`.`File` And `FileAction`.`Action` = 0 ORDER BY `FileAction`.`Directory_` Action start 23:03:14: UnregisterFonts. MSI (s) (D0:B4) [23:03:14:015]: Doing action: RemoveRegistryValues Action ended 23:03:14: UnregisterFonts. Return value 1. Action start 23:03:14: RemoveRegistryValues. MSI (s) (D0:B4) [23:03:14:031]: Doing action: UnregisterClassInfo Action ended 23:03:14: RemoveRegistryValues. Return value 1. MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2262 2: Class 3: -2147287038 Action start 23:03:14: UnregisterClassInfo. MSI (s) (D0:B4) [23:03:14:031]: Doing action: UnregisterExtensionInfo Action ended 23:03:14: UnregisterClassInfo. Return value 1. MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2262 2: Extension 3: -2147287038 Action start 23:03:14: UnregisterExtensionInfo. MSI (s) (D0:B4) [23:03:14:031]: Doing action: UnregisterProgIdInfo Action ended 23:03:14: UnregisterExtensionInfo. Return value 1. MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2205 2: 3: ProgId MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2228 2: 3: ProgId 4: SELECT DISTINCT `BinaryType`, `ProgId`, `Class_`, `ProgId`.`Description`, `ProgId`.`Icon_`, `ProgId`.`IconIndex`, null, `Component`.`RuntimeFlags` , `Component`.`Component` FROM `ProgId`, `Class`, `Feature`, `Component` WHERE `ProgId`.`Class_` = `Class`.`CLSID` AND `Class`.`Feature_` = `Feature` AND `Class`.`Component_` = `Component` AND (`Feature`.`Action` = 0 OR (`Feature`.`Action` = 4 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2)) OR ((`Feature`.`Action` = NULL OR `Feature`.`Action` = 3) AND `Component`.`Action` = 0 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2))) Action start 23:03:14: UnregisterProgIdInfo. MSI (s) (D0:B4) [23:03:14:031]: Doing action: UnregisterMIMEInfo Action ended 23:03:14: UnregisterProgIdInfo. Return value 0. MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2205 2: 3: MIME MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2228 2: 3: MIME 4: SELECT `BinaryType`, `ContentType`, `Extension`.`Extension`, `MIME`.`CLSID`, `Component`.`RuntimeFlags`, `Component`.`Component` FROM `MIME`, `Extension`, `Feature`, `Component` WHERE `MIME`.`Extension_` = `Extension`.`Extension` AND `Feature_` = `Feature` AND `Extension`.`Component_` = `Component` AND (`Feature`.`Action` = 0 OR (`Feature`.`Action` = 4 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2)) OR ((`Feature`.`Action` = NULL OR `Feature`.`Action` = 3) AND `Component`.`Action` = 0 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2))) Action start 23:03:14: UnregisterMIMEInfo. MSI (s) (D0:B4) [23:03:14:031]: Doing action: RemoveIniValues Action ended 23:03:14: UnregisterMIMEInfo. Return value 0. MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2205 2: 3: IniFile MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2228 2: 3: IniFile 4: SELECT `FileName`,`IniFile`.`DirProperty`,`Section`,`IniFile`.`Key`,`IniFile`.`Value`,`IniFile`.`Action` FROM `IniFile`, `Component` WHERE `Component`=`Component_` AND `Component`.`Action`=0 ORDER BY `FileName`,`Section` Action start 23:03:14: RemoveIniValues. MSI (s) (D0:B4) [23:03:14:031]: Doing action: RemoveShortcuts Action ended 23:03:14: RemoveIniValues. Return value 1. MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2205 2: 3: Shortcut MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2228 2: 3: Shortcut 4: SELECT `Name`, null, `Shortcut`.`Directory_`, `Component`.`RuntimeFlags`, `Feature`.`Action`, `Component`.`Action` From `Shortcut`, `Feature`, `Component` WHERE `Target` = `Feature` AND `Shortcut`.`Component_` = `Component` AND (`Feature`.`Action` = 0 OR (`Feature`.`Action` = 4 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2)) OR ((`Feature`.`Action` = NULL OR `Feature`.`Action` = 3) AND `Component`.`Action` = 0 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2))) Action start 23:03:14: RemoveShortcuts. MSI (s) (D0:B4) [23:03:14:031]: Doing action: RemoveEnvironmentStrings Action ended 23:03:14: RemoveShortcuts. Return value 0. MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2205 2: 3: Environment MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2228 2: 3: Environment 4: SELECT `Name`,`Value` FROM `Environment`,`Component` WHERE `Component_`=`Component` AND (`Component`.`Action` = 0) Action start 23:03:14: RemoveEnvironmentStrings. MSI (s) (D0:B4) [23:03:14:046]: Doing action: RemoveDuplicateFiles Action ended 23:03:14: RemoveEnvironmentStrings. Return value 1. Action start 23:03:14: RemoveDuplicateFiles. MSI (s) (D0:B4) [23:03:14:046]: Doing action: RemoveFiles Action ended 23:03:14: RemoveDuplicateFiles. Return value 1. MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2205 2: 3: RemoveFile MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2205 2: 3: RemoveFile Action start 23:03:14: RemoveFiles. MSI (s) (D0:B4) [23:03:14:046]: Doing action: RemoveFolders Action ended 23:03:14: RemoveFiles. Return value 0. Action start 23:03:14: RemoveFolders. MSI (s) (D0:B4) [23:03:14:046]: Doing action: CreateFolders Action ended 23:03:14: RemoveFolders. Return value 0. Action start 23:03:14: CreateFolders. MSI (s) (D0:B4) [23:03:14:046]: Doing action: MoveFiles Action ended 23:03:14: CreateFolders. Return value 0. Action start 23:03:14: MoveFiles. MSI (s) (D0:B4) [23:03:14:046]: Doing action: InstallFiles Action ended 23:03:14: MoveFiles. Return value 1. Action start 23:03:14: InstallFiles. MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2205 2: 3: Patch MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2228 2: 3: Patch 4: SELECT `Patch`.`File_`, `Patch`.`Header`, `Patch`.`Attributes`, `Patch`.`Sequence`, `Patch`.`StreamRef_` FROM `Patch` WHERE `Patch`.`File_` = ? AND `Patch`.`#_MsiActive`=? ORDER BY `Patch`.`Sequence` MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2205 2: 3: MsiPatchHeaders MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2228 2: 3: MsiPatchHeaders 4: SELECT `Header` FROM `MsiPatchHeaders` WHERE `StreamRef` = ? MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2205 2: 3: PatchPackage MSI (s) (D0:B4) [23:03:14:062]: Doing action: DuplicateFiles Action ended 23:03:14: InstallFiles. Return value 1. Action start 23:03:14: DuplicateFiles. MSI (s) (D0:B4) [23:03:14:062]: Doing action: PatchFiles Action ended 23:03:14: DuplicateFiles. Return value 1. MSI (s) (D0:B4) [23:03:14:062]: Note: 1: 2205 2: 3: Patch MSI (s) (D0:B4) [23:03:14:062]: Note: 1: 2228 2: 3: Patch 4: SELECT `File`,`FileName`,`FileSize`,`Directory_`,`PatchSize`,`File`.`Attributes`,`Patch`.`Attributes`,`Patch`.`Sequence`,`Component`.`Component`,`Component`.`ComponentId` FROM `File`,`Component`,`Patch` WHERE `Patch`.`#_MsiActive`=? AND `File`=`File_` AND `Component`=`Component_` ORDER BY `Patch`.`Sequence` Action start 23:03:14: PatchFiles. MSI (s) (D0:B4) [23:03:14:062]: Doing action: BindImage Action ended 23:03:14: PatchFiles. Return value 0. Action start 23:03:14: BindImage. MSI (s) (D0:B4) [23:03:14:062]: Doing action: RegisterClassInfo Action ended 23:03:14: BindImage. Return value 1. MSI (s) (D0:B4) [23:03:14:062]: Note: 1: 2262 2: Class 3: -2147287038 Action start 23:03:14: RegisterClassInfo. MSI (s) (D0:B4) [23:03:14:062]: Doing action: RegisterExtensionInfo Action ended 23:03:14: RegisterClassInfo. Return value 1. MSI (s) (D0:B4) [23:03:14:062]: Note: 1: 2262 2: Extension 3: -2147287038 Action start 23:03:14: RegisterExtensionInfo. MSI (s) (D0:B4) [23:03:14:062]: Doing action: RegisterProgIdInfo Action ended 23:03:14: RegisterExtensionInfo. Return value 1. MSI (s) (D0:B4) [23:03:14:062]: Note: 1: 2205 2: 3: ProgId MSI (s) (D0:B4) [23:03:14:062]: Note: 1: 2228 2: 3: ProgId 4: SELECT DISTINCT `BinaryType`, `ProgId`, `Class_`, `ProgId`.`Description`, `ProgId`.`Icon_`, `ProgId`.`IconIndex`, null, `Component`.`RuntimeFlags`, `Component`.`Component` FROM `ProgId`, `Class`, `Feature`, `Component` WHERE `ProgId`.`Class_` = `Class`.`CLSID` AND `Class`.`Feature_` = `Feature` AND `Class`.`Component_` = `Component` AND ((`Feature`.`Action` = 1 OR `Feature`.`Action` = 2) OR (`Feature`.`Action` = 4 AND `Feature`.`Installed` = 0) OR (`Feature`.`Action` = 3 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2 OR `Feature`.`Installed` = 4)) OR (`Feature`.`Action` = NULL AND (`Component`.`Action` = 1 OR `Component`.`Action` = 2) AND ((`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2 OR `Feature`.`Installed` = 4)))) Action start 23:03:14: RegisterProgIdInfo. MSI (s) (D0:B4) [23:03:14:062]: Doing action: RegisterMIMEInfo Action ended 23:03:14: RegisterProgIdInfo. Return value 0. MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2205 2: 3: MIME MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2228 2: 3: MIME 4: SELECT `BinaryType`, `ContentType`, `Extension`.`Extension`, `MIME`.`CLSID`, `Component`.`RuntimeFlags`, `Component`.`Component` FROM `MIME`, `Extension`, `Feature`, `Component` WHERE `MIME`.`Extension_` = `Extension`.`Extension` AND `Feature_` = `Feature` AND `Extension`.`Component_` = `Component` AND ((`Feature`.`Action` = 1 OR `Feature`.`Action` = 2) OR (`Feature`.`Action` = 4 AND `Feature`.`Installed` = 0) OR (`Feature`.`Action` = 3 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2 OR `Feature`.`Installed` = 4)) OR (`Feature`.`Action` = NULL AND (`Component`.`Action` = 1 OR `Component`.`Action` = 2) AND ((`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2 OR `Feature`.`Installed` = 4)))) Action start 23:03:14: RegisterMIMEInfo. MSI (s) (D0:B4) [23:03:14:078]: Doing action: WriteRegistryValues Action ended 23:03:14: RegisterMIMEInfo. Return value 0. Action start 23:03:14: WriteRegistryValues. MSI (s) (D0:B4) [23:03:14:078]: Doing action: WriteIniValues Action ended 23:03:14: WriteRegistryValues. Return value 1. MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2205 2: 3: IniFile MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2228 2: 3: IniFile 4: SELECT `FileName`,`IniFile`.`DirProperty`,`Section`,`IniFile`.`Key`,`IniFile`.`Value`,`IniFile`.`Action` FROM `IniFile`, `Component` WHERE `Component`=`Component_` AND (`Component`.`Action`=1 OR `Component`.`Action`=2) ORDER BY `FileName`,`Section` Action start 23:03:14: WriteIniValues. MSI (s) (D0:B4) [23:03:14:078]: Doing action: WriteEnvironmentStrings Action ended 23:03:14: WriteIniValues. Return value 1. MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2205 2: 3: Environment MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2228 2: 3: Environment 4: SELECT `Name`,`Value` FROM `Environment`,`Component` WHERE `Component_`=`Component` AND (`Component`.`Action` = 1 OR `Component`.`Action` = 2) Action start 23:03:14: WriteEnvironmentStrings. MSI (s) (D0:B4) [23:03:14:078]: Doing action: RegisterFonts Action ended 23:03:14: WriteEnvironmentStrings. Return value 1. MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2205 2: 3: Font MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2228 2: 3: Font 4: SELECT `FontTitle`, `FileName`, `Directory_`, `Action` From `Font`, `FileAction` Where `Font`.`File_` = `FileAction`.`File` And (`FileAction`.`Action` = 1 Or `FileAction`.`Action` = 2) ORDER BY `FileAction`.`Directory_` Action start 23:03:14: RegisterFonts. MSI (s) (D0:B4) [23:03:14:078]: Doing action: RegisterTypeLibraries Action ended 23:03:14: RegisterFonts. Return value 1. MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2262 2: TypeLib 3: -2147287038 Action start 23:03:14: RegisterTypeLibraries. MSI (s) (D0:B4) [23:03:14:078]: Doing action: SelfRegModules Action ended 23:03:14: RegisterTypeLibraries. Return value 1. MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2205 2: 3: SelfReg MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2228 2: 3: SelfReg 4: Select `FileAction`.`FileName`,`FileAction`.`Directory_`,`FileAction`.`Action`, `FileAction`.`Component_`,`SelfReg`.`File_` From `SelfReg`, `FileAction` Where `SelfReg`.`File_` = `FileAction`.`File` And (`FileAction`.`Action` = 1 OR `FileAction`.`Action` = 2) Action start 23:03:14: SelfRegModules. MSI (s) (D0:B4) [23:03:14:078]: Doing action: RegisterComPlus Action ended 23:03:14: SelfRegModules. Return value 1. MSI (s) (D0:B4) [23:03:14:093]: Note: 1: 2205 2: 3: Complus MSI (s) (D0:B4) [23:03:14:093]: Note: 1: 2228 2: 3: Complus 4: SELECT `ComponentId`, `FileName`, `Component`.`Directory_`, `ExpType`, `Component`.`Action`, `Component`.`Installed` FROM `Complus`, `Component`, `File` WHERE `Complus`.`Component_` = `Component` AND `Component`.`KeyPath` = `File`.`File` AND (`Action` = 1 OR `Action` = 2) Action start 23:03:14: RegisterComPlus. MSI (s) (D0:B4) [23:03:14:093]: Doing action: InstallServices Action ended 23:03:14: RegisterComPlus. Return value 0. MSI (s) (D0:B4) [23:03:14:093]: Detected older ServiceInstall table schema MSI (s) (D0:B4) [23:03:14:093]: Note: 1: 2205 2: 3: ServiceInstall MSI (s) (D0:B4) [23:03:14:093]: Note: 1: 2228 2: 3: ServiceInstall 4: SELECT `Name`,`DisplayName`,`ServiceType`,`StartType`,`ErrorControl`,`LoadOrderGroup`,`Dependencies`,`StartName`,`Password`,`ComponentId`,`Directory_`,`FileName`,`Arguments` FROM `ServiceInstall`, `Component`, `File` WHERE `ServiceInstall`.`Component_` = `Component`.`Component` AND (`Component`.`KeyPath` = `File`.`File`) AND (`Action` = 1 OR `Action` = 2) Action start 23:03:14: InstallServices. MSI (s) (D0:B4) [23:03:14:093]: Doing action: StartServices Action ended 23:03:14: InstallServices. Return value 1. MSI (s) (D0:B4) [23:03:14:093]: Note: 1: 2262 2: ServiceControl 3: -2147287038 Action start 23:03:14: StartServices. MSI (s) (D0:B4) [23:03:14:093]: Doing action: RegisterUser Action ended 23:03:14: StartServices. Return value 1. Action start 23:03:14: RegisterUser. MSI (s) (D0:B4) [23:03:14:093]: Doing action: RegisterProduct Action ended 23:03:14: RegisterUser. Return value 0. Action start 23:03:14: RegisterProduct. MSI (s) (D0:B4) [23:03:14:093]: Doing action: PublishComponents Action ended 23:03:14: RegisterProduct. Return value 1. MSI (s) (D0:B4) [23:03:14:093]: Note: 1: 2262 2: PublishComponent 3: -2147287038 Action start 23:03:14: PublishComponents. MSI (s) (D0:B4) [23:03:14:093]: Doing action: MsiPublishAssemblies Action ended 23:03:14: PublishComponents. Return value 1. Action start 23:03:14: MsiPublishAssemblies. MSI (s) (D0:B4) [23:03:14:109]: Doing action: PublishFeatures Action ended 23:03:14: MsiPublishAssemblies. Return value 1. Action start 23:03:14: PublishFeatures. MSI (s) (D0:B4) [23:03:14:109]: Doing action: PublishProduct Action ended 23:03:14: PublishFeatures. Return value 1. Action start 23:03:14: PublishProduct. MSI (s) (D0:B4) [23:03:14:109]: Doing action: CreateShortcuts Action ended 23:03:14: PublishProduct. Return value 1. MSI (s) (D0:B4) [23:03:14:109]: Note: 1: 2205 2: 3: Shortcut MSI (s) (D0:B4) [23:03:14:109]: Note: 1: 2228 2: 3: Shortcut 4: SELECT `Name`, `FileName`, `Component`.`Directory_`, `Arguments`, `WkDir`, `Icon_`, `IconIndex`, `Hotkey`, `ShowCmd`, `Shortcut`.`Description`, `Shortcut`.`Directory_`, `Component`.`RuntimeFlags`, `Component`.`Action`, `Target`, `ComponentId`, `Feature`.`Action`, `Component`.`Installed` From `Shortcut`, `Feature`, `Component`, `File` WHERE `Target` = `Feature` AND `Shortcut`.`Component_` = `Component` AND `Component`.`KeyPath` = `File`.`File` AND ((`Feature`.`Action` = 1 OR `Feature`.`Action` = 2) OR (`Feature`.`Action` = 4 AND `Feature`.`Installed` = 0) OR (`Feature`.`Action` = 3 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2 OR `Feature`.`Installed` = 4)) OR (`Feature`.`Action` = NULL AND (`Component`.`Action` = 1 OR `Component`.`Action` = 2) AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2 OR `Feature`.`Installed` = 4))) Action start 23:03:14: CreateShortcuts. MSI (s) (D0:B4) [23:03:14:109]: Skipping action: SNAC_SetClientSSNLDefaults.9B634CFE_9A39_4508_9CA8_D8DE65A7B8AD (condition is false) MSI (s) (D0:B4) [23:03:14:109]: Doing action: InstallFinalize Action ended 23:03:14: CreateShortcuts. Return value 0. MSI (s) (D0:B4) [23:03:14:109]: Running Script: C:WINDOWSInstallerMSIAD.tmp MSI (s) (D0:B4) [23:03:14:109]: PROPERTY CHANGE: Adding UpdateStarted property. Its value is '1'. MSI (s) (D0:B4) [23:03:14:109]: Machine policy value 'DisableRollback' is 0 MSI (s) (D0:B4) [23:03:14:125]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESoftwareMicrosoftWindowsCurrentVersionInstallerRollbackScripts 3: 2 MSI (s) (D0:B4) [23:03:14:125]: Executing op: Header(Signature=1397708873,Version=301,Timestamp=919255143,LangId=1033,Platform=0,ScriptType=1,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1) Action start 23:03:14: InstallFinalize. MSI (s) (D0:B4) [23:03:14:125]: Executing op: ProductInfo(ProductKey={F9B3DD02-B0B3-42E9-8650-030DFF0D133D},ProductName=Microsoft SQL Server Native Client,PackageName=sqlncli.msi,Language=1033,Version=150997986,Assignment=1,ObsoleteArg=0,ProductIcon=ARPIco,,PackageCode={8225F098-4183-422F-B208-3018904DFA0C},,,InstanceType=0,LUASetting=0,RemoteURTInstalls=0) MSI (s) (D0:B4) [23:03:14:125]: Executing op: DialogInfo(Type=0,Argument=1033) MSI (s) (D0:B4) [23:03:14:125]: Executing op: DialogInfo(Type=1,Argument=Microsoft SQL Server Native Client) MSI (s) (D0:B4) [23:03:14:125]: Executing op: RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: [1]) MSI (s) (D0:B4) [23:03:14:125]: Executing op: SetBaseline(Baseline=0,) MSI (s) (D0:B4) [23:03:14:125]: Executing op: SetBaseline(Baseline=1,) MSI (s) (D0:B4) [23:03:14:125]: Executing op: ActionStart(Name=ProcessComponents,Description=Updating component registration,) MSI (s) (D0:B4) [23:03:14:125]: Executing op: ProgressTotal(Total=6,Type=1,ByteEquivalent=24000) MSI (s) (D0:B4) [23:03:14:125]: Executing op: ComponentRegister(ComponentId={B26AC90F-A196-4D67-A57D-FE81C9202A2C},KeyPath=C:Program FilesMicrosoft SQL Server90SDKIncludemsmd.h,State=3,,Disk=1,SharedDllRefCount=0,BinaryType=0) MSI (s) (D0:B4) [23:03:14:140]: Executing op: ComponentRegister(ComponentId={9E91B830-1D04-4B78-9244-ACA6C7790142},KeyPath=C:Program FilesMicrosoft SQL Server90SDKIncludeoledbdm.h,State=3,,Disk=1,SharedDllRefCount=0,BinaryType=0) MSI (s) (D0:B4) [23:03:14:140]: Executing op: ComponentRegister(ComponentId={A2F6B3E4-9050-4BD3-9C29-17E05509F383},KeyPath=C:Program FilesMicrosoft SQL Server90SDKIncludesqlncli.h,State=3,,Disk=1,SharedDllRefCount=0,BinaryType=0) MSI (s) (D0:B4) [23:03:14:140]: Executing op: ComponentRegister(ComponentId={7372B29A-8237-4C56-9E27-5DB074A8AD07},KeyPath=C:Program FilesMicrosoft SQL Server90SDKIncludesrv.h,State=3,,Disk=1,SharedDllRefCount=0,BinaryType=0) MSI (s) (D0:B4) [23:03:14:140]: Executing op: ComponentRegister(ComponentId={AD0B21CC-B175-4F95-B728-2B5C6C0B65CE},KeyPath=C:Program FilesMicrosoft SQL Server90SDKLibx86sqlncli.lib,State=3,,Disk=1,SharedDllRefCount=0,BinaryType=0) MSI (s) (D0:B4) [23:03:14:140]: Executing op: ComponentRegister(ComponentId={EE67DC7C-00F8-40A3-A6EB-62F764614040},KeyPath=C:Program FilesMicrosoft SQL Server90SDKLibx86opends60.lib,State=3,,Disk=1,SharedDllRefCount=0,BinaryType=0) MSI (s) (D0:B4) [23:03:14:156]: Executing op: ActionStart(Name=InstallFiles,Description=Copying new files,Template=File: [1], Directory: [9], Size: [6]) MSI (s) (D0:B4) [23:03:14:156]: Executing op: ProgressTotal(Total=193043,Type=0,ByteEquivalent=1) MSI (s) (D0:B4) [23:03:14:156]: Executing op: SetTargetFolder(Folder=C:Program FilesMicrosoft SQL Server90SDKInclude) MSI (s) (D0:B4) [23:03:14:156]: Executing op: SetSourceFolder(Folder=1PFilesMICROS~190SDKInclude|Program FilesMicrosoft SQL Server90SDKInclude) MSI (s) (D0:B4) [23:03:14:156]: Executing op: ChangeMedia(MediaVolumeLabel=SNAC,MediaPrompt=Please insert the disk: ,MediaCabinet=snac.cab,BytesPerTick=32768,CopierType=2,ModuleFileName=1sqlncli.msi,,,,,IsFirstPhysicalMedia=1) MSI (s) (D0:B4) [23:03:14:156]: Executing op: FileCopy(Source
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 FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_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 --------------------------------------------------------------------------------
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 SOFTWAREMicrosoftMicrosoft SQL ServerMSSQL.2MSSQLServerSuperSocketNetLib 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&EvtID=29508&EvtType=sqlca%5csqlsddlca.cpp%40Do_sqlRegSDDL%40ExceptionInSDDL%40x7344
I looked in the registry, and the administrators group has full control over this key.
Digging into the SQLSETUP log file, at the end I see: ---
Configuring ACL: Object: HKLMSOFTWAREMicrosoftMicrosoft SQL ServerMSSQL.2MSSQLServerSuperSocketNetLib ACL: (A;CI;KR;;;[SQLServer2005SQLBrowserUser$NEWSERVER])(A;CI;KR;;;NS) Action: 0x100 Failed ACL: ReplaceSDDLSid is failed at the error code 1332; Converted SDDL: '(A;CI;KR;;;[SQLServer2005SQLBrowserUser$NEWSERVER])(A;CI;KR;;;NS)' Error Code: 0x80077344 (29508) Windows Error Text: Source File Name: sqlcasqlsddlca.cpp Compiler Timestamp: Tue Sep 13 01:08:29 2005 Function Name: ExceptionInSDDL Source Line Number: 65
---
Looking into AD Users+Computers, there is not a group present for SQLServer2005SQLBrowserUser$NEWSERVER but there is one for SQLServer2005SQLBrowserUser$OLDSERVER.
It appears that the install did not create the new group that was necessary..
Once I duplicated the OLDSERVER group, renaming it to have NEWSERVER, the installation completed without error.
I hope this saves someone else a few hours of pain.
I run setup using GUI. It upgrades all components of the existing installation w/out any problems except the last component. That is, it proceeds with the installation of SQL Server Database Serices and at the end fails to shut down the SQL Server and aborts the installation reporting the following:
"Service 'Computer_NameSQLEXPRESS' could not be stopped. Verify that you have sufficient privileges to stop system services. The error code is (16386)".
I am running Windows XP SP2 with both .NET 2.0 and .NET 3.0 installed on it. I am logged in as a system administrator.
The most puzzling to me things are:
- the setup starts AND STOPS w/out any problems SQL Server Reporting Services and SQL Server VSS Writer (thus finding enough privileges for both).
- the setup starts the SQL Server w/out any problems (thus it finds enough privileges to START A SYSTEM SERVICE) and then fails as described above 'lucking privileges".
During installation before failing the setup displays following:
"Run as Normal User. RANU instance Shutdwon in progress: MSSQL$SQLEXPRESS". The "normal user" puzzles me too, unless the SQL Server itself is meant here.
Any suggestions would be appreciated. I can provide the installation log file as well.
We've had this issue for awhile, but I have not been able to find a resolution for this. We have 2 identical servers (hardware & software) set-up: IBM x3850-(88633RU) running Windows Server 2003 Enterprise x64 (5.2.3790 SP1 Build 3790 R2). Server A was running SP1 (Build 9.0.2047) on a 3-node active-passive-passive failover cluster. Server B was running SP2 + Hotfix KB933097 (Build 9.0.3152) on a 2-node active-passive failover cluster. Both these servers are heavily utilized, and when originally installed with these versions of SQL Server Enterprise 2005 experienced no issues during or post-install. The original install of SQL 2005 Enterprise on both these servers had the Cluster Group Selection "Data files" setting changed to "M:MICROSOFT SQL SERVER" so that all system dbs and binaries would be installed to that location. On Server B where SP2 had already been applied, the update was downloaded on May 1, 2007, well after the GDR issues which had been plaguing SP2 releases was supposed to have been resolved.
Our problems began the night when we tried to apply hotfix KB933097 on Server A, and cumulative update packages 1,2,3 on Servers A & B, as well as catch-up the same SP2 and hotfix packages on other non-clustered servers where default system db locations remained the same. On all servers other than Servers A and B, the installs proceeded smoothly and without issue.
On Server B, which was already running SP2 + Hotfix KB933097, we tried installing Cumulative Update Package 1 (Build 9.0.3161) on the primary node. The install proceeded until the following errors were encountered:
"[Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission."
"[Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_memory_grants', because it does not exist or you do not have permission."
After this, the setup finished with the message "Product: Microsoft SQL Server 2005 (64-bit) - Update 'Hotfix 3161 for SQL Server Database Services 2005 (64-bit) ENU (KB935356)' could not be installed. Error code 1603. Additional information is available in the log file C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB935356_sqlrun_sql.msp.log."
We rebooted the server and tried several times to reinstall the hotfix as sa and as the database service account with full windows and sa credentials, each time with no success, and rebooting between retries. All other components were installed successfully. We were hesitant to try uninstalling the hotfix, since it was unable to be removed successfully in previous attempts. However, when I connected to Database Engine using Management Studio, I found that the version of SQL being reported was in fact Build 9.0.3161! Everything also appeared to be running properly.
I tried to to Google the answer, but could only find information as applied to SP1 when system dbs master and mssqlsystemresource were located on different locations (http://support.microsoft.com/default.aspx?scid=kb;EN-US;918695 ). I had already verified that all system dbs, including the ones mentioned, were originally and currently located together on M:Microsoft SQL ServerMSSQL.1MSSQLData.
Finally I contacted a fellow DBA who advised me to continue installing all the other hotfixes, and then compare all SQL files against other servers where the install succeeded to ensure all system files were updated correctly (matching file sizes and datetime stamps). Since we were depending on a fix in Cumulative Update Package 3 to fix a critical log-shipping security issue, I went ahead with the rest of the installs, getting the same error with each package, rebooting between each install.
We found after the final install that the mssqlsystemresource files in the M:Microsoft SQL ServerMSSQL.1MSSQLData
directory were in fact updated after each install with a new timestamp, and that all files in C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn matched on both file size and timestamp. The log-shipping security issue we were looking to fix also appeared to be resolved by the last update.
On Server A, which was running SP1 (Build 9.0.2047), we installed the same SP2 package as we had on Server B with no issue. We rebooted and then tried to apply the same Hotfix KB933097 (Build 9.0.3152) that had been applied successfully on Server B and found to our surprise that the same errors were being generated here as well. We continued to apply the rest of the hotfixes so that both servers matched software updates. Comparing the above directories showed that files seemed to have been updated, even though database services appeared to be not installed.
It looks like we now need Cumulative Update 5 hotfix package in order to deal with WMI alerting issues, but I'm afraid to apply it until we have a known resolution for the past errors.
Since this issue was supposed to be resolved by SP2, I'm not sure why these post-SP2 hotfixes should fail. It seems to me to be an issue of the directory location of the system files which is in question.
I can post the hotfix log files as well, if anyone is interested in seeing them.
Any help would be greatly appreciated. As well, does anyone have any idea when SP3 is scheduled to come out? I really don't like applying hotfixes which are usually untested for general purposes, and it seems Microsoft is delaying this in favour of releasing SQL 2008.
We're trying to use the unattended installation method for installing SQL 2000 on Windows 2000 servers. I've installed it (through terminal server) on two machines successfully, and two machines unsuccessfully. On the unsuccessful machines, it fails with no errors, and no SQL files are installed (bombs out almost immediately).
Anyone else had this problem? Could it possibly be a hardware issue?
Using an unattended file (.iss) is there a way to incorporate the SP3 (or any) patch within an .iss file so that there is only only install that incorporates the patch?
I am trying to upgrade an MSDE 1.0 db with the Service Pack 4 patch but I need to do either a Silent or Unattended install. Does anyone know how to do this? Does anyone know the command-line command to do this?
I tried using...
sql70sp4.exe -a -f1 "unattend.iss"
....but that didn't work. It popped up a window asking where I should extract the contents of the .exe (that shouldn't be appearing either) and then after it extracted it didn't do anything else.