VPN NT Authentication

From: Lisa (lisa@sepanski.org)
Date: 10/24/02 

From: "Lisa" <lisa@sepanski.org>
Date: Thu, 24 Oct 2002 09:39:55 -0700

I am trying to access the SQL Server through a VPN using
NT Authentication. The user is set up as a member of a
global domain group which is mapped into SQL Server as a
login and into the database as a member of a group.

I can successfully login to the VPN, connect to shares,
etc. When I try to setup an ODBC Connection using NT
authentication I get "Login failed for user '(null)'
Reason: Not associated with a trusted SQL Server
Connection". Mixed mode is not turned on and we really
didn't want to turn it on, because the application uses NT
authentication and we must use that mode.

The DSN will be used by an Access application hitting the
SQL Server.

Any advice is appreciated.

Relevant Pages

  • RE: Interdev not creating project (authenticate failure)
    ... | 1st Computer (for SQL Server and IIS): ... | Member of: Administrators ... Also in IIS console, rightclick the web site and go to properties/directory ... Integrated Windows and check Basic authentication. ...
    (microsoft.public.inetserver.iis.security)
  • Re: Windows Authentication in asp.net 2005 to SQL Server?
    ... If the domains do not trust each other, Windows authentication is not going ... Basic authentication sometimes makes the need for Kerberos delegation go ... generic account to do the backend data stuff on our SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: I dont want to re-invent the Login/Login Wheel - Help with utilities
    ... Yes, if you use .NET1.1, there isn't built-in login control, and more importanltly there isn't ready-to-use membership component to use. ... the membership provider uses SQL Server or SQL Server Express. ... We feel that having the capability to force password change would be a better benefit in securing our application and data access. ... Both Windows authentication and authorization wolud be be fine if we wanted the world to have access to our application data, but not very intuitive for maintaining integrity over our data. ...
    (microsoft.public.vstudio.general)
  • RE: IIS (ASP) -> SQLServer Authentication Issue
    ... I understand that you'd like to use IIS Intergration authentication in the ... and ASP "impersonates" authencitaed users to access SQL Server on ... only kerberos authentication allows double-hops from clients ...
    (microsoft.public.sqlserver.security)
  • Re: SBS Premium Edition .. what way is SQL licenced
    ... Another thing to note in using your SQL Server as a backend database is the ... concept of Forms-based authentication and Integrated Windows authentication. ... thereby requiring individual CALs to access SQL Server. ... Chad A. Gross - SBS MVP ...
    (microsoft.public.windows.server.sbs)