If for some reason you mislocated, lost, or forget your CS administrator password, there is a pretty simple way to recover it. By default CS encrypts all passwords that are stored in the database, well all except one, the admin password. So how do you go about recovering your set of admin credentials?
First access your database and open the table called aspnet_Users, since you are probably going to be able to easily recognize your username once you see it, you should be able to just scroll through the users and quickly identify your username(in the "UserName" field), then open up your aspnet_Membership table and look in the "Password" field to also quickly recognize your password since it's the only one that is really readable with all others being encrypted.
Now this is assuming that you have a relatively small database, however it's understandable to have thousands of users making it much more difficult, so you may want to do this with a few simple queries. This time start with opening your aspnet_Membership table first, inside you will see a field called "PasswordFormat", this tells you whether or not the password is encrypted or not. So to easily pull back your admin password run the below query.
SELECT * FROM aspnet_Membership WHERE PasswordFormat = 0
You should get 1-2 rows and one will contain your password. Now take a look at the row that contains your password, and there should be another field called "UserId" use that id in this next query:
SELECT * FROM aspnet_Users WHERE UserId = 'PlaceUserIdHere'
That query will pull back your matching user, and from that you can view your user name. You now have both your user name and password and should be able to access your admin account within Community Server.
-Ryhow
