dbTalk Databases Forums  

dtsrun utility with only windows authentication.

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss dtsrun utility with only windows authentication. in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
AT
 
Posts: n/a

Default dtsrun utility with only windows authentication. - 07-24-2006 , 02:47 PM






Hi,

I am trying to run the dtsrun utility in a "Windows only"
authentication mode. For the -U and
-P option, i am providing my network user id (domainname\userid) and
network password. However I get an error saying that "Error string:
Login failed for user LOCALNETWORK\KRAO'. Reason: Not associated with a
trusted SQL Server connection.". However, when I use the Mixed Mode
Authentication i.e. windows and sql server authentication, I am able to
run the dtsrun utility without any issues.

Is there a way to run this utility in the "Windows Only" Authentication
mode?

Thanks,
KP


Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: dtsrun utility with only windows authentication. - 07-24-2006 , 04:54 PM






Hello kpraoasp (AT) yahoo (DOT) com,

The U and P are to log onto the Storage SQL Server using SQL Server Authentication.
How about using /E ?




Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Quote:
Hi,

I am trying to run the dtsrun utility in a "Windows only"
authentication mode. For the -U and
-P option, i am providing my network user id (domainname\userid) and
network password. However I get an error saying that "Error string:
Login failed for user LOCALNETWORK\KRAO'. Reason: Not associated with
a
trusted SQL Server connection.". However, when I use the Mixed Mode
Authentication i.e. windows and sql server authentication, I am able
to
run the dtsrun utility without any issues.
Is there a way to run this utility in the "Windows Only"
Authentication mode?

Thanks,
KP



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.