installation problem for SQL 2000 Development Edition

[qintian]

hi all, i dunno should i post it here or not but i cant other place to
post this problem ..

i am using windows XP professional service pack 1 .. when i try to
install MS SQL 2000 Developer Edition to my system, it can works fine
except when i try to set the user name and password then it promp out
this msg

error msg : setup cannot verify/grant logon as service right to the sql
server logon account : 1332(0X534)

can any 1 help me with this? if i choose windows authentichal password
then can run, i cannot set the password
--
qintian
------------------------------------------------------------------------
qintian's Profile: http://www.dbtalk.net/m671
View this thread: http://www.dbtalk.net/t325996

[Erland Sommarskog]

qintian (qi************@no-mx.forums.yourdomain.com.au) writes:

hi all, i dunno should i post it here or not but i cant other place to
post this problem ..

i am using windows XP professional service pack 1 .. when i try to
install MS SQL 2000 Developer Edition to my system, it can works fine
except when i try to set the user name and password then it promp out
this msg

error msg : setup cannot verify/grant logon as service right to the sql
server logon account : 1332(0X534)

can any 1 help me with this? if i choose windows authentichal password
then can run, i cannot set the password

The usernams and password that you specify when you get that message is
the Windows username/password for the SQL Server service account. That is,
the Windows process that runs SQL Server. You can change this after the
installation from the Services node in Computer Management. (Right-click
My Computer, select Manage, find Services, and then the SQL Server Service.
Right-click, Properties and on the second tab, you have log-on information.)

If you know that the account is alright, then I would just ignore the
message and move on. I believe, I've seen it when I've installed SQL Server
as well.


--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

[qintian]

thank you Erland Sommarskog,

so the time when i installing the MS SQL . i can juz simply choose a
log on mathod? then after that change it by your way??? :confused:
--
qintian
------------------------------------------------------------------------
qintian's Profile: http://www.dbtalk.net/m671
View this thread: http://www.dbtalk.net/t325996

[Erland Sommarskog]

qintian (qi************@no-mx.forums.yourdomain.com.au) writes:

thank you Erland Sommarskog,

so the time when i installing the MS SQL . i can juz simply choose a
log on mathod? then after that change it by your way??? :confused:

Yes. If you're nervous that the installation will fail, you can choose
LocalSystem and then change to a normal Windows account after the
installation.

You can also change the choice of allowing SQL Server authentication after
the installation as well. Note that this concerns logging into SQL Server
itself.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

[Dan Guzman]

You can change this after the

installation from the Services node in Computer Management.

I usually suggest that Enterprise manager be used to change the SQL Server
service account after installation because EM will grant additional advanced
user rights that don't get assigned with the Computer Management method.
The advanced rights are needed for functionality like changing security
context to the proxy account and using AWE. The permissions (documented in
the BOL) can be granted manually but it's more work.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Erland Sommarskog" <es****@sommarskog.sewrote in message
news:Xn**********************@127.0.0.1...

qintian (qi************@no-mx.forums.yourdomain.com.au) writes:

>hi all, i dunno should i post it here or not but i cant other place to
post this problem ..

i am using windows XP professional service pack 1 .. when i try to
install MS SQL 2000 Developer Edition to my system, it can works fine
except when i try to set the user name and password then it promp out
this msg

error msg : setup cannot verify/grant logon as service right to the sql
server logon account : 1332(0X534)

can any 1 help me with this? if i choose windows authentichal password
then can run, i cannot set the password

The usernams and password that you specify when you get that message is
the Windows username/password for the SQL Server service account. That is,
the Windows process that runs SQL Server. You can change this after the
installation from the Services node in Computer Management. (Right-click
My Computer, select Manage, find Services, and then the SQL Server
Service.
Right-click, Properties and on the second tab, you have log-on
information.)

If you know that the account is alright, then I would just ignore the
message and move on. I believe, I've seen it when I've installed SQL
Server
as well.


--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

[Erland Sommarskog]

Dan Guzman (gu******@nospam-online.sbcglobal.net) writes:

I usually suggest that Enterprise manager be used to change the SQL
Server service account after installation because EM will grant
additional advanced user rights that don't get assigned with the
Computer Management method. The advanced rights are needed for
functionality like changing security context to the proxy account and
using AWE. The permissions (documented in the BOL) can be granted
manually but it's more work.

Interesting, I didn't know that. In fact, I was not even aware of that
you could change the service account through EM. I guess that shows how
much that I use Enterprise Manager. :-)

Thanks Dan for the information.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

[qintian]

Dan Guzman Wrote:

I usually suggest that Enterprise manager be used to change the SQL
Server
service account after installation because EM will grant additional
advanced
user rights that don't get assigned with the Computer Management
method.
The advanced rights are needed for functionality like changing
security
context to the proxy account and using AWE. The permissions
(documented in
the BOL) can be granted manually but it's more work.

--
Hope this helps.

Dan Guzman
SQL Server MVP

hi dan.. thanks for ur help but can u tell me more specified how to did
it with the EM ?? i finding whole day there but i cant find the security
part that u mentioning here..:( sorry need ur help again...
--
qintian
------------------------------------------------------------------------
qintian's Profile: http://www.dbtalk.net/m671
View this thread: http://www.dbtalk.net/t325996

[Erland Sommarskog]

qintian (qi************@no-mx.forums.yourdomain.com.au) writes:

hi dan.. thanks for ur help but can u tell me more specified how to did
it with the EM ?? i finding whole day there but i cant find the security
part that u mentioning here..:( sorry need ur help again...

Right-click the server node in EM, select Properties. Go the Security tab.
The lower third is for changing the service account.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx