White paper on OS users for SQL Server 2005

Last Post 04 Jul 2007 03:12 AM by gilou28. 3 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
gilou28
New Member
New Member

--
29 Jun 2007 08:55 AM
Good afternoon all.

I'm looking for a step by step guide on domain user creation for sql server 2005 services. What are the required priviledges, options and so on. I'm used to only use SQL authentication, now I want to use the mixed version.

Thanks.
gilou28
New Member
New Member

--
29 Jun 2007 12:10 PM
Thanks for your reply.

My question is more at the OS level, what role (OS) should have the accounts that run SQL Server, Agent....
gilou28
New Member
New Member

--
30 Jun 2007 04:50 AM
Goooood Morniiing and thanks for your reply.

Agreed, and I now see that my original question was far from being clear. My concern is more at the security level. Local admin is really a "powerfull" account and gives the ability, for a malicious user, to reboot a server from a shell command (xp_cmdshell if I'm not mystaken).

So, to clarify my original question, aside using local system, what are the MINIMUM OS privs required for the MSS services ?

Thanks.
gilou28
New Member
New Member

--
04 Jul 2007 03:12 AM
Here are two documents from MS that highlight the services requirements.

Setting up Windows Service Accounts

Best Practices


Thanks.
You are not authorized to post a reply.

Acceptable Use Policy