Posted by Erland Sommarskog on 03/22/06 01:02

mike (mike.a.rea@gmail.com) writes:
> I have a question. I am doing some work for someone and I have a batch
> file that they can run that will execute an OSQL line and a DTSRUN
> line. In both lines I run them using the /S /U /P switches and of
> course the /N or /i switch to tell it what to run. I have also tried
> replacing the /U /P switches with the /E switch.
>
> My problem is that as long as I specify the users password on the OSQL
> line (either with /U & /P or with /E & /P) it will run. If I try and
> just use the /E it will say password failed for DOMAIN/USER . Ok, I
> don't really care I can specify the password and the script will run.

When I try /E and /P with OSQL, I get "Error: Conflicting switches : -E and
-P"

And the message with /E only, would not really be a about password, but
something like "not associated with a trusted connection".

> However no matter what I do the DTSRUN line will not run, it gives me
> this same password error.
>
> I can run this line just fine on my PC on my network and my domain
> using just the /S /E switches.
>
> Any ideas as to why it will work for OSQL but not DTSRUN?

Apparently trusted connection does not work to your customer's domain.
In that case you need to use SQL authentication, but that is not on
the form DOMAIN/USER.

It could help little if you posted the exact command lines you are
using, and the error you get with each line.

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]