Did I dream this thread:- Resetting password from command line

[russdev]

Did I dream thread which had how to reset a sims.net user from command line.

As I was thinking the self service password reset could be modified so that it ran the program to reset a sims password..

But first got see if can reset a password from the command line.

Russ

[plexer]

there is a thread about using sql command line to reset the system admin password.

[nephilim]

osql -SSERVER\SIMSSQL2005 -E -n -Q"sp_password @old =null, @new= 'NewSAPassword1#' , @loginame = 'sa'"

This command assumes that

The server name is SERVER
The instance name is SIMSSQL2005
The sa username is sa
The new sa password is NewSAPassword1#

Hope this helps!

Run that from the command line and you should be good. In theory you can change any username and password with that line

[superfletch]

Obviously one instance of SQL Server can host multiple databases.

If you wanted to change a user within the SIMS/FMS database itself you would have to specify the relevant database as well as the SQL Instance. Extending the commands nephilim demonstrated you could get into the SIMS/FMS database from the command line and change an individual users password

If you had reset the SA password (as shown) then you should be able to connect to the SQL Server management studio, get into SIMS/FMS and then reset users password that way too.


SIMS does let people reset their own password now during log in.

[matt40k]

There are tools\commands to reset the sysman password (both sims and fms). Anything other then this and we enter the realms of grey support, ie will Capita now say you've support is voided

You might want to look at:

C:\Program Files\SIMS\SIMS .net\DBPwdChg.exe

[russdev]

hmm right DBPwdChg.exe is what I was thinking of. The problem is can't script it which I was hoping you can. As what I wanted to do is edit the Self Service Reset Script on here to offer sims.net password reset.

Russ

[matt40k]

There was talks about adding command lines to it, however, it's not yet appeared. I think the best way to do what you want is to use trusted logins. SSO is the way forward.

[dhicks]

hmm right DBPwdChg.exe is what I was thinking of. The problem is can't script it

Why not? You can't just run DBPwdChg.exe with system("DBPwdChg.exe ...") or whatever your programming language's equivalent is?

--
David Hicks