Re: Identity OR Firewall???

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 12/16/04 

Date: Thu, 16 Dec 2004 06:16:08 -0000

Do you have the DTS dlls on your Web box?

I would also run through this article

http://support.microsoft.com/?id=811889 

-- 
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good.  here we show you the new stuff.
www.konesans.com - Consultancy from the people who know
"Sandeep" <m_sandeep78@indiatimes.com> wrote in message 
news:evhN3Fy4EHA.3820@TK2MSFTNGP11.phx.gbl...
> Thanx Allan
> My code to connect to SQL is working fine with windows authentication.
> The only grey area is invoking DTS packages which is unmanaged for .Net.
> I can run my Stored Proc with current approach.
> The reason i am not going for SQL Authentication is that my credentials 
> are
> flowing as free text over the wire and anybody can sniff it.
> Hope you understand my concern.
>
> "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
> news:emeUnxu4EHA.1524@TK2MSFTNGP09.phx.gbl...
>> Cannot Generate SSPI context would mean that you cannot authenticate
> against
>> a domain controller.  Have you tried using SQL Server security?
>>
>> Also
>>
>>
> http://support.microsoft.com/default.aspx?scid=kb;en-us;287932&Product=sql2k
>>
>> By default Your SQL Server will be listening on 1433.  Is that open?
>>
>> -- 
>>
>>
>>
>> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
>> www.SQLDTS.com - The site for all your DTS needs.
>> www.SQLIS.com - You thought DTS was good.  here we show you the new 
>> stuff.
>> www.konesans.com - Consultancy from the people who know
>>
>>
>> "Sandeep" <m_sandeep78@indiatimes.com> wrote in message
>> news:%23Yw0b$o4EHA.2788@TK2MSFTNGP15.phx.gbl...
>> > All,
>> >    First let me explain My Application's deployment scenerio.
>> >    My Application server is on win2003 + IIS6.0.
>> >    I created a local user called XYZ on the server. My web 
>> > application's
>> > pool run under this user's identity.
>> >    The DB machine (SQL Server 2000)on which the DTS is present is 
>> > having
>> > the same local account with the same credentials.
>> >    In my code i am loading a DTS package by calling function
>> > LoadFromSQLServer. I am using trusted connection as one of the
> parameters.
>> >    When this line of code is executed i get the following error
>> >    "System.Runtime.InteropServices.COMException: Cannot generate SSPI
>> > context"
>> >    My App server and DB server are separeted by a firewall.
>> >
>> >    I dont get any error if my App server and DB Server are in the same
>> > domain ( witout firewall).
>> >    Can anybody help me out??
>> >
>> >
>> > Thanx in advance
>> >
>> >
>>
>>
>
>

Relevant Pages