SQL Server 2008 Express Edition

  • SQL Server Agent (SQLEXPRESS) service is not started and when I try start it I get this

    message:

    SQL Server Agent (SQLEXPRESS) service on Local Computer started and then stopped. Some

    sercices stop automatically if they have no work to do, for example, the Perfomance Logs

    and Alerts services.

    This service is not enabled for Express Edition. It permits to schedule jobs on Sql

    Server Instances. No importance except if you want to transfer data data between

    instances or if you want to have jobs daily executed at fixed time

  • Use this link to see the features supported by SQL Server 2008 (all editions).

    http://technet.microsoft.com/en-us/library/cc645993(SQL.100).aspx

    Scroll down the page a good ways to Management Tools and you wil see that SQL Agent is NOT supported by any of the variations of SQL 2008 Express

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Yes...I have gone through it.If that is the reason then how Standard Edition Server for Lync Server can be installed with SQL Server 2008 Express.In the Lync Server 2010 Deployment console while configuring the "Prepare first Standard Edition server" the entire execution get haults at the step "Prerequisite installation failed: SqlExpressRtc" ?

  • Try the command at the bottom of following link:

    http://social.technet.microsoft.com/Forums/en-US/ocsplanningdeployment/thread/b566ec61-92ec-4187-9142-ec37e5a5d4e4

    If you are trying to install Lync on DC, you will have error.

    You might need to change the path to SQLEXPR_x64.exe and the parameter after /SQLSYSADMINACCOUNTS

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply