IIS & SQL, dedicated user account & GPO

Tech-Archive recommends: Fix windows errors by optimizing your registry

SBS'03 Prem SP1, using ISA'04
I am setting up a dedicated IIS server (2 nics) for hosting a site that will
use data from a SQL DB on the SBS server (2 nics). From what I read, a
dedicated domain user account is the securest way to allow IIS to access SQL
without a lot of maintenance . My problem/question comes in at the GPO
problems I could experiance. I have password changes forced every 45 days
(yes, strong), but I don't want this account to have to change. Also, is
thier an easy way to setup this account without all the frills the wizard
normally adds, like mailboxes, etc. Basically all I want the account to be
able to do is allow IIS to access the tables and queries I specify in EM and
nothing else...

Thanks is advance

Chip


.

Relevant Pages

  • Re: sql problem
    ... Account # is the link field on ... The requirement is I have to come up with a report comparing the two ... customer tables to see if they are in sync. ... what I wanted to do was to get the SQL to return the "like" names ...
    (comp.databases.oracle.server)
  • Re: sql problem
    ... Account # is the link field on ... table1, table2@dblink where ....) ... customer tables to see if they are in sync. ... what I wanted to do was to get the SQL to return the "like" names ...
    (comp.databases.oracle.server)
  • Re: sql problem
    ... Account # is the link field on ... table1, table2@dblink where ....) ... customer tables to see if they are in sync. ... what I wanted to do was to get the SQL to return the "like" ...
    (comp.databases.oracle.server)
  • Re: W2K/WMI service (WinMgmt.exe) accessing an ODBC connection
    ... If a SQL account is used then the only thing needed on the ... machine running SQL is SQL login and database grants. ... If integrated, then in addition, I have seen the account need ... then changing this to use trusted connection ...
    (microsoft.public.windows.server.security)
  • Re: Problems connecting to SQL Server
    ... Maximo is specifically stating that you must use the SA user ... to be the SQL 7 Product ID while scrounging around in some boxes. ... I will also try MDAC. ... And they specify the SA account. ...
    (microsoft.public.sqlserver.clients)