home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 18,332 of 19,505   
   Erland Sommarskog to Bob Barrows   
   Re: SQL 2008 Best Practices   
   19 May 11 23:42:08   
   
   From: esquel@sommarskog.se   
      
   Bob Barrows (reb01501@NOyahooSPAM.com) writes:   
   > 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?   
      
   It seems that I have Integration Services running under Network Service   
   on my box. I think I had problems with getting SSIS to start on when   
   I booted the machine, this was also true for the Database Engine.   
      
   I believe I resolved this issue when I finally learned to spell to   
   ServicesPipeTimeout. (That's a registry key.)   
      
   But I don't use SSIS much at all, since I don't know it.   
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca