Installation Error: installation problem for SQL 2000 Development Edition

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/t325996qintian (qintian.2cm19z@.no-mx.forums.yourdomain.com.au) writes:

Quote:

Originally Posted by

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, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||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|||qintian (qintian.2cnvy0@.no-mx.forums.yourdomain.com.au) writes:

Quote:

Originally Posted by

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.

Quote:

Originally Posted by

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" <esquel@.sommarskog.sewrote in message
news:Xns9821F12DE4F00Yazorman@.127.0.0.1...

Quote:

Originally Posted by

qintian (qintian.2cm19z@.no-mx.forums.yourdomain.com.au) writes:

Quote:

Originally Posted by

>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, esquel@.sommarskog.se
>
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

|||Dan Guzman (guzmanda@.nospam-online.sbcglobal.net) writes:

Quote:

Originally Posted by

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.

Quote:

Originally Posted by

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|||qintian (qintian.2cpte2@.no-mx.forums.yourdomain.com.au) writes:

Quote:

Originally Posted by

Right-click the server node in EM, select Properties. Go the Security tab.
The lower third is for changing the service account.

Monday, March 12, 2012

installation problem for SQL 2000 Development Edition

No comments:

Post a Comment

Installation Error

Blog Archive

About Me