Search KB

	Advanced Search

Featured Articles

	Web Wiz Forums Home Install SQL Server Ver. Install mySQL Version Install Access Version Secure Access DB Common Errors Search KB

Web Wiz Forums SQL Server Installation

1. Check with your web host that your web space meets the system requirements for running Web Wiz Forums SQL Version
    
2. Make sure that you have a SQL Server Database (SQL Server 2000, 2005, MSDE, or 2005 Express) and that you have the required login details to connect to your SQL Server Database.
    
3. Uses a zip utility program to extract the files to your hard drive keeping the original file structure intact.
   
4. Using an FTP program upload the forum directory containing all the files and images onto your web space making sure that the files stay in there original directories.
   
   
5. Create a blank database on the SQL Server or use an existing one. If you are using a web host they should supply you with your SQL Sever Database, connection details, and login information. If you are using your own server use Microsoft SQL Management Studio(pictured below) to create the database on the SQL Server.
   
6. Edit, with a text editor, the file 'database_connection.asp' found in the 'database' directory entering your SQL Servers details, where indicated;
   
   
• SQL Server Name - 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)
• SQL Server Username - This will be the name of the user account you use to login into the SQL Server database
• SQL Server Password - This will be the password that you use with the SQL Server Username above
• SQL Server Database Name - This is the name of the actual database

7. Once you have finished editing the 'database_connection.asp' save the file back to the 'database' directory keeping the file name the same.
   
   
8. The next step is to call the web page 'msSQL_server_setup.asp' found in the main folder of the Forum in your web browser using the URL to this page. This tool will create all the tables, relations, and default values in your SQL Server Database.
   
   
   
   
9. When you run the 'msSQL_server_setup.asp' tool you will be asked for your SQL Server Username and Password again. This is done for security and because sometimes you have a different login username for creating and altering tables on the SQL Server.
   
   
10. After the 'msSQL_server_setup.asp' has successfully completed you should delete this file as it should not be run again and will prevent hackers from misusing the file.
     
11. The Forum database should now be created and you can now use Web Wiz Forums.
     
12. Once all the files are uploaded type into your web browsers address bar the domain name and folder that you have uploaded the forum to.
    
13. Now that your forum is uploaded and running see, Logging into the online Admin Control Panel, to find out how to set up forums and administer your Web Wiz Forums installation.
     
14. If you find that you are getting errors and pages not displaying please see Troubleshooting and Common Errors.
     
15. To login into the forum the default admin username and password is: -
     
    • Username: Administrator
    • Password: letmein