MIS Systems Thread, Did I dream this thread:- Resetting password from command line in Technical; Did I dream thread which had how to reset a sims.net user from command line.
As I was thinking the ...
11th July 2009, 02:44 PM #1
Did I dream this thread:- Resetting password from command line
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.
11th July 2009, 10:07 PM #2
there is a thread about using sql command line to reset the system admin password.
11th July 2009, 10:22 PM #3
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
11th July 2009, 11:07 PM #4
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.
12th July 2009, 01:53 AM #5
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
12th July 2009, 08:17 AM #6
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.
12th July 2009, 01:26 PM #7
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.
13th July 2009, 05:35 PM #8
Why not? You can't just run DBPwdChg.exe with system("DBPwdChg.exe ...") or whatever your programming language's equivalent is?
Originally Posted by russdev
By RabbieBurns in forum *nix
Last Post: 13th January 2009, 09:48 AM
By boomam in forum How do you do....it?
Last Post: 3rd October 2008, 02:05 PM
By dave.81 in forum Windows
Last Post: 7th May 2008, 10:46 AM
By alan-d in forum How do you do....it?
Last Post: 23rd April 2008, 11:51 AM
By wesleyw in forum Windows
Last Post: 12th October 2006, 12:10 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)