https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 17:50:45 +0000 Thu, 01 Jun 2006 10:28:44 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=20065 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/cant-recover-lost-pw_topic20065_post108229.html#108229 Author: WebWiz-Bruce
Subject: 20065
Posted: 01 June 2006 at 10:28am

SQL Sever is different again.

You don't use the query analyser in SQL Server, you should be able to right click the table and choose 'Open Table', as simple as that.

However, this can be different depending on which version of SQL Server you are using and the tool you use connecting to the database.

Before I waste anymore time going through stuff that is not applicable, could be please tell me:-

What database are you using?
What database version?
What tool are you using to connect to the database?
]]> Thu, 01 Jun 2006 10:28:44 +0000 https://forums.webwiz.net/cant-recover-lost-pw_topic20065_post108229.html#108229 https://forums.webwiz.net/cant-recover-lost-pw_topic20065_post108204.html#108204 Author: jamesbradford
Subject: 20065
Posted: 31 May 2006 at 7:43pm

I'm sorry, I'm afraid I gave you wrong information. This is all so new to me, and I am having a hard time remembering whether I have MySQL or just SQL.

In fact I am NOT using "MySQL"; I am using an MS SQL Server Database.

And again, to repeat what I said above: When i go into the SQL functions I have something that says "Query Analyser". Butthen there is just a big blank box underneath that I would guess I'msupposed to type something into? And then a submit/reset set ofbuttons. I also have the option to "show execution plan". So what now?]]> Wed, 31 May 2006 19:43:29 +0000 https://forums.webwiz.net/cant-recover-lost-pw_topic20065_post108204.html#108204 https://forums.webwiz.net/cant-recover-lost-pw_topic20065_post108178.html#108178 Author: WebWiz-Bruce
Subject: 20065
Posted: 31 May 2006 at 3:27pm

OK, now were getting somewhere, you are using mySQL.

With mySQL you will need to download some software that allows you to view and modify mySQL database tables like SQLyog

This will then allow you to enter data directly into the database tables, os you can follow the instructions I gave in my previous post.
]]> Wed, 31 May 2006 15:27:50 +0000 https://forums.webwiz.net/cant-recover-lost-pw_topic20065_post108178.html#108178 https://forums.webwiz.net/cant-recover-lost-pw_topic20065_post108130.html#108130 Author: jamesbradford
Subject: 20065
Posted: 30 May 2006 at 9:45pm

Anyone? Please?!]]> Tue, 30 May 2006 21:45:50 +0000 https://forums.webwiz.net/cant-recover-lost-pw_topic20065_post108130.html#108130 https://forums.webwiz.net/cant-recover-lost-pw_topic20065_post108004.html#108004 Author: jamesbradford
Subject: 20065
Posted: 29 May 2006 at 2:15am

Ok. We're getting somewhere ;)

So in my MYSQL functions I have something that says "Query Analyser". But then there is just a big blank box underneath that I would guess I'm supposed to type something into? And then a submit/reset set of buttons. I also have the option to "show execution plan". So what now?

Thank you for your continued help
J
]]> Mon, 29 May 2006 02:15:54 +0000 https://forums.webwiz.net/cant-recover-lost-pw_topic20065_post108004.html#108004 https://forums.webwiz.net/cant-recover-lost-pw_topic20065_post107997.html#107997 Author: WebWiz-Bruce
Subject: 20065
Posted: 28 May 2006 at 7:44pm

You didn't mention the database version you are using, in Access you simply open the table, to view the data within the table, but in other databases you may need to run an SQL query on the table to see the data stored within the table.

Once you can view the data within the database table you can usually edit it, as per the instructions, but again it depends on the database you are using.
]]> Sun, 28 May 2006 19:44:12 +0000 https://forums.webwiz.net/cant-recover-lost-pw_topic20065_post107997.html#107997 https://forums.webwiz.net/cant-recover-lost-pw_topic20065_post107980.html#107980 Author: jamesbradford
Subject: 20065
Posted: 28 May 2006 at 4:27pm

Ok. So I've opened the database, and I've opened "tblAuthor"

I only see 'Author_ID' twice. The first is under COLUMNS, and the second is under INDEXES

I can't really determine if any of them have a value of 1 because I don't know what that means. But the first one has several "1's" in it's row. But I dont see any fields with username, apssword, or salt. What I see is this:

Type   Length    Prec.   Scale   Nullable    Default    Id.   Id. Start   Id. Seed


So clearly I must be doing something wrong.

J
]]> Sun, 28 May 2006 16:27:35 +0000 https://forums.webwiz.net/cant-recover-lost-pw_topic20065_post107980.html#107980 https://forums.webwiz.net/cant-recover-lost-pw_topic20065_post107960.html#107960 Author: WebWiz-Bruce
Subject: 20065
Posted: 28 May 2006 at 11:10am

If you have an valid email address and enabled the email tools then you can use the forgotten password feature when loging in.

If you don't have that what you will need to do is:-

1.Open the database
2. Open the table tblAuthor
3. Find Author_ID with the value of 1, this is your admin account
4. Copy and paste the following to the username field:-

    administrator

5. Copy and paste the following to the password field:-

    A85B3E67CFA695D711570FB9822C0CF82871903B

6. Copy and paste the following to the 'Salt' field:-

    72964E7


Your admin username and password should now be reset to:-

user: administrator
pass: letmein

]]> Sun, 28 May 2006 11:10:21 +0000 https://forums.webwiz.net/cant-recover-lost-pw_topic20065_post107960.html#107960 https://forums.webwiz.net/cant-recover-lost-pw_topic20065_post107945.html#107945 Author: jamesbradford
Subject: 20065
Posted: 28 May 2006 at 3:46am

So I assume to enable email feature would require logging into the board as the owner?

How do I do the second thing you just stated? You're talking Greek to me, please explain in detail?

Thanks
J
]]> Sun, 28 May 2006 03:46:18 +0000 https://forums.webwiz.net/cant-recover-lost-pw_topic20065_post107945.html#107945 https://forums.webwiz.net/cant-recover-lost-pw_topic20065_post107936.html#107936 Author: dj air
Subject: 20065
Posted: 27 May 2006 at 11:54pm

you have to have email features enabled and a valid email address within the profile.

the other option is to edit the database replacing the password and salt fields for the user replacing with the default values found within a fresh database/ or within the SQL install script.
]]> Sat, 27 May 2006 23:54:14 +0000 https://forums.webwiz.net/cant-recover-lost-pw_topic20065_post107936.html#107936