Article ID: 2814, created on Oct 29, 2007, last review on Apr 25, 2014

  • Applies to:
  • Pro Control Panel Windows

AdditionalInformation

View Knowledge
Knowledge ID 2217
Product : EnsimPro for Windows 2003
Version : 5.0.0
Topic : Hotfix

Title
Hotfix 1 : Effect of export-import on MSDE userrights

Summary
Addresses the issue "Effect of export-import on MSDE userrights"

Prevention


Details

Ensim® Pro for Windows 5.0.0 Hotfix 1 Release notes

Hotfix information

  • Service:Ensim Pro for Windows - 5.0.0
  • Hotfix no:1
  • Hotfix date:17-April-2006

Download: http://download.swsoft.com/ensim/download/pro/windows/5.0/hotfix/1/WWP-5.0.0-Hotfix-1.zip
md5sum : 6ff11535d06aa8355a54a619fc7d2767

Resolved Issues

This hotfix resolves the following issue.

  • Effect of export-import on MSDE user rights: when an MSDE database that contains tables, views, or stored procedures created by the site administrator is exported and then imported through the control panel, it becomes inaccessible to existing users.

    Resolution: When restoring a database, the site administrator and Web site user's permissions were being reset. This has been changed to retain the permissions as they were during the export operation.
     

Time requirements and customer impact

It takes a few minutes to apply the hotfix. During this time, new customers cannot be provisioned, and Ensim Pro control panel is unavailable. 

Installing the hotfix

This section explains how to install the hotfix.

Pre-installation instructions

Before installing the hotfix, you need to disable server applications. This section describes the pre-installation instructions.

  1. Ensure that you have installed all hotfixes mentioned in the prerequisites section unless they are marked as optional.
  2. Open a command window and run the command iisreset /stop.
  3. Disable the EnsimProvisionEngine service by logging in to server as server administrator and performing the following steps:
        a. Click Start > Programs > Administrative Tools > then click Component Services.
        b. In the left navigation bar, expand Console Root > Component Services > Computers > My Computer > COM+ Applications
        c. Right-click EnsimProvisionEngine, then select Shut down

The pre-installation procedure is complete.

Installation instructions

After performing the steps in the pre-installation section, complete the following steps to install the hotfix.

  1. Unzip the hotfix zip file to a temporary directory.
  2. Change to the directory <install_dir>\cp\admin\bin\serviceComponents\msde where <install_dir> refers to the path where Ensim Pro is installed. For example, if Ensim Pro is installed in C:\Program Files\Ensim\WEBppliance, then switch to C:\Program Files\Ensim\WEBppliance\cp\admin\bin\serviceComponents\msde directory.
  3. Back up the existing MSDEBackend.dll file to a location other than the existing directory.
    Important: Do not rename the file and keep it in the current directory.
  4. Copy the new MSDEBackend.dll from the temporary directory to the current directory.

Post-installation instructions

After installing the hotfix as described in the preceding section, perform the following steps to complete the hotfix installation.

1.      Open a command window and run the command iisreset /start.

The hotfix installation is complete.

Removing the hotfix

You can remove (or roll back) the installed hotfix by restoring the backed up DLL files    

To roll back the hotfix installation:

  1. Login to the server as administrator.
  2. Open a command window and run the command iisreset /stop.
  3. Stop the EnsimProvisionEngine COM+ component. Open Start > Programs > Administrative Tools > Component Services
    Navigate to : Computers > My Computer > COM+ Applications > EnsimProvisionEngine. Right Click > Shut Down
  4. Restore the MSDEBackend.dll file from the backup location to the directory <install_dir>\cp\admin\bin\serviceComponents\msde where <install_dir> refers to the path where Ensim Pro is installed. For example, if Ensim Pro is installed in C:\Program Files\Ensim\WEBppliance, then switch to C:\Program Files\Ensim\WEBppliance\cp\admin\bin\serviceComponents\msde directory.
  5. Open a command window and run the command iisreset /start.

The hotfix rollback is complete.


Attachments


Related Knowledge

Related Links
 
Last ModifiedUsageSatisfiedLast Used
9/18/2006 4:45:10 AM33 10/11/2007 4:43:54 AM

8e19bcddff0cc55cafe80c841132ca59 3ccb419cf98083f3bb45808fba8dbc7c 6311ae17c1ee52b36e68aaf4ad066387

Email subscription for changes to this article
Save as PDF