Re: How to enable Windows Authentication

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Forgive me if this is obvious, or anything, but you are using Internet
Explorer only, right? Firefox and other browsers just won't do
Windows Authentication.


On Feb 16, 3:51 pm, "Mr. Arnold" <MR. Arn...@xxxxxxxxxx> wrote:
"JEFF" <jeffw...@xxxxxxxxxxx> wrote in message

news:esCT8J%23jJHA.1172@xxxxxxxxxxxxxxxxxxxxxxx

Thanks Alvin, either your missing something or I am missing something and
I think we have already established that I am missing something.  I am new
to ASP.NET.  :)  I don't want to use SQL server.  I don't need it, want
it, or care how to spell it.  I am using Windows user accounts on my
Windows 2003 server.  These is doable right?

If you were developing an Intranet solution and the Web Server was part of a
MS domain behind the firewall, it's  doable with Windows authentication, as
the user would give their Windows user-id and psw for the domain to be
authenticated as a domain user, as the Web application using Windows
authentication does the challenge for credentials.

Your correct in that if i enable my sql connection string it works but
that is not my goal.  I want to have a web application that authenticates
with Windows Local User accounts.  That is possible correct?

If this is a Internet solution, out side the firewall and out side of the
domain, Web application that requires a user to give a user-id and psw to be
authenticated, then SQL server authentication must be used, whereas, the
user credentials  are kept in a SQL Server table such as tblUser as an
example, and the user's login credentials are verified against the tblUser
table.

This would also mean that your SQL server usage would use a connection
string where Windows authentication would not be used, and a SQL server
user-id and psw authentication  would be used,  using a generic user-id and
psw that would be given in the connection string  to be used by the Web
application so that all users can access SQL Server to be authenticated
against the User table.

You might want to look-up using Google on how to encrypt a Web.comfit file
as well.

.

Relevant Pages

  • ISA Server Authentication issues in a mixed Windows/Macintosh environment
    ... I have a client - a local public school system - with a mixed ... and sometime switch over to a pure Windows environment by the time ... agree to allow them to have internet access. ... Basic authentication is the order of business, ...
    (NT-Bugtraq)
  • 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: Remote connection failed
    ... If you are going over a remote connection or are not logging ... into the domain where SQL Server is then no, Windows ... authentication won't work. ...
    (microsoft.public.sqlserver.connect)
  • Re: Changing passwords / Blocking SA login attempts
    ... I went into the Server Config properties and changed to Windows ... My login for Start and Run SQL server was in this format. ... I am supposing this was an SQL authentication, ...
    (microsoft.public.sqlserver.security)
  • Windows Authentication with IIS on separate machines
    ... Yes, setting Basic Authentication in IIS works, but the ... >in SQL server but doesn't work if user account was ... >imported from a Windows account. ...
    (microsoft.public.sqlserver.security)