Usage Import Scheduler Returns Error 70 Permission Denied

ID: Q216118

The information in this article applies to:

Microsoft Site Server version 3.0

SYMPTOMS

A Usage Import scheduled task may fail with the following error message:

UImport date time sa@Databse/ua_online Error: Couldn't open database Error 70 Permission denied Couldn't connect to: UA_Online

CAUSE

The task is executed in the security context of the user who was logged on to the computer when the task was scheduled. If this user logs off the computer, and then another user who does not have sufficient permission logs on to the computer, the scheduled task fails.

WORKAROUND

To work around this problem, follow these steps using the Distributed COM Configuration Properties:

Run DCOMCNFG on the Analysis server. On the Start menu, choose Run and type "DCOMCNFG" (without the quotation marks). In the Distributed COM Configuration Properties Application tab, scroll through the application list, and verify that the UAS Controller API is present. You do not have to select it.

Select the Default Security tab at the top of the dialog box. This change will affects all applications.

Click Edit Default in the Default Access Permissions frame. In the Registry Value Permissions window, click Add. Change the list names from your Domain to your local computer. Locate the local Site Server Analysis Administrators group and choose Allow Access. Click OK until you leave the Registry Value Permissions window.

Click Edit Default in the Default Launch Permissions frame. As above switch the list names to your local computer. Then add the local Site Server Analysis Administrators group and choose Allow Launch. You will need to change the Domain to your local computer. Click OK until you leave the Registry Value Permissions window.

Restart your server.

This procedure assumes that the user context under which you are running the import is in the Site Server Analysis Administrators group (as the documentation prescribes). It is only when both of these permissions are set and you have restarted the server that the import then proceeds without generating the permissions error.

STATUS

Microsoft has confirmed this to be a problem in Site Server version 3.0.

MORE INFORMATION

Microsoft Internet Explorer version 4.01 adds a Scheduled Task icon to the Administrative Tools (Common) group in the Start Programs menu. This is a graphical extension of the AT schedule command. When a task created with the AT scheduler is modified in the Scheduled Task interface, it is no longer visible with the AT command. Site Server Usage Import uses the AT scheduler. Therefore, if a task is modified in the Scheduled Task interface, Usage Import will generate the following error message:

Couldn’t unschedule existing task

The task is then re-created by Usage Import. This causes the task to run twice. As long as the Usage Import Schedule window is open, the task will not run. The task is scheduled when the window is closed. For more information, see the following article in the Microsoft Knowledge Base:

ARTICLE-ID: Q193042
TITLE : Site Server and Windows NT Task Scheduler Conflict

Additional query words:

Keywords : SS3SP2Fix
Version : winnt:3.0
Platform : winnt
Issue type : kbbug