I downloaded SQL Server 2012 and installed Evaluation with full option but I can't find SQL Server Agent.
Should I download it separately?
Technology Tips and News
I downloaded SQL Server 2012 and installed Evaluation with full option but I can't find SQL Server Agent.
Should I download it separately?
What edition you installed? Express or some other?
Did you check agent component in the list while running the wizard
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:
Hope this helps !
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
It's not Express version.
I downloaded standard version from here
I selected full options when I installed it.
Try repairing or re-installing.
You installation might have corrupted agent. From your link I can see that you have not installed express edition.
The output of SELECT ServerProperty('Edition') is
Enterprise Evaluation Edition (64-bit)
The output of SELECT ServerProperty('Edition') is
Enterprise Evaluation Edition (64-bit)
The output of SELECT ServerProperty('Edition') is
Enterprise Evaluation Edition (64-bit)
The output of SELECT ServerProperty('Edition') is
Enterprise Evaluation Edition (64-bit)
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
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
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.
I can't find even SQL Server Configuration.
It seems that I should uninstall and re-install.
I can't find even SQL Server Configuration.
It seems that I should uninstall and re-install.
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?
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
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 appsI 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