Identity Problem Or Firewall??

[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

[Chris Podmore]

Have you tried SQL authentication?
Because you are using local accounts I don’t think they will be
authenticated properly.
"Sandeep" wrote:

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

[Sandeep]

thanx chris,
but i cant use sql auth as my credentials will flow as free text over the
netowrk...

"Chris Podmore" <Ch**********@discussions.microsoft.com> wrote in message
news:53**********************************@microsof t.com...

Have you tried SQL authentication?
Because you are using local accounts I don't think they will be
authenticated properly.
"Sandeep" wrote:

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

[Scott Allen]

It could well be a firewall issue. There is some information and links
in the following article, hope this helps out:
http://support.microsoft.com/?id=811889

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Wed, 15 Dec 2004 15:44:35 +0530, "Sandeep"
<m_*********@indiatimes.com> wrote:

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

[Sandeep]

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.

"Scott Allen" <bitmask@[nospam].fred.net> wrote in message
news:cj********************************@4ax.com...

It could well be a firewall issue. There is some information and links
in the following article, hope this helps out:
http://support.microsoft.com/?id=811889

--
Scott
http://www.OdeToCode.com/blogs/scott/

On Wed, 15 Dec 2004 15:44:35 +0530, "Sandeep"
<m_*********@indiatimes.com> wrote:

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