Re: Cannot Generate SSPI Context - help

From: Manohar Kamath [MVP] (mkamath_at_TAKETHISOUTkamath.com)
Date: 09/15/04

  • Next message: Bob Barrows [MVP]: "Re: How do you SELECT a list of words with commas in SQL from a column?" 
    Date: Wed, 15 Sep 2004 15:03:27 -0500

    Almost correct...

    The IUSR_<> account on the machine, should have Windows authentication
    rights on the remote SQL server. That way, you do not include the userid and
    password in the connection string. When a connection is "trusted," it means
    the user who is requesting the connection is a user on the SQL server as
    well. 

    -- 
Manohar Kamath
Editor, .netWire
www.dotnetwire.com
"Laphan" <news@DoNotEmailMe.co.uk> wrote in message
news:uyxcVo0mEHA.392@tk2msftngp13.phx.gbl...
> Dear Manohar
>
> Thanks for your reply.
>
> If I'm reading your email right, they do have Administrator set up as a
> Windows authenticated user that connects to an SQL Server DB successfully.
> I know this because they have a remote user that connects via a software
> router to an ODBC connection on the SQL Server and this remote user uses
> Administrator and the relevant password to get in.
>
> However when I tried to the Administrator and relevant password in my
> connection string I received the exact same error message as below.
>
> How would one connect to a remote SQL Server using Windows authen?
>
> Rgds
>
> Robbie
>
>
> Manohar Kamath [MVP] <mkamath@TAKETHISOUTkamath.com> wrote in message
> news:OPlUqA0mEHA.3352@TK2MSFTNGP15.phx.gbl...
> The user context (as in the NT name) of the connection should be
registered
> with the remote SQL server as a windows authentication user. Have you done
> this?
>
> --
> Manohar Kamath
> Editor, .netWire
> www.dotnetwire.com
>
>
> "Astra" <info@NoEmail.com> wrote in message
> news:e%23U5UHzmEHA.2708@TK2MSFTNGP10.phx.gbl...
> > Hi Bob
> >
> > Thanks for coming back to me.  Now I get the following error:
> >
> > Microsoft OLE DB Provider for SQL Server error '80004005'
> >
> > Login failed for user 'rob'. Reason: Not associated with a trusted SQL
> > Server connection.
> >
> > /stocklevels.asp, line 82
> >
> > Any ideas why?
> >
> > Rgds
> >
> > Robbie
> >
> >
> >
> > "Bob Barrows [MVP]" <reb01501@NOyahoo.SPAMcom> wrote in message
> > news:uafTp1ymEHA.2908@TK2MSFTNGP12.phx.gbl...
> > Astra wrote:
> > > Hi All
> > > strDSN = "Driver={SQL Server};Server=" & strIP & ";Address=" & strIP &
> >
> > Don't use ODBC! Use a SQLOLEDB connection string
> > (www.able-consulting.com/ado_conn.htm). It may not solve this specific
> > problem, but it will prevent others.
> >
> > > Microsoft OLE DB Provider for ODBC Drivers error '80004005'
> > See this article:
> > http://www.aspfaq.com/show.asp?id=2009
> >
> >
> > Bob Barrows
> > --
> > Microsoft MVP -- ASP/ASP.NET
> > Please reply to the newsgroup. The email account listed in my From
> > header is my spam trap, so I don't check it very often. You will get a
> > quicker response by posting to the newsgroup.
> >
> >
> >
>
>
>
>
  • Next message: Bob Barrows [MVP]: "Re: How do you SELECT a list of words with commas in SQL from a column?"

    Relevant Pages

    • Re: asp.net sql trusted connections between machines
      ... > connect to a remote SQL Server instance w/ Read-Write permissions. ... > connection string in the web.config. ... > Windows Authentication setting for access via IIS doesn't seem pass the ... is this impersonation behavior with IIS and Windows Authentication ...
      (microsoft.public.dotnet.framework.aspnet)
    • Re: Cannot Generate SSPI Context - help
      ... I have used the following DSN-less string: ... Microsoft OLE DB Provider for SQL Server error '80004005' ... When a connection is "trusted," it means ... > How would one connect to a remote SQL Server using Windows authen? ...
      (microsoft.public.inetserver.asp.db)
    • ASP + SQL 2000 + Win2k SP4
      ... SQL Server connection. ... OS is Windows 2000 and SP4 on both the IIS server and SQL server, ... enable Integrated windows authentication. ... There is a role for domain users to use giving them execute permissions ...
      (microsoft.public.sqlserver.odbc)
    • Re: More on that login problem - found the logs -
      ... I see that I'm using both SQL Server and Windows authentication; ... "Startup service account" startup runs the ... Should I try to make a new SQL server registration? ... Not associated with a trusted SQL Server connection"). ...
      (microsoft.public.sqlserver.connect)
    • Re: Blocking MS Access from linking tables...
      ... Does connection pooling work the same way? ... database that was converted from Access to SQL Server. ... I know that using an Access form can create multiple SPIDs on SQL Server ... If you're using Windows authentication, ...
      (microsoft.public.sqlserver.security)