reset "SA" password in sims?

[zag]

Can anyone remember how to reset the SA password in sims?

 

I've done another one of their stupid database patches which errored out and now I cant login to sims, or get into dbattach to restore the backup.

Edited April 3, 2008 by zag

[JAYC]

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!

[zag]

Thanks, but how do you run the command?

 

Is it from a command prompt? Or some sql thingy?

 

Just a bit of background, I'm getting an error 6 when trying to log into sims after a failed patch.

 

When trying to run dbattach to restore the database its saying my SA password is wrong, even though I know its right

[kmount]

Command line as long as your PATH is set correctly which it should be.

[dwhyte85]

Hate kicking dead threads but you've just saved my life.

[vikpaw]

Since it's been revived, anyone reading may also like to refer to :

 

http://www.edugeek.net/forums/mis-systems/6334-sql-server-sims-sa-password.html

 

note sa password is not a SIMS password but an SQL one.