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

:-)

change pwd disconnects remote server

Hello,
I have sql personal server installed on my xp machine and have registered a
remote server called pccm-nt. I have login permissions to the server and I'm
a database user for all of the databases.
I connect to the remote sql server with my windows domain account username a
nd password. When I change my pwd I can no longer connect to the remote serv
er, pccm-nt, I usually have to remove the server and re-register it. Would s
omeone be able to tell me w
hy changing my domain password is causing this conflict?
Thanks,
ChiekoYour security token is now invalid. Logout of the domain and log back in ag
ain.|||Okay,
I'll try that but I think that I did log off and log on again.
Thanks for the help,
Chieko

Change of Ownership??

I am having a problem with object ownership.
The person who setup the SQL Server setup the "dbo" account with his personal permissions. I need to change "dbo" so that the login name is the system account and not a personal account. Is this possible?

If this is not possible can I change the ownership of a system object?
I was able to change ownershipof user objects using the "sp_changeobjectowner" stored procedure, but it did not seem to work for system objects.

Any way around this?

- Ericdid you try sp_changedbowner? This would change the database ownership which I believe should change the system object ownership?>?|||The dbo user is so tightly "hardwired" into the database that I'd give the user a new login, change the ownership of their tables to that new user, and stop right there. I wouldn't even consider allowing the user to keep using dbo.

-PatP