Home | Forums | Contact | Search | Syndication  
 [login] [create account]   Sunday, June 16, 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
Article has been read 16625 times

Rating: - 5.0 out of 5 by 6 users

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


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
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
Does that work on 6.0 too? Just curious if that will set it to blank on 6.0

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
>>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 ;-)

David Nelson

Mike's workaround works in 6.1
Posted: 7/18/2003 11:32:22 PM
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
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): 6/16/2024 11:58:16 PM