Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Liz Lyons
Starting Member
22 Posts |
 Posted - 2010-02-16 : 11:39:35
|
After installing SQL Server 2008 Express Advanced Edition I tried to start SQL Server Agent from Configuration Manager and got an error message "This service cannot be started, either because it is disabled or because it had no enabled device associated with it [0x80070422]The installation pathway looks ok.Can anyone please suggest how to follow up this error message, or give a translation?Newbie question  |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-16 : 12:04:52
|
| SQL Express does not come with SQL Server Agent.If you have SQL Server Agent available in your Services list that can only have been from a different installation of the FULL SQL Server product (or an earlier version of the Full product) |
 |
|
|
Liz Lyons
Starting Member
22 Posts |
Posted - 2010-02-16 : 12:51:07
|
| Thanks Kristen - are you sure that SQL Express Advanced Edition does not come with SQL Server Agent?Advanced Edition has extra features.The pathway shown is:'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Binn\SQLAGENT.EXE which surely looks as if it's installed, but the Service Account shows as Network Services and won't change in Config Manager.I have no previous installation of any product on this computer, certainly not the full one.Thanks for trying to help so quickly!! |
|
|
|
Liz Lyons
Starting Member
22 Posts |
Posted - 2010-02-16 : 13:19:12
|
| AHA! http://support.microsoft.com/kb/955763"in SQL Server 2008 Express and Express with Advanced Services, the SQL Server Agent is created but not enabled".The above link describes the necessity of manually enabling SQL Server Agent after upgrading from Express to Developer/ Standard/ Enterprise editions - interesting :) - Developer Edition here I come! |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-16 : 13:23:22
|
| Sorry, misread your post. I thought you were trying to start the SQL Agent Service - actually you were just trying to select it in Config Manager. A bit nuts that Config Manager doesn't make a better job of telling you its not there ...http://msdn.microsoft.com/en-us/library/ms365248.aspx#sectionToggle1It aint there! |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-16 : 13:25:25
|
| Well if you are doing DEV work for a product then Developer Version is definitely the way to go ... you get the full Enrerprise version for "not very much".But you can't use it for hosting any Production Databases of course ... |
|
|
|
|
|
|
SQL Agent "Boot, System, Disabled, Unknown"