Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail From: "Bob Barrows" Newsgroups: comp.databases.ms-sqlserver Subject: SQL 2008 Best Practices Date: Thu, 19 May 2011 14:56:00 -0400 Organization: A noiseless patient Spider Lines: 16 Message-ID: Injection-Date: Thu, 19 May 2011 19:00:42 +0000 (UTC) Injection-Info: mx04.eternal-september.org; posting-host="NUmboHSNYG4cX5Ys9j8TNw"; logging-data="26351"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18zAkqi2WramfLCBE5QTayRNaWhWK7XZ40=" X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.2001 X-Antivirus-Status: Clean X-Newsreader: Microsoft Outlook Express 6.00.2800.2001 X-Antivirus: avast! (VPS 110519-1, 05/19/2011), Outbound message Cancel-Lock: sha1:wCy2QOlYNiuKrJDpJhnVBCOzW9w= X-Priority: 3 X-MSMail-Priority: Normal Xref: x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:356 Well, we've finally set up a new server and installed 2008 on it (Denali? What's that?). Anyway, I hit my first hurdle: Integration Services would not start - "failed to respond in a timely fashion". I checked the Log On tab on the Services Property dialog and noted that it was set to log on with an account called "NETWORK SERVICE", with obscured passwords, of course. I clicked the "Local System Account" radio button and tried again. This time the service started with no problem. But now I'm wondering if that's a good setting. I checked our current SQL 2005 servers and they are set to run under the local system account as well, but that means nothing - they were installed before my time. I realize that SQL Server itself should be using a domain account - does this advice apply to integration services too? If not, what is the recommendation? Bob