RE: Identity Problem Or Firewall??

From: Chris Podmore (ChrisPodmore_at_discussions.microsoft.com)
Date: 12/15/04


Date: Wed, 15 Dec 2004 03:29:02 -0800

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
>
>
>



Relevant Pages

  • Re: Cant connect to MSDE on SBS 2003
    ... SQL or Windows authentication on the server. ... From client workstations ... I can connect with Windows authentication but not SQL authentication. ...
    (microsoft.public.sqlserver.msde)
  • Re: Can change outlook profile without exprofe ?
    ... not sure *why* you'd ever use local accounts for users instead of domain ... Solli Moreira Honorio typed: ... I have migrated mailboxes from one standart server to a cluster ... services, even if I recreat the outlook profile, change registry keys ...
    (microsoft.public.exchange.admin)
  • RE: Active Directory Install
    ... If you're creating a new domain controller for a new domain, ... existing local accounts will be moved into your new domain. ... If this is a standalone server, couldn't you just use local policy to ...
    (microsoft.public.windows.server.active_directory)
  • Re: External Trust - Cant see share contents
    ... We placed a global group from the other domain into the ACL of the resource ... Windows Server 2003 Domain with an External Trust to the remote ... are Share = Local group with local accounts have Change. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Disable everything except for a web site authentication.
    ... Local accounts is not recommended, ... over the firewall to the frontend server inside ... What GPO settings, templates should we use to only allow this and nothing ... These users should not be able to logon to the network, ...
    (microsoft.public.win2000.security)