Web Wiz Forums - MS SQL Server Password Help

Print Page | Close Window

MS SQL Server Password Help

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=24937
Printed Date: 04 April 2026 at 8:09am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: MS SQL Server Password Help

Posted By: mAce
Subject: MS SQL Server Password Help
Date Posted: 03 December 2007 at 6:32pm

Hi All,

My ISP have changed the password (For security reasons) on the MS SQL server. My problem is that I cannot remember the password and either need to

1) Find out what the old password was? I deleted the database files as instructed.
2) I can reset the SQL password, but I need to change it on the forum and don't know how.

I've search this forum but couldn't find anything to help, any pointers would be great.

Thanks

M ace

Replies:

Posted By: WebWiz-Bruce
Date Posted: 03 December 2007 at 6:58pm

Your web host will be able to give you the SQL Server login details.

If you need to reset the admin password in Web Wiz Forums then the following kb article explains how it can be done:-

http://www.webwiz.net/webwizforums/kb/admin_password_reset.asp - Web Wiz Forums - Admin Account Login / Password Reset

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: mAce
Date Posted: 03 December 2007 at 7:08pm

Thanks -boRg-,

But it's the SQL password i need to reset, I can't access the forum right now because the forum doesn't now the password to connect to the database I get a 500 error. How do I tell the forum what the new database password is?

Hope that makes sense.

Posted By: WebWiz-Bruce
Date Posted: 03 December 2007 at 7:26pm

Go back to the install documents, it tells you which file to edit and where:-

http://www.webwiz.net/webwizforums/kb/sql_server_install.asp - Installing SQL Server Version

These are version 9 install documents, but they are the same as for version 8.

You need to follow points 6 and 7.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: mAce
Date Posted: 03 December 2007 at 7:45pm

OK, but are you sure this won't overwrite the forum data by creating tables etc?

Posted By: mAce
Date Posted: 03 December 2007 at 8:05pm

I've followed the steps 6 and 7 and uploaded the file. I'm still getting HTTP 500 error. Is there anything else i need to do?

Posted By: WebWiz-Bruce
Date Posted: 04 December 2007 at 12:06am

If you turn off firendly HTTP errors in IE you get what the actual error is.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting