SQL2KE, SP3a cluster install

Thanks Geoff, I appreciate your quick response!

The thing is that SP3a is provided qith a domain-lavel account that is
administrator on both nodes. That is the installation account. The dialog
box says: Enter a user name and password that is a valid administrator
account for all nodes in the cluster system." The service account that SQL
Server uses won't be local admin, and that's the point. The dlg asks for the
installation account. This account was used to set up SQL2KE and now, during
SP3a setup it can not be validated. Is this some kind of DNS problem? The
nodes and the virtual server are on one domain but the user account is from
another domain. I think rather this is the problem. It must be some AD or
DNS problem.

Sorry if I wasn't clear with my question.
Regards,
Janos (aka Seggfej)

"Geoff N. Hiten" <SRDBA DeleteThis @Careerbuilder.com> wrote in message
news:%23wJXGGeEFHA.1396@tk2msftngp13.phx.gbl...
 > SP3a wants a domain-level account that is an administrator on BOTH nodes.
 > It does not have to be the initial installation account.
 >
 > --
 > Geoff N. Hiten
 > Microsoft SQL Server MVP
 > Senior Database Administrator
 > Careerbuilder.com
 >
 > I support the Professional Association for SQL Server
<font color=purple> > <a style='text-decoration: underline;' href="http://www.sqlpass.org</font" target="_blank">www.sqlpass.org</font</a>>
 >
 > "Seggfej" <kob_uki DeleteThis @hotmail.com> wrote in message
 > news:%23lTrWHYEFHA.3824@TK2MSFTNGP10.phx.gbl...
  >> Hi Gurus,
  >>
  >> I have installed SQL2KE on a two node cluster.
  >> I installed it with an install service account (domain user) that is
  >> local
  >> admin on both nodes. SQL Server is running on its own account (domian
 > user)
  >> that is not local admin. Installation was using mixed mode
  >> authentication.
 > I
  >> tested the setup, failed over and back without any problem.
  >> Running SP3a, first says explicitely Validating user account... then it
 > asks
  >> for the install account again (?) and throws an error: Can not validate
 > user
  >> account as local administrator. Error 5.
  >> I now that SP3a shuts down the instance and brings it up in a single user
  >> mode, but I don't think it has anyting to see with it. Or does it?
  >>
  >> Has anyone seen this before? Any help would be appreciated.
  >>
  >> Thanks,
  >> Seggfej
  >>
  >>
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: SQL2KE, SP3a cluster install 

I think your problem is that SQL server needs an admin-level account for
it's service account, at least for the first service pack installation.

FIX: A Cluster Upgrade to Service Pack 1 Does Not Succeed If SQL Server
Services Are Running Under a Non-Administrator Account
<a style='text-decoration: underline;' href="http://support.microsoft.com/default.aspx?scid=kb;en-us;308829" target="_blank">http://support.microsoft.com/default.aspx?scid=kb;en-us;308829</a>



--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com

I support the Professional Association for SQL Server
<a style='text-decoration: underline;' href="http://www.sqlpass.org" target="_blank">www.sqlpass.org</a>

"Janos Horanszky" <kob_uki.DeleteThis@hotmail.com> wrote in message
news:e5MkO9wEFHA.2608@TK2MSFTNGP10.phx.gbl...
 > Thanks Geoff, I appreciate your quick response!
 >
 > The thing is that SP3a is provided qith a domain-lavel account that is
 > administrator on both nodes. That is the installation account. The dialog
 > box says: Enter a user name and password that is a valid administrator
 > account for all nodes in the cluster system." The service account that SQL
 > Server uses won't be local admin, and that's the point. The dlg asks for
the
 > installation account. This account was used to set up SQL2KE and now,
during
 > SP3a setup it can not be validated. Is this some kind of DNS problem? The
 > nodes and the virtual server are on one domain but the user account is
from
 > another domain. I think rather this is the problem. It must be some AD or
 > DNS problem.
 >
 > Sorry if I wasn't clear with my question.
 > Regards,
 > Janos (aka Seggfej)
 >
 > "Geoff N. Hiten" <SRDBA.DeleteThis@Careerbuilder.com> wrote in message
 > news:%23wJXGGeEFHA.1396@tk2msftngp13.phx.gbl...
  > > SP3a wants a domain-level account that is an administrator on BOTH
nodes.
  > > It does not have to be the initial installation account.
  > >
  > > --
  > > Geoff N. Hiten
  > > Microsoft SQL Server MVP
  > > Senior Database Administrator
  > > Careerbuilder.com
  > >
  > > I support the Professional Association for SQL Server
<font color=green>  > > <a style='text-decoration: underline;' href="http://www.sqlpass.org</font" target="_blank">www.sqlpass.org</font</a>>
  > >
  > > "Seggfej" <kob_uki.DeleteThis@hotmail.com> wrote in message
  > > news:%23lTrWHYEFHA.3824@TK2MSFTNGP10.phx.gbl...
   > >> Hi Gurus,
   > >>
   > >> I have installed SQL2KE on a two node cluster.
   > >> I installed it with an install service account (domain user) that is
   > >> local
   > >> admin on both nodes. SQL Server is running on its own account (domian
  > > user)
   > >> that is not local admin. Installation was using mixed mode
   > >> authentication.
  > > I
   > >> tested the setup, failed over and back without any problem.
   > >> Running SP3a, first says explicitely Validating user account... then it
  > > asks
   > >> for the install account again (?) and throws an error: Can not validate
  > > user
   > >> account as local administrator. Error 5.
   > >> I now that SP3a shuts down the instance and brings it up in a single
user
   > >> mode, but I don't think it has anyting to see with it. Or does it?
   > >>
   > >> Has anyone seen this before? Any help would be appreciated.
   > >>
   > >> Thanks,
   > >> Seggfej
   > >>
   > >>
  > >
  > >
 >
 ><!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: SQL2KE, SP3a cluster install