SQL Server Agent

I downloaded SQL Server 2012 and installed Evaluation with full option but I can't find SQL Server Agent.

Should I download it separately?

June 29th, 2015 1:04am

What edition you installed? Express or some other?

Did you check agent component in the list while running the wizard

Free Windows Admin Tool Kit Click here and download it now
June 29th, 2015 1:45am

Hello - It is quite likely that you installed SQL Server 2012 Express edition in which case SQL Server Agent does not get installed. SQL Server Agent is not a part of SQL Server 2012 Express or Express edition with Advanced services.

You need to execute the following query to confirm this (See the edition information displayed by this query):

SELECT ServerProperty('Edition')

Alternative/Other Solutions:

  • Put your script/ code in a script file and
  • Invoke the batch file using SQLCMD utility, such as sqlcmd -i script.sql, where script.sql contains T-SQL commands that you need to call
  • Call this batch file using Windows Scheduler

Hope this helps !


June 29th, 2015 2:50am

For Express Edition there will be NO SQL agent.

If the version is other than express. Go to SQL Configuration and start SQL agent manually

Free Windows Admin Tool Kit Click here and download it now
June 29th, 2015 10:15am

You asked the exact same question 5 days ago.  The answer is unlikely to change.
June 29th, 2015 10:27am

It's not Express version.

I downloaded standard version from here

I selected full options when I installed it.

Free Windows Admin Tool Kit Click here and download it now
June 29th, 2015 11:51am

What is the output of SELECT ServerProperty('Edition')?
June 29th, 2015 11:57am

Try repairing or re-installing.

You installation might have corrupted agent. From your link I can see that you have not installed express edition. 

 
Free Windows Admin Tool Kit Click here and download it now
June 29th, 2015 12:09pm

The output of SELECT ServerProperty('Edition'is 

Enterprise Evaluation Edition (64-bit)


  • Edited by Jeff0803 3 hours 50 minutes ago
June 29th, 2015 11:16pm

The output of SELECT ServerProperty('Edition'is 

Enterprise Evaluation Edition (64-bit)


  • Edited by Jeff0803 Tuesday, June 30, 2015 3:16 AM
Free Windows Admin Tool Kit Click here and download it now
June 30th, 2015 3:15am

The output of SELECT ServerProperty('Edition'is 

Enterprise Evaluation Edition (64-bit)


  • Edited by Jeff0803 Tuesday, June 30, 2015 3:16 AM
June 30th, 2015 3:15am

The output of SELECT ServerProperty('Edition'is 

Enterprise Evaluation Edition (64-bit)


  • Edited by Jeff0803 Tuesday, June 30, 2015 3:16 AM
Free Windows Admin Tool Kit Click here and download it now
June 30th, 2015 3:15am

Hi Jeff0803,

Is the SQL Server instance installed successfully on your computer?  Please repair the SQL Server instance as other post and then show the screenshot of SQL Server Services node in SQL Server Configuration Manager.

Thanks,
Lydia Zhang

June 30th, 2015 3:22am

Jeff,

Before repairing to confirm whether installation was correct and you selected required features can you shares summary.txt file Below link will help you locate it

View and read setup log files

Free Windows Admin Tool Kit Click here and download it now
June 30th, 2015 5:29am

Hello

Open SQL Server Configuration Manager and see if SQL Server Agent is present.

If it is try and start the Service; if it isn't then you will need to reinstall SQL Server.

June 30th, 2015 5:56am

I can't find even SQL Server Configuration.

It seems that I should uninstall and re-install.

Free Windows Admin Tool Kit Click here and download it now
July 1st, 2015 12:18am

I can't find even SQL Server Configuration.

It seems that I should uninstall and re-install.


DID YOU READ MY COMMENT ? Unnecessarily this thread is being dragged if you can please post it we can immediately reach to conclusion and correct conclusion whether you need to rebuild or some thing other can be done and what caused it to fail.
July 1st, 2015 12:51am

Sorry for late.

I reinstalled Windows 8.1 and installed SQL Server Enterprise 2012 Evaluation.

However still I can't SQL Server Agent.

Here is the Summary.txt.

Overall summary:
  Final result:                  Passed
  Exit code (Decimal):           0
  Start time:                    2015-07-05 20:45:20
  End time:                      2015-07-05 21:53:48
  Requested action:              Install

Machine Properties:
  Machine name:                  don
  Machine processor count:       2
  OS version:                    Future Windows Version
  OS service pack:               
  OS region:                     United States
  OS language:                   English (United States)
  OS architecture:               x64
  Process architecture:          64 Bit
  OS clustered:                  No

Product features discovered:
  Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered 

Package properties:
  Description:                   Microsoft SQL Server 2012 Service Pack 1
  ProductName:                   SQL Server 2012
  Type:                          RTM
  Version:                       11
  SPLevel:                       0
  Installation location:         C:\Users\Donyoung\Downloads\MS SQL Server 2012 Enterprise Evaluation\x64\setup\
  Installation edition:          Evaluation

Product Update Status:
  None discovered.

User Input Settings:
  ACTION:                        Install
  ADDCURRENTUSERASSQLADMIN:      false
  AGTSVCACCOUNT:                 NT Service\SQLSERVERAGENT
  AGTSVCPASSWORD:                *****
  AGTSVCSTARTUPTYPE:             Manual
  ASBACKUPDIR:                   C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Backup
  ASCOLLATION:                   Latin1_General_CI_AS
  ASCONFIGDIR:                   C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Config
  ASDATADIR:                     C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Data
  ASLOGDIR:                      C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Log
  ASPROVIDERMSOLAP:              1
  ASSERVERMODE:                  MULTIDIMENSIONAL
  ASSVCACCOUNT:                  NT Service\MSSQLServerOLAPService
  ASSVCPASSWORD:                 <empty>
  ASSVCSTARTUPTYPE:              Automatic
  ASSYSADMINACCOUNTS:            don\Donyoung
  ASTEMPDIR:                     C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Temp
  BROWSERSVCSTARTUPTYPE:         Disabled
  CLTCTLRNAME:                   
  CLTRESULTDIR:                  C:\Program Files (x86)\Microsoft SQL Server\DReplayClient\ResultDir\
  CLTSTARTUPTYPE:                Manual
  CLTSVCACCOUNT:                 NT Service\SQL Server Distributed Replay Client
  CLTSVCPASSWORD:                <empty>
  CLTWORKINGDIR:                 C:\Program Files (x86)\Microsoft SQL Server\DReplayClient\WorkingDir\
  COMMFABRICENCRYPTION:          0
  COMMFABRICNETWORKLEVEL:        0
  COMMFABRICPORT:                0
  CONFIGURATIONFILE:             C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20150705_201644\ConfigurationFile.ini
  CTLRSTARTUPTYPE:               Manual
  CTLRSVCACCOUNT:                NT Service\SQL Server Distributed Replay Controller
  CTLRSVCPASSWORD:               <empty>
  CTLRUSERS:                     don\Donyoung
  ENABLERANU:                    false
  ENU:                           true
  ERRORREPORTING:                false
  FEATURES:                      SQLENGINE, REPLICATION, FULLTEXT, DQ, AS, RS, RS_SHP, RS_SHPWFE, DQC, BIDS, CONN, IS, BC, SDK, BOL, SSMS, ADV_SSMS, DREPLAY_CTLR, DREPLAY_CLT, SNAC_SDK, MDS
  FILESTREAMLEVEL:               0
  FILESTREAMSHARENAME:           <empty>
  FTSVCACCOUNT:                  NT Service\MSSQLFDLauncher
  FTSVCPASSWORD:                 <empty>
  HELP:                          false
  IACCEPTSQLSERVERLICENSETERMS:  false
  INDICATEPROGRESS:              false
  INSTALLSHAREDDIR:              C:\Program Files\Microsoft SQL Server\
  INSTALLSHAREDWOWDIR:           C:\Program Files (x86)\Microsoft SQL Server\
  INSTALLSQLDATADIR:             <empty>
  INSTANCEDIR:                   C:\Program Files\Microsoft SQL Server\
  INSTANCEID:                    MSSQLSERVER
  INSTANCENAME:                  MSSQLSERVER
  ISSVCACCOUNT:                  NT Service\MsDtsServer110
  ISSVCPASSWORD:                 <empty>
  ISSVCSTARTUPTYPE:              Automatic
  MATRIXCMBRICKCOMMPORT:         0
  MATRIXCMSERVERNAME:            <empty>
  MATRIXNAME:                    <empty>
  NPENABLED:                     0
  PID:                           *****
  QUIET:                         false
  QUIETSIMPLE:                   false
  ROLE:                          <empty>
  RSINSTALLMODE:                 DefaultNativeMode
  RSSHPINSTALLMODE:              SharePointFilesOnlyMode
  RSSVCACCOUNT:                  NT Service\ReportServer
  RSSVCPASSWORD:                 <empty>
  RSSVCSTARTUPTYPE:              Automatic
  SAPWD:                         <empty>
  SECURITYMODE:                  <empty>
  SQLBACKUPDIR:                  <empty>
  SQLCOLLATION:                  SQL_Latin1_General_CP1_CI_AS
  SQLSVCACCOUNT:                 NT Service\MSSQLSERVER
  SQLSVCPASSWORD:                <empty>
  SQLSVCSTARTUPTYPE:             Automatic
  SQLSYSADMINACCOUNTS:           don\Donyoung
  SQLTEMPDBDIR:                  <empty>
  SQLTEMPDBLOGDIR:               <empty>
  SQLUSERDBDIR:                  <empty>
  SQLUSERDBLOGDIR:               <empty>
  SQMREPORTING:                  false
  TCPENABLED:                    1
  UIMODE:                        Normal
  UpdateEnabled:                 true
  UpdateSource:                  MU
  X86:                           false

  Configuration file:            C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20150705_201644\ConfigurationFile.ini

Detailed results:
  Feature:                       Management Tools - Complete
  Status:                        Passed

  Feature:                       Client Tools Connectivity
  Status:                        Passed

  Feature:                       Client Tools SDK
  Status:                        Passed

  Feature:                       Client Tools Backwards Compatibility
  Status:                        Passed

  Feature:                       Management Tools - Basic
  Status:                        Passed

  Feature:                       SQL Server Data Tools
  Status:                        Passed

  Feature:                       Reporting Services - Native
  Status:                        Passed

  Feature:                       Database Engine Services
  Status:                        Passed

  Feature:                       Data Quality Services
  Status:                        Passed

  Feature:                       Full-Text and Semantic Extractions for Search
  Status:                        Passed

  Feature:                       SQL Server Replication
  Status:                        Passed

  Feature:                       Master Data Services
  Status:                        Passed

  Feature:                       Distributed Replay Client
  Status:                        Passed

  Feature:                       Distributed Replay Controller
  Status:                        Passed

  Feature:                       Integration Services
  Status:                        Passed

  Feature:                       Data Quality Client
  Status:                        Passed

  Feature:                       Analysis Services
  Status:                        Passed

  Feature:                       Reporting Services - SharePoint
  Status:                        Passed

  Feature:                       Reporting Services Add-in for SharePoint Products
  Status:                        Passed

  Feature:                       SQL Browser
  Status:                        Passed

  Feature:                       Documentation Components
  Status:                        Passed

  Feature:                       SQL Writer
  Status:                        Passed

  Feature:                       SQL Client Connectivity
  Status:                        Passed

  Feature:                       SQL Client Connectivity SDK
  Status:                        Passed

Rules with failures:

Global rules:

Scenario specific rules:

Rules report file:               C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\20150705_201644\SystemConfigurationCheck_Report.htm

I don't know what's wrong.Can anybody give me any advice?

Free Windows Admin Tool Kit Click here and download it now
July 6th, 2015 1:46am

Your SQl Server installation passed with NO FAILURES this means SQl server agent must be installed and since you installed evaluation edition it has to be there.

Can you once more login into SSMS and see if you can find SQL Server agent , can you also check in SSCM and services.msc if you cannot fid it it seems like bug, but I have hunch that you are doing something wrong I have not seen scenario where you install SQl Server successfully and agent does not appear

July 6th, 2015 2:07am

I could find SQL Server Agent on the left window of the SSMS.

however I couldn't find it in the Apps.

Is this normal?

Free Windows Admin Tool Kit Click here and download it now
July 7th, 2015 12:21am

I could find SQL Server Agent on the left window of the SSMS.

however I couldn't find it in the Apps.

Is this normal?

Perfectly normal SQL Server agent doesn't comes in apps
July 7th, 2015 1:09am

Perfectly normal SQL Server agent doesn't comes in apps

Free Windows Admin Tool Kit Click here and download it now
July 9th, 2015 1:12am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics