The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P17: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | Table SQL Server 2008 Service Accounts and Privileges SQL Server Service Name Optional Accounts User Group Default Permissions Granted by SQL Server Setup SQL Server SQL Server Express Default instance SQLServerMSSQL- Log on as a service SeServiceLogonRight Domain User Local System User ComputerName- MSSQLSERVER Log on as a batch job SeBatchLogonRight Network Service Named instance SQL- ServerMSSQLUser- Replace a process-level token SeAssignPrimaryTokenPrivilege All other editions Domain User Local System Network Servicel Computer- Name InstanceName Bypass traverse checking SeChangeNotifyPrivilege Adjust memory quotas for a process SelncreaseQuota-Privilege Permission to start SQL Server Active Directory Helper Permission to start SQL Writer Permission to read the Event Log service Permission to read the Remote Procedure Call service SQL Server Domain User Default instance SQL- Log on as a service Agent Local System ServerSQLAgentUser- SeServiceLogonRight Network Service Note SQL Server ComputerName- MSSQLSERVER Log on as a batch job SeBatchLogonRight Agent Service is disabled on instances Named instance SQL- ServerSQLAgentUser- Replace a process-level token SeAssignPrimaryTokenPrivilege of SQL Server Express and SQL Server Express with Advanced Services. ComputerName- InstanceName Bypass traverse checking SeChangeNotifyPrivilege Adjust memory quotas for a process SelncreaseQuotaPrivilege Analysis Services Domain User Network Service Local Service Local System Default instance SQL-ServerMSOLAPUser- ComputerName MS-SQLSERVER Named instance SQL-ServerMSOLAPUser- ComputerName -InstanceName Log on as a service SeServiceLogonRight Reporting Services Domain User Local System Network Service Local Service Default instance SQL-ServerReportServer-User ComputerName- Log on as a service SeServiceLogonRight Named instance SQL-ServerReportServer-User ComputerName- Integration Services Domain User Local System Network Service Local .
