Re: NT Authentication Issue

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Jill (anonymous_at_discussions.microsoft.com)
Date: 05/13/04 

Date: Thu, 13 May 2004 06:55:57 -0700

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.

>-----Original Message-----
>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@discussions.microsoft.com> wrote:
>
>>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!!
>
>.
>

Relevant Pages

  • global variable not working
    ... which sets a global variable in the DTS package and then the stored procedure ... It all works on the development server! ... problem I am having is that I have moved the DTS package up to our Test sql ...
    (microsoft.public.sqlserver.dts)
  • RE: Multiple loops in one package?
    ... this is not currently support in SQL 2000 DTS package. ... | I know how to loop through one set, but wasn't sure if there was an easy ... | Get next server from Server recordset --a ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS Packages fail when executed from Jobs
    ... I have tried running the DTS package on the server whilst logged on as the ... DTSRUN.EXE or through the SQL Server Enterprise Manager. ... >> I am having trouble executing a DTS package from a SQL Job. ...
    (microsoft.public.sqlserver.dts)
  • RE: DTS, .NET and remote servers
    ... Server A is running SQL 2000 and in domain X ... Server B is running IIS and host web-sevvice, ... I wish my web-service to trigger a DTS import on server A. The ... demonstrating the DTS package is loaded and accessible on Server B). ...
    (microsoft.public.sqlserver.dts)
  • Global Variable - Output Parameter not returning value
    ... I have SQL 2000 DTS package transfers data from one server to another ... In output parameter i have created Global variable with output parameter ...
    (microsoft.public.sqlserver.dts)