Groups > comp.databases.ms-sqlserver > #356

SQL 2008 Best Practices

From	"Bob Barrows" <reb01501@NOyahooSPAM.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	SQL 2008 Best Practices
Date	2011-05-19 14:56 -0400
Organization	A noiseless patient Spider
Message-ID	<ir3pcq$pnf$1@dont-email.me> (permalink)

Show all headers | View raw

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

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

SQL 2008 Best Practices "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-05-19 14:56 -0400
  Re: SQL 2008 Best Practices Erland Sommarskog <esquel@sommarskog.se> - 2011-05-19 23:42 +0200

csiph-web