Hallo all,

Please help me..Urgent.!!!!
Any body now how to change password baandb database using ttdba0120m000 ??
i am using MS SQL 2000 Enterprise editions dan Windows 2000 Advance Server.

pleaseee...any help me....i hope someone can help me... :confused:

I normally do it like this (previously we didn't have this RDBMS admin menu in tools menu)

Change the password directly in the database for the user.

crypt the password. On unix you can use the crypt tool, with windows you can change it by creating a dummy user and check the crypt code in table ttdba015000.

Update the crypted password in the $BSE/lib/ora/ora_groups.

As you probably noticed we use oracle, I assume the procedure will work for ms-sql as well.

Have fun,
Han

%BSE%/bin
msql_admin.exe

Change group password:
-R <group> -P <new group password> -c <admin> -i <admin password>


so for you..

msql_admin -R baandb -P <new password> -c sa -i <sa's password>

That will change it in the DB as well as the msql_groups file.

Dave

Hallo Dave,

I am not found msql_admin.exe in my server.
Can u you...tell me step by step using session ttdba0120m000..????

regrads,

You have to do it at DOS prompt, make sure your BSE is set. If you can't find msql_admin, you can use msql7_maint instead.

msql7_maint -R baandb -P <new password> -c sa -i <sa's password>

Hallo harijono,

thx for u advice....btw can u teach me how to open that file extention...becoz i`m never try that ?? becoz my problem is in my live server so first i`m want to try in my simulation server..
thx so much

regards,