[ Pobierz całość w formacie PDF ]
.5.Now, execute the absolutels.sql script in order to create the tables andqueries in the new database.From the Tools menu of the EnterpriseManager, select SQL Server Query Analyzer.6.From within the Query Analyzer, open the absolutels.sql script file.Makesure to select the absolutels database from the database drop-down menu.7.Execute the script by clicking the Execute Query Button or pressing F5.Ifexecuted successfully, you ll see a Query Batch Completed message at thebottom of the screen.8.In order to optimize the database, right click on the absolutels database from within Enterprise Manager.Select Properties and under the Options tab, check the Auto shrink property.Now let s add a user for the database.7 Note :When executing the script some warnings may appear.This is a normal behavior and it is due to the fact that the database usesseveral variant fields.Also, if you re running the script on a SQL Server 7, some syntax errormessages may arise.However this seems to not affect the applicationperformance and no problem has been currently reported by customersusing this database server.Adding a New User for the absolutels database (MS SQL Server 2000)1.Within the SQL Server Enterprise Manager, expand the tree down toSecurity.2.Right click on Logins and select New Login.3.Enter the name as absolutels and select SQL Server authentication.4.Enter an unique password (please take note of your password, you llneed it later).5.Under Database select the absolutels database and click on the Database Access tab.6.Click the Permit check box for the absolutels database then check thedb_owner box under Permit In Database Role .7.Click OK and enter your password confirmation.Installing Absolute Live Support on your web siteAbsolute Live Support and the MS Access database are e-mailed to you in azipped file (.zip).Follow these instructions to set-up the Absolute Live SupportSystem for your site :1.Create a sub-directory in your site s root directory.This directory willhouse the Absolute Live Support Software so, it s a good idea to give it aname such as absolutels .For example, if your domain is http://www.something.com, then you mightcreate a directory called http://www.something.com/absolutels8 2.Extract the contents of the Absolute Live Support zip file into thisdirectory.The Absolute Live Support system includes several sub-directories.You must maintain this directory structure and includethose sub-directories.Note:Some hosting companies require you to place your databases in aspecially assigned directory.If this is the case, you ll need to alter theAbsolute Live Support Structure.Please refer to the troubleshootingsection to see how to work around this.WARNING! : DO NOT PLACE A COPY OF OUR ZIP FILES ANYWHEREON YOUR SITE.By doing this you ll be allowing your users todownload the application without owning a license.You ll beviolating the License Agreement and intellectual property rights.3.Now, set the permissions for the newly created absolutels directory toallow read and write permissions, allow files to be browsed and allow scriptsto be run.You can optionally turn off browser permissions on the databasefolder (db folder) so that users cannot download the MS Access database.4.If you are using the Access database then skip to step 5.Otherwise, ifyou re using a SQL Server Database use a text editor (Notepad will workfine), and open the databasedata.asp script file to configure it properly:You ll see the following code (we have colored and numbered the lines forexplanation purposes):
[ Pobierz całość w formacie PDF ]