SQL Server 2008 Express Edition

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » SQL Server 2008 Express Edition

SQL Server 2008 Express Edition

Rate Topic

Display Mode

Topic Options

Author

Message

jishasharon

Posted Thursday, January 06, 2011 7:58 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, January 14, 2011 6:40 AM
Points: 2, Visits: 7

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

Post #1043780

bitbucket-25253

Posted Thursday, January 06, 2011 8:43 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 5:40 PM
Points: 5,123, Visits: 20,370

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
Before posting a performance problem please read

Post #1043818

jishasharon

Posted Thursday, January 06, 2011 11:51 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, January 14, 2011 6:40 AM
Points: 2, Visits: 7

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" ?

Post #1044163

chunchu

Posted Tuesday, January 11, 2011 4:46 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, January 11, 2011 5:26 PM
Points: 1, Visits: 1

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

Post #1046207

« Prev Topic | Next Topic »

Permissions