469,898 Members | 1,733 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,898 developers. It's quick & easy.

Run DTS package

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
Jul 23 '05 #1
2 3301

"Marios Koumides" <ko******@gmail.com> wrote in message
news:f0**************************@posting.google.c om...
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
Jul 23 '05 #2

Simon Hayes wrote:
"Marios Koumides" <ko******@gmail.com> wrote in message
news:f0**************************@posting.google.c om...
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?

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


Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Petterson Mikael | last post: by
10 posts views Thread by datapro01 | last post: by
6 posts views Thread by Page Horton | last post: by
3 posts views Thread by shorti | last post: by
debasisdas
reply views Thread by debasisdas | last post: by
debasisdas
reply views Thread by debasisdas | last post: by
debasisdas
reply views Thread by debasisdas | last post: by
reply views Thread by Steven Samuel Cole | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.