|
Home > Archive > Microsoft SQL Server forum > April 2005 > Run DTS package
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Marios Koumides 2005-04-18, 7:23 am |
| Hello !
I have a DTS package which I can run it fine from command line using
one SQL account who is not a also a user in the windows 2003
machine.If I try as another user that is a user or sysadmin account in
the box then I get a login error from OLE. Any ideas? When I use the
Enterprise Manager to run the package it runs fine regardless of the
user.
Many Thanks,
Marios Koumides
| |
| Simon Hayes 2005-04-18, 7:23 am |
|
"Marios Koumides" <koumides@gmail.com> wrote in message
news:f0e6dfb6.0504180147.2807f984@posting.google.com...
> Hello !
>
> I have a DTS package which I can run it fine from command line using
> one SQL account who is not a also a user in the windows 2003
> machine.If I try as another user that is a user or sysadmin account in
> the box then I get a login error from OLE. Any ideas? When I use the
> Enterprise Manager to run the package it runs fine regardless of the
> user.
>
>
> Many Thanks,
> Marios Koumides
It's not really clear (to me) from your description exactly who is running
the package, and where it's executing. Are you running it with dtsrun.exe?
Are you running it on the server, or on your workstation? Can the users who
cannot run the package log in to MSSQL, or only to Windows? Are you using
Windows authentication or SQL logins for MSSQL? What exactly is the error
message? Which version of MSSQL do you have?
As a complete guess, the package contains MSSQL connection objects which use
Windows authentication, so it fails when you run it with a Windows user
which cannot log in to those MSSQL servers. But without more information,
that may be totally wrong.
Simon
| |
| koumides@gmail.com 2005-04-22, 7:23 am |
|
Simon Hayes wrote:
> "Marios Koumides" <koumides@gmail.com> wrote in message
> news:f0e6dfb6.0504180147.2807f984@posting.google.com...
using[color=darkred]
in[color=darkred]
the[color=darkred]
the[color=darkred]
>
> It's not really clear (to me) from your description exactly who is
running
> the package, and where it's executing. Are you running it with
dtsrun.exe?
I tried 2-3 users and they can run the package using dtsrun.exe but
providing a username and password different from theirs.(This username
and password is not a windows user but MS-SQL one)
> Are you running it on the server, or on your workstation?
Running it on the server.
> Can the users who cannot run the package log in to MSSQL, or only to
>Windows?
They can log to both SQL and Windows
Are you using Windows authentication or SQL logins for MSSQL? What
exactly is the error
> message? Which version of MSSQL do you have?
>
Yes I am using windows authentication in MS SQL 2000.
The error message is they can't login MS SQL 2000
Many Thanks,
Marios Koumides
> As a complete guess, the package contains MSSQL connection objects
which use
> Windows authentication, so it fails when you run it with a Windows
user
> which cannot log in to those MSSQL servers. But without more
information,
> that may be totally wrong.
>
> Simon
|
|
|
|
|