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?What account did you change the password for?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?|||hi

i changed the password 4 Administrator User of win2k server|||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.|||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.|||thanks for the information

:-)