Identity Problem Or Firewall??

  • Thread starter Thread starter Sandeep
  • Start date Start date
S

Sandeep

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
 
Have you tried SQL authentication?
Because you are using local accounts I don’t think they will be
authenticated properly.
 
thanx chris,
but i cant use sql auth as my credentials will flow as free text over the
netowrk...
 
Thanx Allen.
I am confused from one aspect...
When i try to register the SQL Server (which is inside the firewall) thru
enterprise manager of App server (Outside Firewall) with SQL Auth, it
succeeds.
However the same registration fails when i do it with Windows Auth.( I get
the same error "sspi context")
I dont think it could be a problem with the ports. I believe there is
something wrong on the DB Server which i am not able to figure out.
 
Back
Top