Web Wiz Forums SQL Server Upgrade
The following step by step guide describes how to upgrade the SQL Server version of Web Wiz Forums.
- IMPORTANT; Backup your existing SQL Server database. You may need to check with your web host as to what backup tools they give you. If you are using your own server make database backup using Microsoft SQL Server Management Studio.
- Use a zip utility program to extract the files to your hard drive keeping the original file structure intact.
- Using an FTP Program remove from your web space all the old files and images for the existing forum you want to upgrade, just keeping the uploads folder that contains content that your members have uploaded.
- Upload using your FTP Program the forum directory containing all the files and images onto your web space making sure that the files stay in their original directories.
- The forums database folder located at forum/database needs to have read, write, and modify permissions set on it, so that the installation wizard can write the database settings to the configuration files in this folder. Check with your web host that you have these permissions set, or if running the server yourself have a look at Setting Read, Write, and Modify Permissions.
- Type into your web browsers address bar the domain name and folder that you have uploaded the forum to.
The Web Wiz Forums installation/upgrade wizard will start automatically in your browser.
- Select the type of upgrade that you require then click Next.
- Select the database type that you are using. If you are using SQL Server 2005 or 2008 select Microsoft SQL Server 2005/2008. If you are using SQL Server 2000 then select Microsoft SQL Server 2000. Then click Next.
- On the Database Connection Page, enter your information as follows;
Once you have
filled in the fields, click Test Database Connection.
The Test Database Connection window will open, click Close Window
- Server - This will be the name or location of the SQL Server (URI, IP address, or localhost), you may also need to include the instance name (eg. localhost\SQLEXPRESS)
- Database Name - This is the name of the actual database
- Database Username - This will be the name of the user account you use to login into the SQL Server database
- Database Password - This will be the password that you use with the SQL Server Username above
If the connection was not successful go back to stage 9 and complete the connection details again. If the database connection was successful click Next.
The upgrade will now begin. This may take sometime to complete. Once it has completed you should see a message like the one below, click the Forum Homepage link to view your forum.
Your forum logins will remain the same including for any admin accounts.
If you find that you are getting errors and pages not displaying please see Troubleshooting and Common Errors.
About Web Wiz
| Contact Web Wiz
| Terms & Conditions
Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Unit B10, 9 Nimrod Way, East Dorset Trade Park, Wimborne, Dorset, BH21 7UH, United Kingdom.
Prices exclude VAT unless otherwise stated. VAT No. 988999105 - $, € prices shown as a guideline only.
Copyright ©2001-2017 Web Wiz Ltd. All rights reserved.