JSP connection ms SQL Server2000 installation Configuration

Notes for installing ms SQL Server2000 in xp sp3:

1. The files to be downloaded include:

(1) sqlserver2000 Personal Edition

(2) SQL Server2000 JDBC driver

(3) Microsoft SQL Server 2000 Service Pack 4 Simplified Chinese version

2. During installation, in the "service account" dialog box, select "use local SYSTEM account ". We do not recommend that you use a domain user account to avoid changing the user name and password for Windows later,SQLServer2000 cannot be started normally, and the management of external domain user accounts is more complicated.
3. Select "select hybrid mode". We do not recommend "Windows Authentication Mode". This mode is more complex to manage. After installation, you can modify it in the Enterprise Manager.

4. After the JDBC driver is installed, copy the three. Jar files under the/Microsoft SQL Server 2000 driver for JDBC/lib directory to the WEB-INF/lib directory of the project.

5. After the SP4 is compressed to the C:/sql2ksp4 directory, click setup. BAT to install it. Previously, it was only decompressed and not installed. I did not execute the installation step, resulting in dB connection failure.

6. the "Enterprise Manager" in the "Create a database and a table" menu is easy to use. It is a graphical operation, similar to the creation of an Access database. If you want to use an SQL file, you can select "query analyzer" from the Start Menu ".

 

Note the preceding steps. After the SQL Server server is started, configure the JSP connection.