Authentication

In a common domain, I am having an authentication issue with a remote
system. Our SQL 2000 server resides on a Win 2003 server machine.
Currently, my remote users are connecting via MS Access 2k front end
running from their local Win XP machines and are accessing based on
their domain login using NT Authentication, use and function are fine
with domain credentials.

The remote system (Cold Fusion) that is failing to connect has been
given a SQL Server login, which fails. In testing the connection, my
remote associate is unable to connect to the SQL server unless he has
first established a connection (to a share for instance) using his
domain login credentials. Security is set to mixed, and RPC is
permitted for remote linked servers (though I'm not certain this is
required for the cold fusion connection, no linked server has been
built). The remote system is intended to read a read-only view into a
web interface.


So, as my normal users do not have access problems while authenticating
with their domain credentials, the system requiring sql login access
does. At this point, I don't know if I have missed something in SQL
Server or if there is a domain issue, and am hoping someone may be able
to provide insight.

Thanks, All.

EricO.

.

Relevant Pages

  • Re: Application pool with domain account & anonymous access disabled
    ... Web server must use the remote user's identity to access network ... authentication protocol so that IIS forces authentication (though the choice ... The issue is called "delegation", ...
    (microsoft.public.inetserver.iis)
  • RE: Confusion on standard security methodologies.
    ... Application will talk to a back-end SQL ... By "back-end," I assume you mean on a different box from IIS? ... If SQL is on a separate box, you won't be able to use NT authentication ... impersonations (meaning that once passed to the IIS server, ...
    (microsoft.public.inetserver.iis.security)
  • Re: IIS6 Authentication Problem with SQL Server 2000
    ... They're not accessing SQL directly right? ... > a) if you are using a Windows 2000 Domain, ... > backend SQL Server. ... You need to use Kerberos authentication for this (not ...
    (microsoft.public.inetserver.iis.security)
  • SQL 2005 Express Connection Problem
    ... The remote site is not a company ... this remote site and try to log in I get this error: ... An error has occurred while establishing a connection to the server. ... When connecting to SQL Server 2005, this failure may be caused by the ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Security Update for SQL Server 2000 Service Pack 4 (KB948110)
    ... log into SQL Server. ... Authentication) The other is SQL Authentication where, ... the 948110 hotfix will not work on a database server ...
    (microsoft.public.windowsupdate)