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?
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)