MS SQL Server Password Help

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
mAce Members Profile Find Members Posts Newbie Joined: 16 July 2007 Status: Offline Points: 20	Post Options Post Reply Quote mAce Report Post Thanks(0) Quote Reply Topic: MS SQL Server Password Help 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

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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:- Web Wiz Forums - Admin Account Login / Password Reset
	Web Wiz Forums Hosting ASP.NET Web Hosting

mAce Members Profile Find Members Posts Newbie Joined: 16 July 2007 Status: Offline Points: 20	Post Options Post Reply Quote mAce Report Post Thanks(0) Quote Reply 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.

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 03 December 2007 at 7:26pm
	Go back to the install documents, it tells you which file to edit and where:- 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

mAce Members Profile Find Members Posts Newbie Joined: 16 July 2007 Status: Offline Points: 20	Post Options Post Reply Quote mAce Report Post Thanks(0) Quote Reply Posted: 03 December 2007 at 7:45pm
	OK, but are you sure this won't overwrite the forum data by creating tables etc?

mAce Members Profile Find Members Posts Newbie Joined: 16 July 2007 Status: Offline Points: 20	Post Options Post Reply Quote mAce Report Post Thanks(0) Quote Reply 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?

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 04 December 2007 at 12:06am
	If you turn off firendly HTTP errors in IE you get what the actual error is.
	Web Wiz Forums Hosting ASP.NET Web Hosting

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.