I've a sql server agent proxy account named "sqloper" with user privilege.
I login into my windows server with "sqloper" account, if I run a DTS with
dtsrun.exe command in a DOS session the DTS works fine, but if I create a job
with an application login (not SEVER ROLE applied) to execute the same DTS
(sql server agent proxy account is "sqloper") the job abort. The DTS execute
a "Analysis Services process task" and the error log is "Executed as user:
deepcdbn1coll\sqloper. ... DTSStep_DTSOlapProcess.Task_1 DTSRun OnError:
DTSStep_DTSOlapProcess.Task_1, Error = -2147221453 (80040033) Error
string: Cannot connect to the repository. Analysis server: DEEPCASCOLL
Error: Cannot open database ''. It may not be a database that your
application recognizes, or the file may be corrupt. Error source: DSO
Help file: Help context: 1000440 "
Why I read :Cannot open database '' , what happen? Why in a DOS session the
DTS works fine and wth a scheduled job the DTS abort ??

Thanks

Hello andrea,

When this happens it is invariably something to do with permissioning. Have
a read of this article and try a few things out on your boxes and let us
know how you get on.

http://support.microsoft.com/?kbid=269074


Also remember that DTS is a client application and as such runs on the box
that says "go". This means you executing a package on ServerA from your
Wkstn is very different from you executing a package on ServerA from the
server itself.


Allan

Hi, I've already read http://support.microsoft.com/?kbid=269074 , but don't
help me.
I don't use client o workstation. I work on the server.
I was connected to the serverA with windows account "sqloper" (users groups)
and I run DTS with dtsrun.exe in a DOS session or with Enterprise Manager
installed on the serverA and connected with a login without any "server role".

Bye



"Allan Mitchell" wrote: