Reset Admin password - MSSQL 2005 express - NOT MySql

[TakeMarket]

Well,...
to make a long story short - we had one of our servers running a sugar instance turned off for 4 months and now we cannot login directly/the normal way,so we need to reset the password.

But there are only manuals on how to reset a mysql system on the sugar website...

so the question is: How do you reset the admin password on a mssql 2005 system?

Thanks in advance.

[Angel]

Try this (on the MSSQL server):

Start > Run > CMD <enter>

At the command window:

1. sqlcmd -S <mssql server/instance name> <enter>

That should get you connected to MSSQL and give you a prompt like "1>"

Type the following:

use <name of your sugarcrm database> <enter>
go <enter>

update users set user_hash = 'ada15bd1a5ddf0b790ae1dcfd05a1e70' where user_name = 'admin' <enter>
go <enter>

That should reset your password to "sugar"

[TakeMarket]

Thanks,Angel - you truly are an Angel :-)

I'll get back with a status on how it went.

Thanks a lot.

[Angel]

I'll get back with a status on how it went.

Please do, as I added it to the Wiki page with the MySQL stuff and I want to make sure I didn't overlook anything.

Glad I could help.

[TakeMarket]

Hi Angel,

So I finally got some time to look into the server issue (it's been a hell of a week ) we have with the old sugar server and:

everything goes well until step 2:
(names have been altered)

 1> mysqlDB
  2> go
  Msg 2812, Level 16, State 62, Server companyserver-00sqlserver2005, Line 1
  Could not find stored procedure 'mysqlDB'. 
  

So... no it's not working. any ideas?
thanks a lot in advance..

[kbrill]

Hi Angel,

So I finally got some time to look into the server issue (it's been a hell of a week ) we have with the old sugar server and:

everything goes well until step 2:
(names have been altered)

 1> mysqlDB
    2> go
    Msg 2812, Level 16, State 62, Server companyserver-00sqlserver2005, Line 1
    Could not find stored procedure 'mysqlDB'. 
  

So... no it's not working. any ideas?
thanks a lot in advance..

Shouldnt it be "use mysqlDB" in that first line (the one labeled "1>")?

[TakeMarket]

Hmm, say no more.. embarrassing... Kbrill your are right.. as always.

Every thing worked out fine..

To Kbrill, if you got some time.. could you, or maybe get a colleague to help us out with this thread?

http://www.sugarcrm.com/forums/showthread.php?t=30688

We posted for more than a week ago - but no one has responded to our issue. We cannot upgrade and install new modules because of this. We would appreciate this a lot.

Thanks a lot in advance.

And to Angel - thanks again - it worked fine!