Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS SQL Server
 Admin pwd...forgot...renistall?
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

McDye
Starting Member

17 Posts

Posted - 20 August 2004 :  09:12:50  Show Profile
Here is my problem, I just installed 3.4.04 verison. I was going back to configure at a later time. I have since forgot my admin pwd. I dont have access to directly to SQL due to firewall to delete the tables and start over. Is there some way I can force it to reinstall over the top of the existing install. I tried to be secure and create a strong pwd....I guess I made too strong

DavidRhodes
Senior Member

United Kingdom
1222 Posts

Posted - 20 August 2004 :  09:29:12  Show Profile
If you had an email address in the admin account you can use the forgot password page www.yoursite.com/password.asp

The UK MkIVs Forum
Go to Top of Page

McDye
Starting Member

17 Posts

Posted - 20 August 2004 :  09:32:59  Show Profile
Thanks for the reply. I had not setup anything on the admin pages...no mail server configured..
Go to Top of Page

Podge
Support Moderator

Ireland
3776 Posts

Posted - 20 August 2004 :  11:47:25  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message
You could upload an asp page which uses the db connection in config.asp to delete the tables or database.

You could also use a different prefix in config.asp to re-install the tables.

Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page

-gary
Development Team Member

406 Posts

Posted - 20 August 2004 :  12:17:55  Show Profile
Create a new account, change the variable your_member_id below to the id of the new account, upload this as a new ASP page and execute it with your browser. On next login, your new account will be an admin and able to edit the original password. (I can't remember if the super admin account has any restrictions on having it's password edited by anyone else, but if it does just change the line "intAdminMemberID = 1" in config.asp to match your new ID and then change.) Remember to change the setting back and remove the admin privileges from the new account.


<!--#include file="config.asp" -->
<%
set my_Conn = Server.CreateObject("ADODB.Connection")
my_Conn.Open strConnString
strSQL = "update " & strMemberTablePrefix & "MEMBERS set M_LEVEL = 3 where MEMBER_ID = your_member_id"
my_Conn.Execute (strSQL),,adCmdText + adExecuteNoRecords
set my_Conn = Nothing
%>

KawiForums.com


Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.15 seconds. Powered By: Snitz Forums 2000 Version 3.4.07