Windows Vista Tips

Windows Vista Tips > Newsgroups > Windows Server > Clustering > Cannot Install 64 bit SQL Server 2005 on Windows Server 2008

Reply
Thread Tools Display Modes

Cannot Install 64 bit SQL Server 2005 on Windows Server 2008

 
 
Loren Z
Guest
Posts: n/a

 
      08-10-2009
I am attempting to install 64 bit SQL Server 2005 on a two node Windows
Server 2008 SP2 cluster. I get to the part of the install "Remote Account
Information" where I am required to enter an user name and password that is
a valid administrator on both nodes. I enter the information of an account
that is an administrator on both nodes and I get this message:

================================================== ============================
SQL Server 2005 Setup requires administrator permissions on every cluster
node. To continue, update permissions for the account currently running
Setup, or log in with an account that has administrator permissions on every
cluster node, and then run SQL Server Setup again.

================================================== ============================

I am unable to get further in the installation. I have done many successful
cluster intalls on Windows 2003 clusters. I have gone over documentation on
how to do SQL Server 2005 installs on Windows 2008 clusters and am following
best practices. Is it possible that this can be a result of the way the
server or the cluster was set up?

On the active node I have been right-clicking on the setup file and choosing
"Run as Administrator". Is it possible that it is not running as an
administrator on the second node? I have read that in Windows 2008 a login
belonging to the Administrator's group logs in with two tokens, a restricted
one and an unrestricted one. User applications are started with the
restrictive token and will use the unrestrictive token only when an
application requests higher priviliges or "Run as Adminstrator" is clicked.
How does this work in a Windows 2008 cluster environment?


 
Reply With Quote
 
 
 
 
Loren Z
Guest
Posts: n/a

 
      08-18-2009

Doing the install using a domain adminstrator account worked but for
security reasons this is not a long-term solution.

The solution that worked for us to get the domain account with
administrative rights on both nodes to get by the "Remote Account
Information" step was to set a new SPN record for the active node. This was
done using the Windows support tool executable "setspn". Domain admin
permissions were required for this but this only needs to be set when
initially installing SQL Server.



"Loren Z" <> wrote in message
news:eeG$...
>I am attempting to install 64 bit SQL Server 2005 on a two node Windows
> Server 2008 SP2 cluster. I get to the part of the install "Remote Account
> Information" where I am required to enter an user name and password that
> is
> a valid administrator on both nodes. I enter the information of an account
> that is an administrator on both nodes and I get this message:
>
> ================================================== ============================
> SQL Server 2005 Setup requires administrator permissions on every cluster
> node. To continue, update permissions for the account currently running
> Setup, or log in with an account that has administrator permissions on
> every
> cluster node, and then run SQL Server Setup again.
>
> ================================================== ============================
>
> I am unable to get further in the installation. I have done many
> successful
> cluster intalls on Windows 2003 clusters. I have gone over documentation
> on how to do SQL Server 2005 installs on Windows 2008 clusters and am
> following best practices. Is it possible that this can be a result of the
> way the server or the cluster was set up?
>
> On the active node I have been right-clicking on the setup file and
> choosing "Run as Administrator". Is it possible that it is not running as
> an administrator on the second node? I have read that in Windows 2008 a
> login belonging to the Administrator's group logs in with two tokens, a
> restricted one and an unrestricted one. User applications are started with
> the restrictive token and will use the unrestrictive token only when an
> application requests higher priviliges or "Run as Adminstrator" is
> clicked. How does this work in a Windows 2008 cluster environment?
>



 
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: A new member server - Windows Server 2008 + SQL Server 2008 OR Windows Server 2003 + SQL Server 2005 kj [SBS MVP] Windows Small Business Server 0 02-24-2009 03:21 PM
Re: A new member server - Windows Server 2008 + SQL Server 2008 OR Windows Server 2003 + SQL Server 2005 Larry Struckmeyer [SBS-MVP] Windows Small Business Server 0 02-24-2009 11:36 AM
Virtual Server 2005 / Windows Server 2008 Pryan Windows Server 2 10-29-2008 08:54 PM
Windows Server 2008 with SQL Server 2005 - failover clustering with one node Carlos Felipe França da Fonseca Clustering 1 09-19-2008 08:18 AM
Windows Server 2008, w/Exchange 2007 install & AD 2003 Server netadmin07 Active Directory 3 09-19-2008 04:28 AM



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59