Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Friday, March 29, 2024 
 
Reset Admin Password Utility (v5 & Prior)  
Description:  Utility to reset the SalesLogix Administrator user's password (ie: set as blank)

Category:  Utilities
Author:  Ryan Farley
Submitted:  11/4/2002
   
Stats: 
Article has been read 16440 times

Rating: - 5.0 out of 5 by 6 users
 

fiogf49gjkf0d
Reset Admin Password Utility (v5 & Prior)

Utility to reset the SalesLogix Administrator user's password (ie: set as blank). Use this utility to get into a SalesLogix database that you no longer know the administrator account password for. Very useful for those times where you are given a database backup for a customer's system and can't get a hold of anyone who knows the password. Use at your own risk, although I have been using this since SLX 3 and have never had a problem. Note: this utility supports version 5.x and prior only!



 Click here to download the utility


-Ryan Farley
 

About the Author

  Ryan Farley
(SalesLogix Business Partner)
Customer FX Corporation

fiogf49gjkf0d

Ryan Farley is the Director of Development for Customer FX and creator of slxdeveloper.com. He's been blogging regularly about SalesLogix since 2001 and believes in sharing with the community. He loves C#, Javascript, Python, web development, open source, and Linux. He also loves his hobby as an amateur filmmaker.

View Ryan's SalesLogix Mobile Seveloper Series
View Ryan's SalesLogix SData Developer Series
View Ryan's Git for the SalesLogix Developer series



View online profile for Ryan Farley
 

[ back to top] [ send to a friend]  

Rate This Article you must log-in to rate articles. [login here] 
 
Please log in to rate article.
 

Comments & Discussion you must log-in to add comments. [login here] 
 
Author Article Comments and Discussion
Mike Spragg

slxdeveloper.com Forum Top 10 Poster!

Known other workaround
Posted: 11/28/2002 4:17:08 PM
fiogf49gjkf0d
Hi Ryan - I always find it quicker to just slam in a blank password using isql/w or sql explorer e.g.

update sysdba.usersecurity set userpw = '62c3a78ae34a2b0f62' where userid = 'ADMIN'

Still, nice for the uninitiated !
 
Steve Vassallo
 

The sql statement below....
Posted: 6/20/2003 8:53:07 AM
fiogf49gjkf0d
Does that work on 6.0 too? Just curious if that will set it to blank on 6.0

Thanks
 
Ryan Farley

slxdeveloper.com Site Administrator
slxdeveloper.com Forum Top 10 Poster!

Re: The sql statement below....
Posted: 7/2/2003 11:47:01 PM
fiogf49gjkf0d
>>Does that work on 6.0 too?

Unfortunately not. SalesLogix 6 appears to use both the USERID *and* the sitecode as the encryption seed, so you can no longer use a generic encrypted "blank" value for the admin user as before - but only a matter of time ;-)

-Ryan
 
David Nelson
 

Mike's workaround works in 6.1
Posted: 7/18/2003 11:32:22 PM
fiogf49gjkf0d
Tech support gave me the string in Mike's comment above and it set a customers Admin password to blank. The database started as a 6.0 blank database.
 
RJ Samp

slxdeveloper.com Forum Top 10 Poster!

Reset Admin Password Utility (v6)
Posted: 6/14/2004 12:28:12 PM
fiogf49gjkf0d
Just to confirm on SLX 6 (6.1xxx and 6.2 RC1 for certain):

update SalesLogix.sysdba.usersecurity set userpw='62C3A78AE34A2B0F62'
where userid = 'admin'

RJ Samp
 
 

       Visit the slxdeveloper.com Community Forums!
Not finding the information you need here? Try the forums! Get help from others in the community, share your expertise, get what you need from the slxdeveloper.com community. Go to the forums...
 



 slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation.
 This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 3/29/2024 2:24:37 AM