RE: Co-Hosting SQL with IIS FTP service

I would split those services if at all possible

I dont have any data to hand to backup this claim up, but i would suggest that this is a common sense approach?

Patches may become an issue - you may need to have a SQL box providing 24 x 7 x 365
You then need to patch the IIS component, and a reboot is needed, down goes SQL
You really want to reduce the attack surface of your systems, you wouldn't open up any SQL listeners to the whole world, but you would in an indirect way i assume if you use IIS FTP, [compromise FTP - stage an attack on the SQL service?]
Also what about data storage - FTP can if unechecked start to fill up disk space - if your SQL server is mission critical it could possib;y impact on this?

I wouldn't if i could help it -

Others may disagree






-----Original Message-----
From: chris.dalton@xxxxxxxxxxxxxxxxxx
[mailto:chris.dalton@xxxxxxxxxxxxxxxxxx]
Sent: 25 July 2006 15:42
To: focus-ms@xxxxxxxxxxxxxxxxx
Subject: Co-Hosting SQL with IIS FTP service


Can anyone guide me as to what type of issues with inter-system dependencies might arise by co hosting IIS FTP service with SQL?

Anyone know of any articles on the exploits?

---------------------------------------------------------------------------

---------------------------------------------------------------------------


---------------------------------------------------------------------------
---------------------------------------------------------------------------

Relevant Pages

  • RE: Co-Hosting SQL with IIS FTP service
    ... SQL and IIS FTP are not good services to have running on the same box. ... SQL is generally a locally accessible service ... disk space - if your SQL server is mission critical it could possib;y ...
    (Focus-Microsoft)
  • Re: Backup erros
    ... You may have a SQL ... Error 800423f4 appears in the backup log file when you back up a volume by ... > Reason: The process cannot access the file because it is being used by> another process. ...
    (microsoft.public.windows.server.sbs)
  • Re: SBS2003, NTBackup-Fehler
    ... Windows Server 2003 to resolve some VSS snapshot issues ... Backup fails on a computer that is running Small Business Server 2003 ... Die Sicherung kann nicht fortgesetzt werden. ... Microsoft OLE DB Provider for SQL Server ...
    (microsoft.public.de.german.backoffice.smallbiz)
  • RE: SQL 2005 Failing Backups Because it Exits The Query Prematurely
    ... it might be a behavior change in SQL 2005. ... SQL 2005 Failing Backups Because it Exits The Query Prematurely ... This same application (which uses ODBC) is able to backup SQL 7.0 and SQL ...
    (microsoft.public.sqlserver.odbc)
  • Best SQL Backup Solution
    ... Here are a few reasons you should look at Idera's SQL Safe backup product: ... Should a network glitch occur during the backup the backup will not immediately fail but instead continue to retry for a period of time to see if the network again becomes available. ... Best SQL Backup Solution. ...
    (microsoft.public.sqlserver.server)