I suspect that I am running into an NT authentication
issue here and I have no clue what to do about it.

I have a DTS package that selects data from a SQL Server
database and imports it into Oracle. I can run the
package just fine. My backup developer can run the
package from her machine just fine. However, the user can
not run it. She gets the following error message:

Error: -2147217843 <80040E4D>; Provider Error: 18456
<4818>

Error string: Login failed for user 'MYDOMAIN\USERNAME'
Error source: Microsoft OLE DB Provider for SQL Server

If I log in as myself on the user's machine, I can run the
DTS package (I have it being executed from a batch file).
The DTS package use NT Authentication to connect to SQL
Server.

I have no idea where to start looking for NT permission
issues.

Help!!

Does the user have a login for SQL Server? Looks like that's
missing to start with. When she runs the package, it will
execute under her security context so she needs the
appropriate server and database permissions.

-Sue

On Wed, 12 May 2004 15:31:17 -0700, "Jill"
<anonymous (AT) discussions (DOT) microsoft.com> wrote:

Hi Jill,

You will have to add the Windows Login to the SQL Server for authentication.
Give them access to the required database(s)
Also give them access to the required Objects in the database(s).

A way to achieve this is

1. Create a Role in the Required Database(s)
2. Give permission to the role
3. from the Security -> Login

Click on the Action -> New Login Menu Option

A Dialog Box will popup.
Enter "Domand\UserName" for Name
Select windows Authentication
Select Grant Access
In the Database Access
Select the Required Database(s)
Select the appropriate Role(s)

This will create a login for the Windows user in SQL and give the user
access to the required objects.


HTH
Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.

Yes, she does. She is running the DTS package from a SQL
Server application called Maximo. And when I look in
Enterprise Manager, she is set up as a user.

Hi Ashish -

My user already has a login to SQL Server and has access
to the required objects. The DTS Package is being
executed through a SQL Server Application called Maximo.
When I log on to her computer as me and then log into
Maximo as her, the package completes successfully. It is
fails when she logs in to her computer and logs into
Maximo as herself that it fails.

: (

Hi Jill,

Since, "When I log on to her computer as me and then log into
Maximo as her, the package completes successfully. It is
fails when she logs in to her computer and logs into
Maximo as herself that it fails", what I feel is that her windows login has
not been added to the SQL server.


Ashish
This posting is provided "AS IS" with no warranties, and confers no rights.

It doesn't appear that she does have a login. Being that you
get the error:
Login failed for user 'DOMAIN\USERNAME'
maybe you are seeing a SQL Server login for the user in SQL
Server. Whatever you are running is using Windows
Authentication and she needs to have a windows login.

-Sue

On Thu, 13 May 2004 06:55:57 -0700, "Jill"
<anonymous (AT) discussions (DOT) microsoft.com> wrote: