xp cmdshell: x64

Showing posts with label x64. Show all posts

Saturday, February 25, 2012

Problem installing SP2 on active-passive x64 cluster

I just tried to apply SQL 2005 Std SP2 on a cluster, and all succeeded except for the Database Services. I've looked about and can't see any specific information for this. The Summary.Txt is below. I thought I was following the appropriate steps, according to the SP2 Readme.

Thanks for any help. (I'm at the client today)

Bob Coppedge

me at RLCoppedge dot com

Time: 04/04/2007 10:55:44.249
KB Number: KB921896
Machine: SQL01
OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 1 (Build 3790)
Package Language: 1033 (ENU)
Package Platform: x64
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: Yes
Log Location on Passive Nodes:
(SQL01) C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
(SQL02) C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
Setup Support Files ENU 9.1.2047 x64
Database Services (MSSQLSERVER) ENU RTM 2005.090.1399.00 x64 STANDARD
Notification Services ENU SP1 9.00.2047.00 x64 STANDARD
Integration Services ENU SP1 9.00.2047.00 x64 STANDARD
SQL Server Native Client ENU 9.00.2047.00 x64
Client Components ENU SP1 9.1.2047 x64 STANDARD
MSXML 6.0 Parser ENU 6.00.3890.0 x64
SQLXML4 ENU 9.00.2047.00 x64
Backward Compatibility ENU 8.05.1704 x64
Microsoft SQL Server VSS Writer ENU 9.00.2047.00 x64

**********************************************************************************
Products Disqualified & Reason
Product Reason

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID

**********************************************************************************
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SqlSupport.msi.log
Error Number : 0
Error Description :
-
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File :
Error Number : 11009
Error Description : No passive nodes were successfully patched
-
Product : Notification Services
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\NS9_Hotfix_KB921896_sqlrun_ns.msp.log
Error Number : 3010
Error Description :
-
Product : Integration Services
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\DTS9_Hotfix_KB921896_sqlrun_dts.msp.log
Error Number : 0
Error Description :
-
Product : SQL Server Native Client
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_sqlncli.msi.log
Error Number : 3010
Error Description :
-
Product : Client Components
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Reboot Required
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log
Error Number : 3010
Error Description :
-
Product : MSXML 6.0 Parser
Product Version (Previous): 3890
Product Version (Final) : 6.10.1129.0
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_msxml6.msi.log
Error Number : 0
Error Description :
-
Product : SQLXML4
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_sqlxml4.msi.log
Error Number : 0
Error Description :
-
Product : Backward Compatibility
Product Version (Previous): 1704
Product Version (Final) : 2004
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SQLServer2005_BC.msi.log
Error Number : 0
Error Description :
-
Product : Microsoft SQL Server VSS Writer
Product Version (Previous): 2047
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SqlWriter.msi.log
Error Number : 0
Error Description :
-

**********************************************************************************
Summary
No passive nodes were successfully patched
Exit Code Returned: 11009

Hey Bob,

Check out this KB Article: http://support.microsoft.com/kb/929151

It references a slightly different error number, but the error messages appear to be the same.

Eric

|||

Thanks for the information. That actually led to the solution. It turns out that the log on the passive node held the answer. The system couldn't add the account to the AD group. Now, why it couldn't I don't know (the account had rights to change membership to the group), but I had to run the SP2 installation using Domain Admin rights. Once I did that, life was good.

Thanks again for the lead!

Bob

|||

Glad to help out and glad you got it working!

Eric

|||

I had the same problem, even though it was on the active node, and with a 32-bit cluster. The fix was to add the account that SQL Server was running under into the Domain Admins Group. Then it installed, then I removed that user from the Domain Admins group.

Thanks

|||

I followed the fix above and it fixed my problem. I running 2k3enterprise with sql2005entx64. I had to add the virtual network name to lmhosts and enable netbios(and lmhosts) on the public nic of each node(two node cluster). Will we ever turn off netbios?

Thanks to the above users for the good links...(Eric)

Forrest

Problem installing SP2 on active-passive x64 cluster

Thanks for any help. (I'm at the client today)

Bob Coppedge

me at RLCoppedge dot com

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Disqualified & Reason
Product Reason

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID

**********************************************************************************
Summary
No passive nodes were successfully patched
Exit Code Returned: 11009

Hey Bob,

Check out this KB Article: http://support.microsoft.com/kb/929151

It references a slightly different error number, but the error messages appear to be the same.

Eric

|||

Thanks again for the lead!

Bob

|||

Glad to help out and glad you got it working!

Eric

|||

Thanks

|||

Thanks to the above users for the good links...(Eric)

Forrest

Problem installing SP2 on active-passive x64 cluster

Thanks for any help. (I'm at the client today)

Bob Coppedge

me at RLCoppedge dot com

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Disqualified & Reason
Product Reason

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID

**********************************************************************************
Summary
No passive nodes were successfully patched
Exit Code Returned: 11009

Hey Bob,

Check out this KB Article: http://support.microsoft.com/kb/929151

It references a slightly different error number, but the error messages appear to be the same.

Eric

|||

Thanks again for the lead!

Bob

|||

Glad to help out and glad you got it working!

Eric

|||

Thanks

Monday, February 20, 2012

Problem in x64 SQL Server 2005 setup

Hi,

Trying to install 64-bit SQL Server 2005 RTM on Windows 2003 x64 Server with SP 1. The Reporting services option is not enabled in the installation steps. The installation process gets completed without any errors, but the Reporting Services is not installed.

The server has IIS installed, the .NET framework 2.0 is installed by SQL Server 2005 RTM itself. Am I doing anything wrong.

Can anyone help/suggest ?

Thanks in advance.

On x64 IIS can be configured to run native (64-bit) or WoW64 (32-bit). Check out this topic in Books Online: http://msdn2.microsoft.com/en-us/library/ms143293(en-US,SQL.90).aspx

You'll need to reverse engineer the steps to make sure IIS is configured to run native - provided you're installing the x64 version of SQL Server. If you're installing the 32-bit version of SQL Server on an x64 machine you'll want to follow this article as is.

Cheers,
Dan

|||

Thanks for response. I am installing x64 SQL 2005 RTM on x64 Windows 2003. The IIS settings are exactly the same, what has been described in the article above.

The problem is I am not able to install Reporting Services 2005. The article describes about the problem for not being able to run it. I wonder the scenarios are different ?

I forgot to mention in my question first time, that the x64 Windows 2003, where I am trying to install x64 SQL 2005 RTM does have SQL 2000 installed (32-bit). I doubt this could be the problem ? Not sure.

Thanks in advance.

|||

At the beginning of setup we run a configuration checker that checks the IIS configuration. If there is a problem with the IIS configuration you'll get a red circle with an X through it for the IIS entry. In addition, you won't be able to select Reporting Services from the feature selection dialog. Can you rerun setup and see if you get an error for IIS in the configuration checker. If you do post the error you get and we can continue trouble shooting - if I remember correctly there are a couple of IIS checks in the configuration checker.

BTW: Having SQL2K installed to WOW64 shouldn't have any impact on this.

Dan

|||

Hi Dan,

I am having the same problem. I want to install SQL 2005 Std x64 on Windows 2003Std x64.

In sql installation wizard everything is great (inlcuding IIS). Only Reporting Servicing has this warning, with the message "

Looking on where the files will go I see "C:\Program files (x86)". I have the impression that entire SQL (database, olap, not just RS) is trying to install with 32bit version, not x64. Do you know why?

How can I be sure what SQL version will be installed?

I will appreciate and help,

Thanks,

Dan

P.S. This is the report from the System Configuration Check, in SQL install wizard.

System Configuration Check

- WMI Service Requirement (Success)
Messages
* WMI Service Requirement
* Check Passed

- MSXML Requirement (Success)
Messages
* MSXML Requirement
* Check Passed

- Operating System Minimum Level Requirement (Success)
Messages
* Operating System Minimum Level Requirement
* Check Passed

- Operating System Service Pack Level Requirement. (Success)
Messages
* Operating System Service Pack Level Requirement.
* Check Passed

- SQL Server Edition Operating System Compatibility (Success)
Messages
* SQL Server Edition Operating System Compatibility
* Check Passed

- Minimum Hardware Requirement (Success)
Messages
* Minimum Hardware Requirement
* Check Passed

- IIS Feature Requirement (Success)
Messages
* IIS Feature Requirement
* Check Passed

- Pending Reboot Requirement (Success)
Messages
* Pending Reboot Requirement
* Check Passed

- Performance Monitor Counter Requirement (Success)
Messages
* Performance Monitor Counter Requirement
* Check Passed

- Default Installation Path Permission Requirement (Success)
Messages
* Default Installation Path Permission Requirement
* Check Passed

- Internet Explorer Requirement (Success)
Messages
* Internet Explorer Requirement
* Check Passed

- COM Plus Catalog Requirement (Success)
Messages
* COM Plus Catalog Requirement
* Check Passed

- ASP.Net Version Registration Requirement (Warning)
Messages
* ASP.Net Version Registration Requirement
* 64-bit ASP.Net is Registered. Required 32-bit ASP.Net to install Microsoft Reporting Services 2005(32-bit).

- Minimum MDAC Version Requirement (Success)
Messages
* Minimum MDAC Version Requirement
* Check Passed