Failing Cluster install SQLBROWSERACCOUNT | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Failing Cluster install SQLBROWSERACCOUNT

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
See this Bloghttp://blogs.msdn.com/sanchan/archive/2006/05/28/609097.aspx entry and refer to the accounts section. 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.
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.?
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.

I am using a local copy of the installation media copied to C:Server & c:Tools Thanks for your comment
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.
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

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.

]]>