[quoted text, click to view] Raj <nospam@hotmail.com> wrote in message news:<eksv80phmcak8v00713gijlfrildvpke3m@4ax.com>...
> On 28 Apr 2004 06:09:36 -0700, sql@hayes.ch (Simon Hayes) wrote:
>
> >rajchoud@hotmail.com (Raj) wrote in message news:<2c27ec55.0404271823.504bfcb8@posting.google.com>...
> >> Hi,
> >>
> >> I'm a newbie with SQL Server 2000 Developer. I know that it is
> >> supposed to install on Windows XP Pro, but I keep running into the
> >> following message:
> >>
> >> "The logon account cannot be validated for the SQL Server service.
> >> Validate ...".
> >>
> >> I've looked for help and taken the advise of trying the user
> >> "Administrator", but that does not help. Initially I tried making a
> >> new user called "sqlserver" with Administrator access, but that didn't
> >> work.
> >>
> >> Can someone please help. Ideally step by step from where I am.
> >>
> >> Thanks in advance,
> >>
> >> Raj
> >
> >
> >It would be useful if you can give a little more information. In
> >particular, are you logged in with an administrator account when you
> >run setup, and is your XP PC in a domain, or is it standalone? Have
> >you also tried using the LocalSystem account (although it's better to
> >use a domain account)?
> >
> >If you're logged in as an administrator, and if the account meets the
> >requirements described in Books Online ("Setting up Windows Services
> >Accounts"), then it should be fine.
> >
> >Simon
>
> Hi,
>
> Yes, I am logged in as an administrator and use the username and
> password for a different Administrator when on the SQL Server setup
> page (username: sqlserver, password: sqlserver, domain: XP7.
>
> Can you tell me what you mean about "is your PC in a domain"? It is
> networked using a DHCP server and can see the other computers (it is
> named: "XP7"). I installed iton a Windows 2000 Professional box a few
> days ago with no problem. Going through the exact same procedure on XP
> Pro doesn't work!
>
> Please help,
>
> Raj
I'm not sure I understand if XP7 is a computer name or a domain name,
but I suspect it's a computer name. I would try the following:
1. Logon with your own Administrator account - check you have local
admin rights
2. Logon with the "sqlserver" account - check you have local admin
rights
3. Logon with your own Administrator account - run setup
Assuming both accounts really do have local admin rights, then there
should be no reason for account validation to fail. I asked about a
domain because if the workstation is in a domain (ie. an Active
Directory domain), then it's possible that there is some group or
machine policy which is creating a problem. Although if you have a
domain, it would probably be better to use a domain account for the
SQL service, not a local computer account - I suspect there may be
some confusion here between these two types of account, but I'm not at
all sure.