Configuring ViewPoint with Microsoft SQL Server 2000

VIEWPOINT Configuring ViewPoint with Microsoft SQL Server 2000 Introduction Many customers inquire whether Viewpoint will work with Microsoft SQL Server 2000 (MS SQL Server). Viewpoint can be configured to run with MS SQL Server, but SonicWALL does not provide any technical support for this configuration . Due to the number of inquiries, this document is provided only as a courtesy to our advanced SQL Server savvy customers that want to use this configuration. This document presents a procedure to remove the MSDE …

9) Edit \Tomcat\webapps\sgms\WEB-INF\web.xml and modify the following lines:
dbhost 127.0.0.1\SNWL dburl jdbc:inetdae7a:127.0.0.1/SNWL dbuser BAB7E1B 9875 CF081 dbpassword EE80851182B4B962FC3E0EDF1 F00275A to
dbhost 127.0.0.1\SNWL dburl jdbc:inetdae7a:127.0.0.1/SNWL dbuser BAB7E1B 9875 CF081 dbpassword EE80851182B4B962FC3E0EDF1 F00275A to dbhost 127.0.0.1 dburljdbc:inetdae7a: localhost: 1433 …. dbhost 127.0.0.1 dburl jdbc:inetdae7a: localhost: 1433 dbuser Us ern a me dbpassword Password Note : Replace localhost and 127.0.0.1 if the SQL Server 2000 database is running on a remote machine and not on the ViewPoint server. Note : Replace Username and Password with the encrypted strings generated earlier with the java command in step 5. 10) Backup the existing \SQL\bldMSDB.bat. 11) Go to the SQL Server 2000 Database. Before installing SonicWALL Viewpoint using Microsoft SQL Server 2000, complete the following procedure: a. Install Microsoft SQL Server 2000 on a server. b. When prompted, select “Create a new instance of SQL Server, or install Client Tools” option. c. When prompted, select the “Server and Client Tools” option. d. When prompted, select the “Typical” setup type. e. When prompted for an authentication mode during SQL Server 2000 installation, make sure to select Mixed Mode . Do not select Windows Authentication Mode . After successfully installing SQL server 2000, Service Pack 4 or later needs to be applied. f. Once the database is installed, click Start , point to Programs , point to Microsoft SQL Server , and click Enterprise Manager . g. Expand the Security tree. Right-click Lo gins and select New Login . h. Create a SonicWALL Viewpoint database user (The non-encrypted text of the username you decided on in step 5 with the java command). For this database user, select the SQL Server Authentication mode option and enter the non-encrypted password for this user. Make sure to assign this user the Database Creator server role. i. Exit from the SQL Server Enterprise Manager.