dbTalk Databases Forums  

Identity Problem Or Firewall??

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


Discuss Identity Problem Or Firewall?? in the microsoft.public.sqlserver.dts forum.



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

Default Identity Problem Or Firewall?? - 12-15-2004 , 04:15 AM






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





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.