Re: unexpected failure during the setup - help!

Dear Randy and Frank,

I have not received any responses from you lately, and I am just wondering
if the issue has been resolved. Please let me know if there is anything
that I can do for you. I look forward to hearing from you. :-)

Have a nice day!

Best regards,

Adams Qu, MCSE, MCDBA, MCTS
Microsoft Online Support

Microsoft Global Technical Support Center

Get Secure! - www.microsoft.com/security
=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.



--------------------
| X-Tomcat-ID: 168499505
| References: <ePrp9Z43HHA.2108@xxxxxxxxxxxxxxxxxxxx>
<t$joil93HHA.5204@xxxxxxxxxxxxxxxxxxxxxx>
<3dj2kc54HHA.5608@xxxxxxxxxxxxxxxxxxxxxx>
<#9vl3tP5HHA.2108@xxxxxxxxxxxxxxxxxxxx>
<MwhjakW5HHA.360@xxxxxxxxxxxxxxxxxxxxxx>
<uj2TGOY6HHA.4880@xxxxxxxxxxxxxxxxxxxx>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: v-adamqu@xxxxxxxxxxxxxxxxxxxx (Adams Qu [MSFT])
| Organization: Microsoft
| Date: Wed, 29 Aug 2007 12:56:20 GMT
| Subject: Re: unexpected failure during the setup - help!
| X-Tomcat-NG: microsoft.public.sqlserver.setup
| Message-ID: <BHCiEwj6HHA.360@xxxxxxxxxxxxxxxxxxxxxx>
| Newsgroups: microsoft.public.sqlserver.setup
| Lines: 428
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.setup:2833
| NNTP-Posting-Host: tomcatimport2.phx.gbl 10.201.218.182
|
| Dear Randy,
|
| Thank you for your reply.
|
| We have checked a lot of settings about WMI. The current issue appears to
| be caused by some other different causes. If the issue is urgent to your
| business, it is recommended that you contact Microsoft Customer Service
and
| Support (CSS) via telephone so that a dedicated Support Professional can
| assist you in resolving the issue in a more efficient manner. Please be
| advised that contacting phone support will be a charged call.
|
| To obtain the phone numbers for specific technology request please take a
| look at the web site listed below.
| http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS
|
| If you would like to work on this issue in the newsgroup, I am still glad
| to help.
|
| Before moving on, could you please let me know whether there is a
| standalone SQL instance installed on the Passive Node?
|
| We have previously used the "wbemtest" utility to test the WMI function
and
| we are able to do the WMI query successfully. So, it appears that the
issue
| is not caused by that the WMI query function fails to call by the system.
|
| I have performed the further research for you and this time I suggest we
| take the following suggestions to see if we are able to make some
progress:
|
| Step 1: Install the latest update 917805
| ====================================
| Please first install the update 917805 to update the component
Cluswmi.dll
| to the latest version. The update is available in the following KB
article:
|
| The Wmiprvse.exe process consumes an ever-increasing amount of memory
when
| you enumerate the MSCluster_ResourceToPossibleOwner class on a Windows
| Server 2003-based server cluster
| http://support.microsoft.com/?id=917805
|
| Step 2: Set the permission setting
| ==================================
| Please open the Registry Editor and then grant the "Local Service" and
the
| "Network Service" full control permission for the following two registry
| entries.
|
|
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurePipeServers\winreg
|
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurePipeServers\winreg
| \Allowed
|
| Step 3: Run the script to register all the WMI components
| ===============================
| 1. Click Start, Run, type: notepad C:\register.bat and press Enter.
| 2. Copy the following commands and then paste them into the opened
Notepad
| window.
|
| regsvr32 wbemsvc.dll
| net stop winmgmt
| cd /d %windir%\system32\wbem
| for %%i in (*.dll) do RegSvr32 -s %%i
| scrcons.exe /RegServer
| unsecapp.exe /RegServer
| winmgmt.exe /RegServer
| wmiadap.exe /RegServer
| wmiapsrv.exe /RegServer
| wmiprvse.exe /RegServer
| net start winmgmt
|
| 3. After you paste the above commands, please close the Notepad window.
| Choose Yes when you are prompted to save the file.
| 4. Click Start, Run, type: C:\register.bat and press Enter to run the
| commands we have pasted.
|
| After that, please launch the SQL Server setup to test the issue again.
|
| If the issue still persists, let's try to run the MSI file SqlRun_DTS.MSI
| to install the SSIS directly.
|
| SqlRun_DTS.MSI can be found at <SQL Server setup path>:\Sever\Setup
folder.
|
| Have a nice day!
|
| Best regards,
|
| Adams Qu, MCSE, MCDBA, MCTS
| Microsoft Online Support
|
| Microsoft Global Technical Support Center
|
| Get Secure! - www.microsoft.com/security
| =====================================================
| When responding to posts, please "Reply to Group" via your newsreader so
| that others may learn and benefit from your issue.
| =====================================================
| This posting is provided "AS IS" with no warranties, and confers no
rights.
|
|
|
| --------------------
| | From: "RCB" <me@xxxxxxx>
| | References: <ePrp9Z43HHA.2108@xxxxxxxxxxxxxxxxxxxx>
| <t$joil93HHA.5204@xxxxxxxxxxxxxxxxxxxxxx>
| <3dj2kc54HHA.5608@xxxxxxxxxxxxxxxxxxxxxx>
| <#9vl3tP5HHA.2108@xxxxxxxxxxxxxxxxxxxx>
| <MwhjakW5HHA.360@xxxxxxxxxxxxxxxxxxxxxx>
| | Subject: Re: unexpected failure during the setup - help!
| | Date: Tue, 28 Aug 2007 09:55:39 -0500
| | Lines: 338
| | X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
| | X-RFC2646: Format=Flowed; Original
| | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
| | Message-ID: <uj2TGOY6HHA.4880@xxxxxxxxxxxxxxxxxxxx>
| | Newsgroups: microsoft.public.sqlserver.setup
| | NNTP-Posting-Host: assocfw1.ms.acxiom.com 206.66.66.1
| | Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
| | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.setup:2826
| | X-Tomcat-NG: microsoft.public.sqlserver.setup
| |
| | Adams,
| |
| | 1. The "Remote Registry Service" is running on both nodes of the
cluster.
| |
| | 2. I executed the "wbemtest" from the passive node of the cluster, all
| tests
| | completed successfully with NO errors.
| |
| | 3. SSIS is installed on the active node and has been added as a
resource
| in
| | the SQL cluster group.
| |
| | Thanks,
| | Randy
| |
| |
| | "Adams Qu [MSFT]" <v-adamqu@xxxxxxxxxxxxxxxxxxxx> wrote in message
| | news:MwhjakW5HHA.360@xxxxxxxxxxxxxxxxxxxxxxxxx
| | > Dear Randy,
| | >
| | > Thank you for posting back.
| | >
| | > I have conducted a lot of research in the log files and I suggest we
| check
| | > the following settings:
| | >
| | > 1. Please ensure that the "Remote Registry Service" is currently
| running
| | > in
| | > the services.msc on both nodes. If the "Remote Registry Service" is
| | > actually disabled on any of the nodes, please re-enable this service
and
| | > then re-run the SQL setup.
| | >
| | > 2. If the Remote Registry Service is configured correctly, let's use
the
| | > "wbemtest" utility to do the WMI test to ensure that the WMI query is
| able
| | > to perform successfully. To do so, please refer to the following
steps:
| | > -------------------------
| | > a. Click Start->Run, type: "wbemtest" in the Start Search bar and then
| | > press Enter.
| | > b. Click "Connect¡­"
| | > c. Type "root\cimv2" as Namespace to connect to WMI on the local
server.
| | > d. Click "Connect" in new dialog
| | > e. Click "Query¡­"
| | > f. Type "select * from CIM_OperatingSystem" under "Enter Query" and
| | > g. Click "Apply". Please check if the query can be successful.
| | > h. Since this a SQL Cluster setup, setup may have been trying to WMI
on
| | > remote nodes as well, so also use "\\<remote_node_name>\root\cimv2"
for
| | > the
| | > Namespace and do the query again.
| | >
| | > If any error message appears, please help me to capture a screenshots.
| | >
| | > How to capture a Screenshot:
| | > -------------------------
| | > 1. When the error appears, please press the Print Screen key (PrtScn)
on
| | > your keyboard.
| | > 2. Click Start, click Run, type MSPAINT, and click OK.
| | > 3. In Paint, click Paste under the Edit Menu, click Sa ve under the
File
| | > menu, type a file name for the snap shot, choose JPEG as "Save as
type",
| | > click "Desktop" on the left pane, and click Save.
| | > 4. Please find the screenshot on the Desktop and send it as an
| attachment
| | > to: v-adamqu@xxxxxxxxxxxxx
| | >
| | > 3. Please also let me know whether there is a standalone SQL instance
on
| | > failing node, and whether the SSIS is installed on the Active Node.
| | >
| | > Have a nice day!
| | >
| | > Best regards,
| | >
| | > Adams Qu, MCSE, MCDBA, MCTS
| | > Microsoft Online Support
| | >
| | > Microsoft Global Technical Support Center
| | >
| | > Get Secure! - www.microsoft.com/security
| | > =====================================================
| | > When responding to posts, please "Reply to Group" via your newsreader
so
| | > that others may learn and benefit from your issue.
| | > =====================================================
| | > This posting is provided "AS IS" with no warranties, and confers no
| | > rights.
| | >
| | > --------------------
| | > | From: "RCB" <me@xxxxxxx>
| | > | References: <ePrp9Z43HHA.2108@xxxxxxxxxxxxxxxxxxxx>
| | > <t$joil93HHA.5204@xxxxxxxxxxxxxxxxxxxxxx>
| | > <3dj2kc54HHA.5608@xxxxxxxxxxxxxxxxxxxxxx>
| | > | Subject: Re: unexpected failure during the setup - help!
| | > | Date: Wed, 22 Aug 2007 15:31:37 -0500
| | > | Lines: 953
| | > | X-Priority: 3
| | > | X-MSMail-Priority: Normal
| | > | X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
| | > | X-RFC2646: Format=Flowed; Original
| | > | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
| | > | Message-ID: <#9vl3tP5HHA.2108@xxxxxxxxxxxxxxxxxxxx>
| | > | Newsgroups: microsoft.public.sqlserver.setup
| | > | NNTP-Posting-Host: assocfw1.ms.acxiom.com 206.66.66.1
| | > | Path:
TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP02.phx.gbl
| | > | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.setup:2776
| | > | X-Tomcat-NG: microsoft.public.sqlserver.setup
| | > |
| | > | Adams,
| | > |
| | > | I work with Frank and have been working on this issue.
| | > |
| | > | We executed the 4 commands you recommended, they were all
successful,
| | > | however the install Failed again.
| | > |
| | > | > Mofcomp.exe %windir%\system32\wbem\cimwin32.mof
| | > |
| | > | > Regsvr32 %windir%\system32\wbem\wbemupgd.dll
| | > |
| | > | > Regsvr32 %windir%\system32\wbemwbemsvc.dll wmiprvse /regserver
| | > |
| | > | File and Print Sharing is enabled.
| | > |
| | > |
| | > |
| | > | I will also forward the log Files to you at (v-adamqu@xxxxxxxxxxxxx)
| | > email
| | > | address.
| | > |
| | > | Please look for my email.
| | > |
| | > | Randy
| | > |
| | > |
| | > |
| | > | "Adams Qu [MSFT]" <v-adamqu@xxxxxxxxxxxxxxxxxxxx> wrote in message
| | > | news:3dj2kc54HHA.5608@xxxxxxxxxxxxxxxxxxxxxxxxx
| | > | > Dear Frank,
| | > | >
| | > | > How's everything going?
| | > | >
| | > | > I'm wondering if the suggestion has helped or if you have any
| further
| | > | > questions. Please feel free to respond to the newsgroups if you
| need
| | > any
| | > | > additional help.
| | > | >
| | > | > Have a nice day!
| | > | >
| | > | > Best regards,
| | > | >
| | > | > Adams Qu, MCSE, MCDBA, MCTS
| | > | > Microsoft Online Support
| | > | >
| | > | > Microsoft Global Technical Support Center
| | > | >
| | > | > Get Secure! - www.microsoft.com/security
| | > | > =====================================================
| | > | > When responding to posts, please "Reply to Group" via your
| newsreader
| | > so
| | > | > that others may learn and benefit from your issue.
| | > | > =====================================================
| | > | > This posting is provided "AS IS" with no warranties, and confers
no
| | > | > rights.
| | > | >
| | > | >
| | > | >
| | > | > --------------------
| | > | > | X-Tomcat-ID: 75962660
| | > | > | References: <ePrp9Z43HHA.2108@xxxxxxxxxxxxxxxxxxxx>
| | > | > | MIME-Version: 1.0
| | > | > | Content-Type: text/plain
| | > | > | Content-Transfer-Encoding: 7bit
| | > | > | From: v-adamqu@xxxxxxxxxxxxxxxxxxxx (Adams Qu [MSFT])
| | > | > | Organization: Microsoft
| | > | > | Date: Thu, 16 Aug 2007 07:45:12 GMT
| | > | > | Subject: RE: unexpected failure during the setup - help!
| | > | > | X-Tomcat-NG: microsoft.public.sqlserver.setup
| | > | > | Message-ID: <t$joil93HHA.5204@xxxxxxxxxxxxxxxxxxxxxx>
| | > | > | Newsgroups: microsoft.public.sqlserver.setup
| | > | > | Lines: 110
| | > | > | Path: TK2MSFTNGHUB02.phx.gbl
| | > | > | Xref: TK2MSFTNGHUB02.phx.gbl
microsoft.public.sqlserver.setup:2733
| | > | > | NNTP-Posting-Host: TOMCATIMPORT1 10.201.218.122
| | > | > |
| | > | > | Dear Frank,
| | > | > |
| | > | > | Thank you for posting here.
| | > | > |
| | > | > | From the problem description of the post you submitted, my
| | > understanding
| | > | > | is: we cannot get past the discovery portion of the SQL Server
| | > | > installation
| | > | > | on the Passive Node. If I have misunderstood about your
concern,
| | > feel
| | > | > free
| | > | > | to let me know.
| | > | > |
| | > | > | From the provided error message, I found that we have received
the
| | > error
| | > | > | code "-2147217389". Based on my research, this is a WMI error
and
| | > the
| | > | > error
| | > | > | code "-2147217389" (0x80041013) means
| | > "WBEM_E_PROVIDER_LOAD_FAILURE".
| | > At
| | > | > | this point, I suggest we try the following steps on the Passive
| Node
| | > to
| | > | > the
| | > | > | troubleshooting.
| | > | > |
| | > | > | 1. Click Start->Run, type: CMD in the Run box and then press
| Enter
| | > to
| | > | > open
| | > | > | the command prompt.
| | > | > | 2. In the open command prompt, please run the following
commands
| one
| | > by
| | > | > one
| | > | > | in and then press Enter..
| | > | > |
| | > | > | Mofcomp.exe %windir%\system32\wbem\cimwin32.mof
| | > | > | Regsvr32 %windir%\system32\wbem\wbemupgd.dll
| | > | > | Regsvr32 %windir%\system32\wbemwbemsvc.dll
| | > | > | wmiprvse /regserver
| | > | > |
| | > | > | 3. If above components are able to register successfully,
| | > | > |
| | > | > | In addition, please also ensure that the "File and Printer
| Sharing
| | > for
| | > | > | Microsoft Networks" component is installed and enabled:
| | > | > |
| | > | > | Control Panel => Network Connections => Local Area Connection =>
| | > | > Properties
| | > | > | => File and Printer Sharing for Microsoft Networks
| | > | > |
| | > | > | However, if the Client tools still fail to install, please send
| the
| | > | > | following log files to me at v-adamqu@xxxxxxxxxxxxx
| | > | > |
| | > | > | %ProgramFiles%\Microsoft SQL Server\90\Setup
| | > Bootstrap\LOG\Summary.txt
| | > | > | %ProgramFiles%\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files
| | > (all
| | > | > the
| | > | > | log files in it)
| | > | > |
| | > | > | If anything is unclear in my post, please don't hesitate to let
me
| | > know
| | > | > and
| | > | > | I will be glad to help. Thank you for your efforts and time.
| | > | > |
| | > | > | Have a nice day!
| | > | > |
| | > | > | Best regards,
| | > | > |
| | > | > | Adams Qu
| | > | > | MCSE, MCDBA, MCTS
| | > | > | Microsoft Online Support
| | > | > |
| | > | > | Microsoft Global Technical Support Center
| | > | > |
| | > | > | Get Secure! - www.microsoft.com/security
| | > | > | =====================================================
| | > | > | When responding to posts, please "Reply to Group" via your
| | > newsreader
| | > so
| | > | > | that others may learn and benefit from your issue.
| | > | > | =====================================================
| | > | > | This posting is provided "AS IS" with no warranties, and
confers
| no
| | > | > rights.
| | > | > |
| | > | > |
| | > | > | --------------------
| | > | > | | From: "frankm" <frankm@xxxxxxxxxxxxxxxx>
| | > | > | | Subject: unexpected failure during the setup - help!
| | > | > | | Date: Wed, 15 Aug 2007 16:51:50 -0500
| | > | > | | Lines: 39
| | > | > | | X-Priority: 3
| | > | > | | X-MSMail-Priority: Normal
| | > | > | | X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
| | > | > | | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
| | > | > | | X-RFC2646: Format=Flowed; Original
| | > | > | | Message-ID: <ePrp9Z43HHA.2108@xxxxxxxxxxxxxxxxxxxx>
| | > | > | | Newsgroups: microsoft.public.sqlserver.setup
| | > | > | | NNTP-Posting-Host: assocfw1.ms.acxiom.com 206.66.66.1
| | > | > | | Path:
| | > TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP02.phx.gbl
| | > | > | | Xref: TK2MSFTNGHUB02.phx.gbl
| microsoft.public.sqlserver.setup:2726
| | > | > | | X-Tomcat-NG: microsoft.public.sqlserver.setup
| | > | > | |
| | > | > | | We are trying to install integration services after the fact
of
| | > the
| | > | > | passive
| | > | > | | node of a w2k3 cluster.
| | > | > | |
| | > | > | | We have tried the copy to a local drive and setup the
[servers]
| | > and
| | > | > | [tools]
| | > | > | | directories, yet we still can't get past the discovery
portion
| of
| | > the
| | > | > | | install.
| | > | > | |
| | > | > | | Run setup.exe, received the following error message window..
| | > | > | | "There was an unexpected failure during the setup wizard. You
| may
| | > | > review
| | > | > | the
| | > | > | | setuplogs and/or click
| | > | > | | the Help button for more information
| | > | > | |
| | > | > | | SQL Server 2005 Standard 9.00.3042
| | > | > | | Windows 2003 (Build 3790.srv03_sp2_rtm.070216-1710 : Service
| Pack
| | > 2)
| | > | > | |
| | > | > | | SQL Server has 1 virtual server installed.
| | > | > | |
| | > | > | | Details:
| | > | > | |
| | > | > | | Link ID 20476
| | > | > | | Product Name Microsoft SQL Server
| | > | > | | Product Version 9.00.3042.00
| | > | > | | Message Source setup.rll
| | > | > | | Message ID 50000
| | > | > | | EvtType sqldiscovery\discoveryengine cpp@i
| | > | > | |
| | > | > | | Summary Log:
| | > | > | |
| | > | > | | Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup
| | > | > | | Bootstrap\sqlsval.dll Version:2005.90.3042.0
| | > | > | | Error: Action "InvokeSqlSetupDllAction" threw an exception
| during
| | > | > | execution.
| | > | > | | WinException : -2147217389
| | > | > | | Error Code: -2147217389
| | > | > | | Windows Error Text: Source File Name:
| | > | > sqldiscovery\discoveryengine.cpp
| | > | > | | Compiler Timestamp: Wed Jun 14 16:28:21 2006
| | > | > | | Function Name: CDiscoveryEngine::CIM_OperatingSystemProc
| | > | > | | Source Line Number: 201
| | > | > | |
| | > | > | |
| | > | > | |
| | > | > |
| | > | > |
| | > | >
| | > |
| | > |
| | > |
| | >
| |
| |
| |
|
|

.

Loading