Installing Affiliate Wiz Version 4-9 for ASP.NET/SQL Server 2000+

Install Database

1. The Affiliate Wiz™ database is emailed as script file.   Follow these directions to create the database.
   support/SQLnewdb.asp
2. Now add a user for this new database.  support/SQLuser.asp

Install Program

1. Create a directory off of your main web site.  This directory will house the Affiliate Wiz™ software so give it a familiar name such as "affiliatewiz".  For example, if your domain name is http://www.yourdomain.com, you might create a directory called http://www.yourdomain.com/affiliatewiz/
   
   This directory must be made an Application Starting Point so that Affiliate Wiz can use it's own Global.asax file.  Click here for instructions on creating an application starting point.  Make sure on the ASP.NET tab that you have selected .net 2.0.
    
2. Unzip Affiliate Wiz™ into this directory.  Affiliate Wiz™ includes several sub-directories.   You must maintain this directory structure and include the sub-directories.   DO NOT PLACE A COPY OF OUR ZIP FILE ANYWHERE ON YOUR WEB SITE.
    
3. Set the database connection in the web.config file.  The variable is called DBConnectionString.
   
   <add key="DBConnectionString" value="Provider=sqloledb;Data Source=XXX.XXX.XXX.XXX;Initial Catalog=AffiliateWiz;User Id=AffiliateWiz;Password=yourpassword" />
   
   Server=The IP Address or physical server name of the SQL server
   UID=The Username you assigned to the database.  The default username is AffiliateWiz
   PWD=The password you assigned to the database
   DATABASE=The name of the database.  The default is AffiliateWiz
    
4. In order to use the file upload utility, you must give the Internet Guest Account WRITE permissions on the ads folder.   Click here for directions on setting write permissions.
    
5. Open the application in your browser (http://www.yourdomain.com/affiliatewiz/admin/default.aspx) and set the preferences and change the administrative name and password.  The username and password are currently set to Admin1/Admin1. 
    
6. Login and be sure to update the Preferences/SETUP area to reflect your particular server settings.  The setup defines important parameters used throughout the program. 
    

7. Congratulations!  Setup is complete and you can now move on to the Getting Started Guide.