SQL Server Performance

Failing Cluster install SQLBROWSERACCOUNT

Discussion in 'SQL Server 2005 Clustering' started by tates, Apr 26, 2007.

  1. tates New Member

    Hello<br /><br />Has anybody come across an issue when installing a SQL Server 2005 Failover cluster. The installation is run as interactive, not a silent install using template.ini.<br /><br />The installation fails on the installation of the Database Server stating that...<br /><br />'SQL Server Setup has determined that the following account properties are not specified: 'SQLBROWSERACCOUNT'..... reference to template.ini<br /><br />All references that I have seen to this message are related to silent installations using template.ini<br /><br />In SQL Log file<br /><br />Property(S): SOURCEDIR = C:ServersSetupProperty(S): SourcedirProduct = {14AD8FEC-4128-4133-A49D-66A7F14651A2}<br />Property(S): InstallNgenTicks = 20000<br />Property(S): AGTSCMACCOUNT = XMERCERsvcglobalagtsql<br />Property(S): SQLSCMACCOUNT = XMERCERsvcglobalsql<br />Property(S): DebugClsid.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 = {B4A67A5B-6B8E-49FB-8B60-D8CFA2CDAEA6}<br />Property(S): SQLBROWSERACCOUNT = NT AUTHORITYSYSTEM<br />Property(S): ProductToBeRegistered = 1<br />MSI (s) (80:70) [00:40:04:447]: Note: 1: 1708 <br />MSI (s) (80:70) [00:40:04:447]: Product: Microsoft SQL Server 2005 -- Installation failed.<br /><br />In Core Log file<br /><br />Clustered feature detected: SQL_Engine<br />Clustered feature detected: SQL_FullText<br />Loaded DLL:C:program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.1399.0<br /> Source File Name: datastorecachedpropertycollection.cpp<br />Compiler Timestamp: Fri Jul 29 01:13:49 2005<br /> Function Name: CachedPropertyCollection::findProperty<br />Source Line Number: 130<br />----------------------------------------------------------<br />Failed to find property "IPResources" {"VirtualServerInfo", "", "LABSQLCLUSTER"} in cache<br /> Source File Name: datastorecachedpropertycollection.cpp<br />Compiler Timestamp: Fri Jul 29 01:13:49 2005<br /> Function Name: VirtualServerInfo.IPResources<br />Source Line Number: 113<br />----------------------------------------------------------<br />Failed to collect property "IPResources" {"VirtualServerInfo", "", "LABSQLCLUSTER"}<br />Notify package to begin: 0<br />******* Got commit request from MSI *******<br />Waiting for remote setup(s) to get ready to commit<br />Breaking wait state and aborting package due to cancel code received: 1602<br />Remote setup(s) are ready<br />Notify package to commit: 1602<br />Aborting commit due to exception thrown by listeners: <br />sqls::WindowsInstallerMessageCallback<br />sqls::HostSetupPackageInstallerSynch:<img src='/community/emoticons/emotion-4.gif' alt=':p' />reCommit<br /><br /> Error Code: 0x80070642 (1602)<br />Windows Error Text: User cancelled installation.<br /><br /> Source File Name: remotepackageenginehostsetuppackageinstallersynch.cpp
  2. satya Moderator

  3. tates New Member

    Thanks for your response Satya, however this is an interactive installation. My understanding is that an interactive install should not be using the template.ini file.?
  4. MohammedU New Member

    Yes, you are right it should not use .ini for regular installation...

    Are you using the installaion files from the network share?


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  5. tates New Member

    I am using a local copy of the installation media copied to C:Server & c:Tools

    Thanks for your comment
  6. satya Moderator

    Have you checked for relevant privileges for Browser service account?

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  7. tates New Member

    Thanks for your reply...

    During installation only the SQL Service Account and SQL Agent Account are defined, I am not sure where else the Browser Service Account permissions would be defined prior to installation with an interactive install.? The Service Accounts defined have Local Administrator privileges on both nodes in the cluster...

    The following is from SQL Log for install on remote node

    <EndFunc Name='SetCAContext' Return='T' GetLastError='0'>
    Doing Action: SetUnattendedSvcAccountProp
    PerfTime Start: SetUnattendedSvcAccountProp : Tue May 01 19:17:00 2007
    <Func Name='SetUnattendedSvcAccountProp'>
    Initial Account Name: XMERCERsvcglobalsql
    MSI (s) (A8:4C) [19:17:00:985]: PROPERTY CHANGE: Adding AGTSCMACCOUNT property. Its value is 'XMERCERsvcglobalsql'.
    SamCompatible Account Name: XMERCERsvcglobalsql
    Initial Account Name: XMERCERsvcglobalsql
    MSI (s) (A8!4C) [19:17:01:266]: PROPERTY CHANGE: Adding SQLSCMACCOUNT property. Its value is 'XMERCERsvcglobalsql'.
    SamCompatible Account Name: XMERCERsvcglobalsql
    Error Code: 0x80076d66 (28006)
    Windows Error Text: Source File Name: sqlcasqlguica.cpp
    Compiler Timestamp: Mon Aug 29 01:18:41 2005
    Function Name: SetUnattendedSvcAccountProp
    Source Line Number: 4370



    ---- Context -----------------------------------------------


    Setting status of unmanaged components and removing unmanaged resources



    Error Code: 28006



    This is from local Core.log

    Loaded DLL:C:program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.1399.0
    Source File Name: datastorecachedpropertycollection.cpp
    Compiler Timestamp: Fri Jul 29 01:13:49 2005
    Function Name: CachedPropertyCollection::findProperty
    Source Line Number: 130
    ----------------------------------------------------------
    Failed to find property "IPResources" {"VirtualServerInfo", "", "LABCLUSTER"} in cache
    Source File Name: datastorecachedpropertycollection.cpp
    Compiler Timestamp: Fri Jul 29 01:13:49 2005
    Function Name: VirtualServerInfo.IPResources
    Source Line Number: 113
    ----------------------------------------------------------
    Failed to collect property "IPResources" {"VirtualServerInfo", "", "LABCLUSTER"}
    Notify package to begin: 0
    ******* Got commit request from MSI *******
    Waiting for remote setup(s) to get ready to commit


  8. ronaldo16 New Member

    Hi,
    did you ever find an answer to this issue?
    I have hit exactly the same problem whilst doing an instal for a failover cluster.
    Grateful for any advice.....
    Regards....john.

Share This Page