Installing MSDE with Websense

I need to install MSDE SP4 to work with v7 of Websense. Where do I go to download it, and how do I set a password for it?

Microsoft SQL Server Desktop Engine (MSDE) is a free version of Microsoft SQL Server that is suitable for logging Websense Web filtering data in smaller networks. You can download this package from Websense, Inc., by clicking the link for your language. 
 
See the sections below for details on installing or upgrading MSDE on Windows Server 2003 to work with Websense Web Security or Websense Web Filter v7. (Microsoft does not support installing MSDE on Windows Server 2008.)
 

New Installation of MSDE

Before installing the MSDE downloaded from Websense, Inc., you must set a password for the sa user. Websense software uses the sa user name and the password you set here for database operations.
 
To set the password and install MSDE.

1. Download and extract the MSDE SP4 installation files. Note the location to which the files are extracted.
2. Decide on the password for the MSDE sa user. A strong password is recommended.
3. Use any text editor, such as Windows Notepad, to open the setup.ini file extracted from the MSDE download package.
4. Enter the password that you chose in step 1 on the sapwd= line.
   For example, if you wanted to use the password ABC123def, the entry would read:
   
   sapwd=ABC123def
   
   

   IMPORTANT	DO NOT leave the password setting blank. A blank password complicates, and may prevent installation of Websense software.

5. Save and close the setup.ini file.
6. Double-click the setup.exe file to install MSDE.
   A progress bar appears during installation, and closes when installation is complete.
7. Verify that MSDE is running:
   1. Go to Control Panel > Administrative Tools > Services.
   2. Double-click MSSQLSERVER on the list to open the Properties dialog box.
   3. Set Startup type to Automatic, if it is not already.
   4. Click Start to start the service, if it is not already started.
   5. Click OK to save the changes and close the Properties dialog box.
8. Install your Websense software on the appropriate machine.
9. When prompted, make the following choices:
   • Database access method:   SQL database account
   • User name:   sa
   • Password:   password established in step 3

You can preserve the security of the password by editing the setup.ini file and remove the password after installation is complete. Alternatively, you can delete the installation files from the system.
 

Upgrading to MSDE SP4
 
The procedure for upgrading to MSDE SP4 downloaded from Websense, Inc., varies, depending on whether a password has been set for MSDE SP3, or a blank password was previously used.
 
To determine which version of MSDE is currently installed:

1. Open a command prompt.
2. Log in to the database with the following osql commands: 
       
osql -U sa -P <password if set>
select @@version
go

If MSDE SP3 is installed, the version displays as 8.00.760. Follow the appropriate procedure, below, depending on whether a specific password was set for SP3, or a blank password was used.
 
If MSDE SP4 is installed, the version displays as 8.00.2039. If an explicit password is being used with SP4, no further steps are required before installing Websense software. However, if you are using a blank password with SP4, follow the procedure for setting a password, later in this article.
 
 
MSDE SP3 with Password Set
 
If a password was set for MSDE SP3:

1. Download and extract the MSDE SP4 installation files. Note the location where the files are extracted.
2. Open the ReadmeSql2kdesksp4.htm file included in the download package.
3. Go to section 3.2.2, step 3, and locate the command appropriate to your installation. You will use this command later in this procedure.
4. Open a command prompt and navigate to the location where the MSDE SP4 files were extracted in step 1.
5. Execute the command appropriate to your installation, from section 3.2.2, step 3, of the ReadmeSql2kdesksp4.htm file.
6. Verify the MSDE installation has been upgraded by entering the following commands:

   osql -U sa -P <password>
   select @@version
   go
   

7. Verify that MSDE is running:
   1. Go to Control Panel > Administrative Tools > Services.
   2. Double-click MSSQLSERVER on the list to open the Properties dialog box.
   3. Set Startup type to Automatic, if it is not already.
   4. Click Start to start the service, if it is not already started.
   5. Click OK to save the changes and close the Properties dialog box.
8. Install your Websense software on the appropriate machine.
9. When prompted, make the following choices:
   • Database access method:   SQL database account
   • User name:   sa
   • Password:   password established for SP3

   NOTE	If an error occurs after you make these entries correctly, enter them a second time to complete the installation successfully.

MSDE SP3 with Blank Password
 
If a blank password has been used for MSDE SP 3:

1. Download and extract the MSDE SP4 installation files. Note the location where the files are extracted.
2. Open the ReadmeSql2kdesksp4.htm file that downloads with the installer.
3. Go to section 3.2.2, step 3, and locate the command appropriate to your installation. You will use this command later in this procedure.
4. Open a command prompt.
5. Set a password for MSDE SP3 by entering the following commands: 
       
osql -U sa
   sp_password, @old=null,@new='<your chosen password>', @loginame='sa'
   go
     
6. Navigate to the MSDE directory.
7. Execute the command from the ReadmeSql2kdesksp4.htm file, section 3.2.2, step 3 (as noted above). This installs the MSDE SP4 files.
8. Verify the MSDE installation has been upgraded by entering the following command:

   osql -U sa -P <password>
   select @@version
   go

    

9. Verify that MSDE is running:
   1. Go to Control Panel > Administrative Tools > Services.
   2. Double-click MSSQLSERVER on the list to open the Properties dialog box.
   3. Set Startup type to Automatic, if it is not already.
   4. Click Start to start the service, if it is not already started.
   5. Click OK to save the changes and close the Properties dialog box.
10. Install your Websense software on the appropriate machine.
11. When prompted, make the following choices:
    • Database access method:   SQL database account
    • User name:   sa
    • Password:   password established for SP3

MSDE SP4 with Blank Password
 
If a blank password has been used for MSDE SP4:

1. Open a command prompt.
2. Set a password for MSDE SP4 by entering the following commands: 
    
osql -U sa
sp_password, @old=null,@new='<your chosen password>', @loginame='sa'
go

• Microsoft does not support installing MSDE on the Windows Server 2008 operating system.
• Websense v7.6 does not support MSDE. For v7.6 and later, use SQL Server 2008 R2 Express.