SQL Server Performance

SQL Server & SQL Server Agent not able to Start

Discussion in 'SQL Server 2008 General DBA Questions' started by rohaandba, May 6, 2011.

  1. rohaandba New Member

    I installed SQL Server R2 on my local machine(office laptop) yesterday
    It was ok yesterday. I created sample Databases and have done few DTS and SSIS packages on that. They worked fine the day I installed SQL.
    Today, I could connect to remote server through SSMS but I could not connect to my local machine throug SSMS.
    I opened Services.msc and found both SQL Server & SQL Server Agent have not started.
    When I tried to Start these services they gave me errors as
    SQL SERVER AGENT -------Could not start the SQL Server Agent(MS SQL Server) service on local computer, Error1068: The dependency service or group failed to start
    SQL Server-------Windows couldnot start the sql server on local computer.........for more information, review the syystem Event log........If this is a non-microsoft service, contact the service vendor, and refer to service-specific error code 126
    Please help me in solving this issue
    Thanking You
  2. Luis Martin Moderator

    What error log show?
  3. satya Moderator

    If you are using a local login to start SQL Server and SQL Agent services ensure that password is matching. If not a local system account is used then check the Event vIewer log - Application log to get more information on the error.
  4. Jahanzaib Member

    Check SQL Server Agent Service account have rights to start the service or password has changed or this job on domain account
  5. satya Moderator

    <P mce_keep="true">Just a note from BOL about how service accounts are managed during the setup:</P><P xmlns="">The following table shows the user groups that SQL Server Setup creates that are granted specific Windows NT user rights. </P><H3 class=subHeading xmlns=""></H3><TABLE class="" style="BACKGROUND-COLOR: #cccccc" cellSpacing=0 cellPadding=0 width="100%" border=1 xmlns=""><TBODY><TR><TH class="">SQL Server service </TH><TH class="">User group </TH><TH class="">Default permissions granted by SQL Server Setup </TH></TR><TR><TD class=""><P>SQL Server </P></TD><TD class=""><P>Default instance: SQLServerMSSQLUser$<I>ComputerName</I>$MSSQLSERVER</P><P>Named instance: SQLServerMSSQLUser$<I>ComputerName</I>$<I>InstanceName</I></P></TD><TD class=""><P>Log on as a service (SeServiceLogonRight)<SUP>1</SUP></P><P>Replace a process-level token (SeAssignPrimaryTokenPrivilege)</P><P>Bypass traverse checking (SeChangeNotifyPrivilege)</P><P>Adjust memory quotas for a process (SeIncreaseQuotaPrivilege)</P><P>Permission to start SQL Server Active Directory Helper</P><P>Permission to start SQL Writer</P><P>Permission to read the Event Log service</P><P>Permission to read the Remote Procedure Call service</P><DIV class=alert><TABLE class="" cellSpacing=0 cellPadding=0 width="100%"><TBODY><TR><TH class="" align=left><IMG class=note src="ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10sq_GetStart/local/note.gif">Important: </TH></TR><TR><TD class="">For SQL Server instances on Windows Vista and higher, Log on as a service, Replace a process-level token, Bypass traverse checking, and Adjust memory quotas for a process user rights are granted to the SQL Server service SID. <P mce_keep="true">&nbsp;</P></TD></TR></TBODY></TABLE><P mce_keep="true">&nbsp;</P></DIV></TD></TR><TR><TD class=""><P>SQL Server Agent<SUP>3</SUP></P></TD><TD class=""><P>Default instance: SQLServerSQLAgentUser$<I>ComputerName</I>$MSSQLSERVER</P><P>Named instance: SQLServerSQLAgentUser$<I>ComputerName</I>$<I>InstanceName</I></P></TD><TD class=""><P>Log on as a service (SeServiceLogonRight)</P><P>Replace a process-level token (SeAssignPrimaryTokenPrivilege)</P><P>Bypass traverse checking (SeChangeNotifyPrivilege)</P><P>Adjust memory quotas for a process (SeIncreaseQuotaPrivilege)</P></TD></TR></TBODY></TABLE>

Share This Page