Re: SQL Server or IIS

From: Steve Thompson (stevethompson@nomail.please)
Date: 12/26/02 

From: "Steve Thompson" <stevethompson@nomail.please>
Date: Thu, 26 Dec 2002 13:09:39 -0500

"Aqeel" <Aqeel.Karim@Veridian.com> wrote in message
news:001201c2ab6f$45c78b60$d5f82ecf@TK2MSFTNGXA12...
> I have IIS and a SQL database running, but I want all
> user accounts to authenticate to SQL when they access the
> database over the web. Is there a way to set failed
> logons, so if a user attempts to access the database or
> login.asp file they are locked out? I am not sure if it
> is the database that locks them out or IIS. If it is IIS
> how and where can it be set? or SQL?

How you set this up depends on if you have IIS and SQL on the same server or
different servers. See if this helps:
 http://support.microsoft.com/default.aspx?scid=kb;en-us;247931

Steve

Relevant Pages

  • Re: VPN over wireless
    ... Do you want to give the students user accounts so that they can access LAN ... Is the database forms they input to connected to the SQL server? ... I am setting up a separate network for Guest access using a wireless ...
    (microsoft.public.windows.server.sbs)
  • Re: Export AD information into a SQL Database
    ... We're looking to import user and computer information from AD into an SQL ... Database. ... We currently have in excess of 900 user accounts and need to check ... See tip 7714 » What attribute names can I use with the user filtered dsquery command? ...
    (microsoft.public.windows.server.active_directory)
  • Login failure from asp.net delegation
    ... We want to use windows 2000 User auth to query sql 2000 using security ... checked "Integrated Windows Auth" in IIS and have added this to web.config. ... I have not added a login to the database since i thought it passes in the ...
    (microsoft.public.sqlserver.security)
  • Re: Whats best practice for connecting to a Sql Server database
    ... I doubt you are moving to IIS 8 yet since IIS 7 is the version shipping in ... I generally prefer using Windows auth over SQL auth when possible ... that the web app ran under a user that had very weak rights and the ... connection string had the uname/pw to connect to the database. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: How to read data from stand alone SQL CE database on mobile device from VB.net 2005
    ... server running IIS to make the connection. ... the IIS requirement for SQL Server but I don't know. ... I have a stand alone SQL CE database on my windows mobile device. ...
    (microsoft.public.sqlserver.ce)