Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2004
    Location
    Bangalore, India
    Posts
    250

    Unanswered: changed admin password (was "help reqd")

    hi all,

    i have installed mssql2k in win2000 server. since it was for my personal use, i did not give a password for the 'administrator' user in win2k. later on i cahnged the admin password,but my sqlserver did not start due to login failure.

    is ther any solutions to tackle this?
    Cheers....

    baburajv

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    What account did you change the password for?
    Quote Originally Posted by baburajv
    hi all,

    i have installed mssql2k in win2000 server. since it was for my personal use, i did not give a password for the 'administrator' user in win2k. later on i cahnged the admin password,but my sqlserver did not start due to login failure.

    is ther any solutions to tackle this?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Feb 2004
    Location
    Bangalore, India
    Posts
    250
    hi

    i changed the password 4 Administrator User of win2k server
    Cheers....

    baburajv

  4. #4
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    Quote Originally Posted by baburajv
    hi

    i changed the password 4 Administrator User of win2k server

    what is ur service log on account?
    I believe u are using administrator account...... if so then u need to to update the password here too.

    if it is for personal use u can use the option local system account.

  5. #5
    Join Date
    Sep 2004
    Posts
    22
    you need to change the password in the services

    start->settings->control panel->administrative tools->services

    find mssql( & sqlagent if your automatically starting that one as well for backups etc...). Double click... go on the log on tab, and change the password on the "this account" to the new password.

  6. #6
    Join Date
    Feb 2004
    Location
    Bangalore, India
    Posts
    250

    Thanks

    thanks for the information

    :-)
    Cheers....

    baburajv

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •