SEO

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

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

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

Hi,

Installed as an Administrator using a domain XP7.



On 27 Apr 2004 19:23:37 -0700, rajchoud@hotmail.com (Raj) wrote:

>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

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

Installed using Administrator account and used XP7 as domain!

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.

Simon