Changing passwords for SIMS users by script

[academic_mwnci]

As System Manager 7 is a long way off (relatively speaking)

Does anyone use/have any scripts they use to change passwords in SIMS.

The kind of thing I was thinking of:

• To have a script run which will reset passwords monthly and create a list of the new passwords in a text file.

• To have a script that would change a singe user password which is constant in several school databases

In a search before postin DBPwdChg.exe came up - anyone know what this does?

[FN-GM]

If you come up with a solution please let me know

Thanks

[Michael]

It is one thing that Sims lacks, however I have read articles (on these forums) whereby you can link the Sims logon with Active Directory. Active Directory does allow you to force users to reset their password at first logon or whenever necessary.

[jinnantonnix]

I did have a bash at it, but I couldn't quite get it.

It sort of works, but fails when you try to log in, so I suppose it doesn't really work at all.

Here's what I've got, perhaps it will give someone a toe-hold on the problem...





use testsims


declare @login_name as varchar(255)
declare @user_id as varchar(255)
declare @person_id as varchar(255)
declare @password_generated as varchar(255)
declare @new_password as varchar(255)
declare @new_password_encrypted as varchar(255)




set @login_name = 'user1'
set @password_generated = 'QWERTYUIOP'



declare @new_password_generated_encrypted varchar(255)
select @new_password_generated_encrypted = sims.db_fnc_cesencrypt(@password_generated, default)

-- password now stored in @new_password_generated_encrypted
select @new_password_generated_encrypted

-- now need to get the person_id for out login (user1)
select @person_id = person_id from sims.db_user
where login_name = @login_name

select @person_id

--now reset the password
exec sims.mnw_pix_password_reset @person_id, @password_generated