Re: Package will not authenticate

From: David Pendleton (qnircra@gpd.arg)
Date: 03/08/03 

From: "David Pendleton" <qnircra@gpd.arg>
Date: Sat, 8 Mar 2003 09:08:54 -0600

That's the odd thing. I use DTSRUNUI to run the package on my workstation
(logged in as me, of course). After several seconds, the package fails with
an error. I get the same result in EM.

When I design the package, I can work with the connections just fine, but
when I attempt to examine the transformations, I get the same error. The
transformation was set up to run a stored procedure on the remote server and
bring the data down to the local server.

This all worked once upon a time. Of course no one responsible for this
machine has any idea what changed. :) 

--
ROT13 my email address to reply: qnircra@gpd.arg
"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:e0LmLgV5CHA.2308@TK2MSFTNGP11.phx.gbl...
> Hello, David!
>
> So what happens when you manually run the package itself as you. ?
>
> Can you get NT authenticated connections to the other box from the Package
> box ?
>
> --
>
> Allan Mitchell (Microsoft SQL Server MVP)
> MCSE,MCDBA
> www.SQLDTS.com
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>
> : Within the package, connections are set up to use NT authentication.
>
> : When I execute the package from my workstation via DTSRUNUI, I am told
the
> : SQL Server does not exist or access denied. I am a domain administrator,
I
> : can connect to both the source and target servers;
BUILTIN\Administrators
> : belongs to the 'System Administrators' system role on both servers as
> well.
> : The package will also not run when scheduled. The account the SQL server
> : agent runs under is a domain account, configured as a system
administrator
> : on both servers.
>
> : If I change the connections to use SA, all works as designed.
>
> : Any ideas?
>
> : Thanks for your response.
>       ---  Microsoft Outlook Express 6.00.2720.3000
>
>

Relevant Pages

  • TSLSA-2007-0007 - multi
    ... Affected versions: Trustix Secure Linux 2.2 ... The mod_php module enables the Apache web server to ... The postgresql package includes the client programs and libraries ... SECURITY Fix: Fetchmail does not properly enforce TLS and may ...
    (Bugtraq)
  • Re: defining server roles
    ... >> This is mostly about a) separating system update package repositories, ... a backup Web server in a departmental network ... > line separating workstation from server as there is in the MS world ... > reliable guide to the package update requirement is the set of packages ...
    (comp.os.linux.security)
  • Re: remotely call a DTS
    ... Allan Mitchell wrote: ... Denied on something inside the package. ... This worked when I was logged into the server and ran it from my ... but the DTS blows up. ...
    (microsoft.public.sqlserver.dts)
  • Re: sunmanagers Digest, Vol 34, Issue 14
    ... Christopher sent me a link to ftp.cs.tu-berlin.de that has all patches sun ... Subject: SUMMARY: Setting up mail on a Solaris Server ... however I seem to be having issues finding a binary package. ... Problems while installing 108528-29 for Sol8 machine ...
    (SunManagers)
  • Re: DTS Environment Control
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. ... When run from the production environment, the production server is accessed and when run from the test environment, the test server is accessed. ... For simple packages it's not too big of deal - but for more complete ones - you can spend an hour carefully changing all your connections. ... I had one solution where we would add an ActiveX script task as the very first step, that would determine what SERVER the package was executing from - and based on that would dynamically change all the connections by looking up the package name and server from a DB. ...
    (microsoft.public.sqlserver.dts)