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:Crogram 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='' />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:Crogram 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.