Re: Identity OR Firewall???
From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 12/16/04
- Next message: X. Zhang: "Re: DTS: exporting data to csv file"
- Previous message: ATJaguarX: "Re: Problems launching DTS package from Stored Procedure"
- Maybe in reply to: Allan Mitchell: "Re: Identity OR Firewall???"
- Next in thread: Allan Mitchell: "Re: Identity OR Firewall???"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 16 Dec 2004 15:12:33 -0000
This is probably the firewall. If you don't allow certain ports between
servers and DCs, and servers and servers then you cannot use Windows Auth or
even maintain a domain. I have seen this exact error recently with a new
deployment, when the firewalls where locked down too far, although its
always a good base line to start from. Talk to your security people, that's
what I did.
-- Darren Green http://www.sqldts.com "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 > >
- Next message: X. Zhang: "Re: DTS: exporting data to csv file"
- Previous message: ATJaguarX: "Re: Problems launching DTS package from Stored Procedure"
- Maybe in reply to: Allan Mitchell: "Re: Identity OR Firewall???"
- Next in thread: Allan Mitchell: "Re: Identity OR Firewall???"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|