"Charles Kangai" <CharlesKangai@discussions.microsoft.com> wrote in message
news:8DF87E68-34B3-43CE-871B-4E62BB97DF78@microsoft.com...
> If it says "Login failed", it means the user is not even getting to
> connect
> to the database, let alone accessing the tables. You have to give the
> user's
> account access to the server and create a user account for them in the
> database being accessed, after which you give permission to tables. You
> say
> you have done this. Then what is the command line you are using? [BTW,
> there
> is no RunDTS.exe; you probably mean dtsrun.exe?] Please post your command
> line here and we will be able to look at it. Is the server in the same
> domain?
>
> Regards,
>
> Charles Kangai, MCT, MCDBA
>
> Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
> Services" http://www.learningtree.com/courses/134.htm
> Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
> http://www.learningtree.com/courses/523.htm
>
>
> "JoelB" wrote:
>
>> We are trying to embed RunDTS.exe into a batch file to kick off a DTS
>> package. The batch file is run by a user from their workstation. When
>> logged in as Administrator, it runs beautifully. When run by the user,
>> the
>> error listed at the end of this post occurs.
>>
>> The user cannot be allowed to be a sysadmin, but the documentation on the
>> subject seems a little vague, and we have not been able to get it to
>> work.
>> We created a login for the Windows user and gave them update perms to the
>> db
>> and tables being modified, and we set up SQLAgent/JobSystem permissions
>> (per
>> BOL *How to reset SQLAgent permissions*) to run under the same context as
>> the SQLAgent service is successfully running (a sysadmin account).
>>
>> Can anyone help?
>>
>> TIA,
>> JoelB
>>
>>
>> DTSRun: Loading...
>> DTSRun: Executing...
>> DTSRun OnStart: DTSStep_DTSExecuteSQLTask_3
>> DTSRun OnError: DTSStep_DTSExecuteSQLTask_3, Error = -2147467259
>> (80004005)
>> Error string: Cannot open database requested in login 'MyDatabase'.
>> Login fails.
>> Error source: Microsoft OLE DB Provider for SQL Server
>> Help file:
>> Help context: 0
>>
>> Error Detail Records:
>>
>> Error: -2147467259 (80004005); Provider Error: 4060 (FDC)
>> Error string: Cannot open database requested in login 'MyDatabase'.
>> Login fails.
>> Error source: Microsoft OLE DB Provider for SQL Server
>> Help file:
>> Help context: 0
>>
>>
>>