[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

8.2

Installing SQL Server 2008 64-bit on Windows Server 2008 64-bit

Asked by DaMule in SQL Server 2008, Windows Server 2008, VMware

Tags: Microsoft, SQL Server, 2008, Windows 2008 on VMware 3.5 Update 2 64-bit

I am trying to upgrade a SQL Server 2005 Standard x64 instance running on Windows Server 2008 Enterprise x64 running on VMware ESX 3.5 Update 2. At first I thought it was a bad ISO and so redownloaded the media to no effect. The installer returns all green check marks with no warnings. It proceeds into the install but when it get to Install_SqlSqmShared_Cpu64_Action it get the following message about 20 times:
TITLE: Microsoft SQL Server 2008 Setup
------------------------------
The following error has occurred:
 
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.1600.22&EvtType=0xDF039760%25401201%25401
------------------------------
BUTTONS:
OK
------------------------------
*********************************************
The only way I can kill the install is by ending the task. It creates a Dr Watson folder every time the error appears. Below is the detail text of the Install_SqlSqmShared_Cpu64 log:
=== Verbose logging started: 9/12/2008  9:32:13  Build type: SHIP UNICODE 4.05.6001.00  Calling process: C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release\x64\setup100.exe ===
MSI (c) (74:58) [09:32:13:057]: Resetting cached policy values
MSI (c) (74:58) [09:32:13:057]: Machine policy value 'Debug' is 0
MSI (c) (74:58) [09:32:13:057]: ******* RunEngine:
           ******* Product: D:\x64\setup\sqlsqm.msi
           ******* Action:
           ******* CommandLine: **********
MSI (c) (74:58) [09:32:13:057]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (74:58) [09:32:13:057]: Grabbed execution mutex.
MSI (c) (74:58) [09:32:13:057]: Cloaking enabled.
MSI (c) (74:58) [09:32:13:057]: Attempting to enable all disabled privileges before calling Install on Server
MSI (c) (74:58) [09:32:13:057]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (644) [09:32:13:072]: Running installation inside multi-package transaction D:\x64\setup\sqlsqm.msi
MSI (s) (644) [09:32:13:072]: Grabbed execution mutex.
MSI (s) (64:58) [09:32:13:072]: Resetting cached policy values
MSI (s) (64:58) [09:32:13:072]: Machine policy value 'Debug' is 0
MSI (s) (64:58) [09:32:13:072]: ******* RunEngine:
           ******* Product: D:\x64\setup\sqlsqm.msi
           ******* Action:
           ******* CommandLine: **********
MSI (s) (64:58) [09:32:13:088]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (64:58) [09:32:13:103]: SRSetRestorePoint skipped for this transaction.
MSI (s) (64:58) [09:32:13:103]: File will have security applied from OpCode.
MSI (s) (64:58) [09:32:13:166]: SOFTWARE RESTRICTION POLICY: Verifying package --> 'D:\x64\setup\sqlsqm.msi' against software restriction policy
MSI (s) (64:58) [09:32:13:166]: SOFTWARE RESTRICTION POLICY: D:\x64\setup\sqlsqm.msi has a digital signature
MSI (s) (64:58) [09:32:13:197]: SOFTWARE RESTRICTION POLICY: D:\x64\setup\sqlsqm.msi is permitted to run at the 'unrestricted' authorization level.
MSI (s) (64:58) [09:32:13:197]: End dialog not enabled
MSI (s) (64:58) [09:32:13:197]: Original package ==> D:\x64\setup\sqlsqm.msi
MSI (s) (64:58) [09:32:13:197]: Package we're running from ==> C:\Windows\Installer\8baae2e.msi
MSI (s) (64:58) [09:32:13:197]: APPCOMPAT: looking for appcompat database entry with ProductCode '{2F14965D-567B-4E59-ADEB-0A2CC1E3ADDF}'.
MSI (s) (64:58) [09:32:13:197]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (64:58) [09:32:13:197]: MSCOREE already loaded, using loaded copy
MSI (s) (64:58) [09:32:13:197]: Machine policy value 'TransformsSecure' is 1
MSI (s) (64:58) [09:32:13:197]: Note: 1: 2205 2:  3: MsiFileHash
MSI (s) (64:58) [09:32:13:197]: Machine policy value 'DisablePatch' is 0
MSI (s) (64:58) [09:32:13:197]: Machine policy value 'AllowLockdownPatch' is 0
MSI (s) (64:58) [09:32:13:197]: Machine policy value 'DisableLUAPatching' is 0
MSI (s) (64:58) [09:32:13:197]: Machine policy value 'DisableFlyWeightPatching' is 0
MSI (s) (64:58) [09:32:13:213]: APPCOMPAT: looking for appcompat database entry with ProductCode '{2F14965D-567B-4E59-ADEB-0A2CC1E3ADDF}'.
MSI (s) (64:58) [09:32:13:213]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (64:58) [09:32:13:213]: Transforms are not secure.
MSI (s) (64:58) [09:32:13:213]: PROPERTY CHANGE: Adding MsiLogFileLocation property. Its value is 'C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20080912_082529\SqlSqmShared_Cpu64_1.log'.
MSI (s) (64:58) [09:32:13:213]: Command Line: EXTERNALMSICONTROL=1 ADDLOCAL=SQM_SHARED REBOOT=ReallySuppress CURRENTDIRECTORY=D:\ CLIENTUILEVEL=3 MSICLIENTUSESEXTERNALUI=1 CLIENTPROCESSID=4724 CURRENTMEDIAVOLUMELABEL=SQLFULL_ENU
MSI (s) (64:58) [09:32:13:213]: PROPERTY CHANGE: Adding PackageCode property. Its value is '{6C45483C-FDF8-4F6A-ACDD-A16D5CE66DBE}'.
MSI (s) (64:58) [09:32:13:213]: Product Code passed to Engine.Initialize:           ''
MSI (s) (64:58) [09:32:13:213]: Product Code from property table before transforms: '{2F14965D-567B-4E59-ADEB-0A2CC1E3ADDF}'
MSI (s) (64:58) [09:32:13:213]: Product Code from property table after transforms:  '{2F14965D-567B-4E59-ADEB-0A2CC1E3ADDF}'
MSI (s) (64:58) [09:32:13:213]: Product not registered: beginning first-time install
MSI (s) (64:58) [09:32:13:213]: Product {2F14965D-567B-4E59-ADEB-0A2CC1E3ADDF} is not managed.
MSI (s) (64:58) [09:32:13:213]: MSI_LUA: Credential prompt not required, user is an admin
MSI (s) (64:58) [09:32:13:213]: PROPERTY CHANGE: Adding ProductState property. Its value is '-1'.
MSI (s) (64:58) [09:32:13:213]: Entering CMsiConfigurationManager:etLastUsedSource.
MSI (s) (64:58) [09:32:13:213]: User policy value 'DisableMedia' is 0
MSI (s) (64:58) [09:32:13:213]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (64:58) [09:32:13:213]: Adding new sources is allowed.
MSI (s) (64:58) [09:32:13:213]: PROPERTY CHANGE: Adding PackagecodeChanging property. Its value is '1'.
MSI (s) (64:58) [09:32:13:213]: Package name extracted from package path: 'sqlsqm.msi'
MSI (s) (64:58) [09:32:13:213]: Package to be registered: 'sqlsqm.msi'
Unexpected Termination
*********************************************
Any help is truly appreciated...
[+][-]09/18/08 10:55 AM, ID: 22513517Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09/19/08 08:55 AM, ID: 22522553Author Comment

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 30-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09/20/08 09:02 AM, ID: 22530299Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]10/01/08 05:06 AM, ID: 22613345Accepted Solution

View this solution now by starting your 30-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

About this solution

Zones: SQL Server 2008, Windows Server 2008, VMware
Tags: Microsoft, SQL Server, 2008, Windows 2008 on VMware 3.5 Update 2 64-bit
Sign Up Now!
Solution Provided By: DaMule
Participating Experts: 1
Solution Grade: A
 
 
Loading Advertisement...
20091111-EE-VQP-89 / EE_QW_2_20070628