installation problem for SQL 2000 Development Edition

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • qintian
    #1

    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/t325996

    Tags: None
    • Erland Sommarskog
      #2
      Re: installation problem for SQL 2000 Development Edition

      qintian (qintian.2cm19z @no-mx.forums.yourd omain.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, esquel@sommarsk og.se

      Books Online for SQL Server 2005 at
      http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

      Books Online for SQL Server 2000 at
      http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

        Comment

        • qintian
          #3
          Re: installation problem for SQL 2000 Development Edition


          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

            Comment

            • Erland Sommarskog
              #4
              Re: installation problem for SQL 2000 Development Edition

              qintian (qintian.2cnvy0 @no-mx.forums.yourd omain.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, esquel@sommarsk og.se

              Books Online for SQL Server 2005 at
              http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

              Books Online for SQL Server 2000 at
              http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

                Comment

                • Dan Guzman
                  #5
                  Re: installation problem for SQL 2000 Development Edition

                  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" <esquel@sommars kog.sewrote in message
                  news:Xns9821F12 DE4F00Yazorman@ 127.0.0.1...
                  qintian (qintian.2cm19z @no-mx.forums.yourd omain.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, esquel@sommarsk og.se
                  >
                  Books Online for SQL Server 2005 at
                  http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

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

                    Comment

                    • Erland Sommarskog
                      #6
                      Re: installation problem for SQL 2000 Development Edition

                      Dan Guzman (guzmanda@nospa m-online.sbcgloba l.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, esquel@sommarsk og.se

                      Books Online for SQL Server 2005 at
                      http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

                      Books Online for SQL Server 2000 at
                      http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

                        Comment

                        • qintian
                          #7
                          Re: installation problem for SQL 2000 Development Edition


                          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

                            Comment

                            • Erland Sommarskog
                              #8
                              Re: installation problem for SQL 2000 Development Edition

                              qintian (qintian.2cpte2 @no-mx.forums.yourd omain.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, esquel@sommarsk og.se

                              Books Online for SQL Server 2005 at
                              http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

                              Books Online for SQL Server 2000 at
                              http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

                                Comment

                                Previous template Next
                                Working...