Re: Cannot Generate SSPI Context - help

From: Laphan (news_at_DoNotEmailMe.co.uk)
Date: 09/15/04 

Date: Wed, 15 Sep 2004 18:34:15 +0100

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

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)
  • 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)
  • RE: Reality of remote connection
    ... but either your username 'Administrator' or password are ... I am attempting to login using the administrator account that ... figuring it will at least do the connection string correctly. ... > connect to on the SQL server machine that connects to SQL Server on my behalf? ...
    (microsoft.public.sqlserver.connect)
Loading