Win XP Pro
I have - apparently successful - installed SQL Server 2005 Express, with all
the possible options Incl replication option.
I also have - successfully - installed the SSMS Express

(concurrently, SQL Server 2000 Desktop Engine is installed and running in 2
instances)

However, When I go into the SQL Server service Management, select the
installed 2005 server, and select the SQL Server Agent, following
errormessage pops up:

"The specified service does not exist as an installed service"

How can I install this service?

Regards

Anders

Do you have another SQL Server Edition other than SQL Server 2005 Express
Edition and MSDE installed on your system?

Because these editions of SQL Server does not have SQL Server Agent service
and can not be installed as a seperate package. You can install and use this
service only using other editions of SQL Server such as Workgroup, Standard,
Developer, Enterprise.

I do not have any clue why it appears in that list. I just can think of
another installed edition of SQL Server other then Express and MSDE.

--
Ekrem Önsoy



"Anders Balslev" <AndersBalslev@discussions.microsoft.com> wrote in message
news:C03CFC69-15D5-450A-876F-87DD314B417C@microsoft.com...
> Win XP Pro
> I have - apparently successful - installed SQL Server 2005 Express, with
> all
> the possible options Incl replication option.
> I also have - successfully - installed the SSMS Express
>
> (concurrently, SQL Server 2000 Desktop Engine is installed and running in
> 2
> instances)
>
> However, When I go into the SQL Server service Management, select the
> installed 2005 server, and select the SQL Server Agent, following
> errormessage pops up:
>
> "The specified service does not exist as an installed service"
>
> How can I install this service?
>
> Regards
>
> Anders

I also have MSDE installed on the labtop - none else.

I'm surprised that MSDE (which is the counter edition of express, but
SQL2000) do have the server agent, but not SQL 2005 Express

The reason is that I have made a merge replication system where a central
server (SQL 2005 Enterprise) is the distributor and publisher, and 20-30
small labtops is subscribers (pull subscribtion)

This means that we have to get licences to all of the labtops, since SQL
2005 Express cannot be setup as a subscriber in a replication system

regards
Anders

"Ekrem Önsoy" wrote:

> Do you have another SQL Server Edition other than SQL Server 2005 Express
> Edition and MSDE installed on your system?
>
> Because these editions of SQL Server does not have SQL Server Agent service
> and can not be installed as a seperate package. You can install and use this
> service only using other editions of SQL Server such as Workgroup, Standard,
> Developer, Enterprise.
>
> I do not have any clue why it appears in that list. I just can think of
> another installed edition of SQL Server other then Express and MSDE.
>
> --
> Ekrem Önsoy
>
>
>
> "Anders Balslev" <AndersBalslev@discussions.microsoft.com> wrote in message
> news:C03CFC69-15D5-450A-876F-87DD314B417C@microsoft.com...
> > Win XP Pro
> > I have - apparently successful - installed SQL Server 2005 Express, with
> > all
> > the possible options Incl replication option.
> > I also have - successfully - installed the SSMS Express
> >
> > (concurrently, SQL Server 2000 Desktop Engine is installed and running in
> > 2
> > instances)
> >
> > However, When I go into the SQL Server service Management, select the
> > installed 2005 server, and select the SQL Server Agent, following
> > errormessage pops up:
> >
> > "The specified service does not exist as an installed service"
> >
> > How can I install this service?
> >
> > Regards
> >
> > Anders
>

> I'm surprised that MSDE (which is the counter edition of express, but
> SQL2000) do have the server agent, but not SQL 2005 Express

It's a trade-off. Express users get enhancements over MSDE like 4GB db
sizes instead of 2GB, no more throttling on concurrency (a.k.a. Workload
governor), full-text search, and the availability of a management tool
(SSMSE). SQL Server Agent was more of a management and deployment issue
than a "we're taking this away from you" issue.

> This means that we have to get licences to all of the labtops, since SQL
> 2005 Express cannot be setup as a subscriber in a replication system

From
http://www.microsoft.com/technet/pro...qlexpress.mspx :

"While SQL Server 2005 Express cannot act as a replication publisher, it
does support subscriptions to merge, snapshot, and transactional
publications"

If you are reaching your conclusion based solely on the lack of SQL Server
Agent, remember that you can still schedule tasks in SQL Server Express
using Windows Task Scheduler and SQLCMD or osql, or you can have
multi-server jobs set up on a higher SKU in the network that start tasks on
Express remotely.

A

Hello Anders,

You know, everything has a cost and one of costs of using Express Edition is
being lack of SQL Agent.

As Aaron said, you can use your Express Editions as Subscribers for your
Replication topology. But in this case, you'll be able to use only your
Distributor to PULL and PUSH stuff.

I have an article about how to use automatic jobs in SQL Server Express
Edition, but it's in Turkish. There must be other articles about how to do
this on web if you google for it. Simply, you create a T-SQL Script file
that contains T-SQL commands about the job to be performed and you'll run it
using SQLCMD and schedule to make it run using Windows Scheduler.
--
Ekrem Önsoy



"Anders Balslev" <AndersBalslev@discussions.microsoft.com> wrote in message
news:3835F487-3BE3-43A1-9E06-DE458C60FC28@microsoft.com...
>I also have MSDE installed on the labtop - none else.
>
> I'm surprised that MSDE (which is the counter edition of express, but
> SQL2000) do have the server agent, but not SQL 2005 Express
>
> The reason is that I have made a merge replication system where a central
> server (SQL 2005 Enterprise) is the distributor and publisher, and 20-30
> small labtops is subscribers (pull subscribtion)
>
> This means that we have to get licences to all of the labtops, since SQL
> 2005 Express cannot be setup as a subscriber in a replication system
>
> regards
> Anders
>
> "Ekrem Önsoy" wrote:
>
>> Do you have another SQL Server Edition other than SQL Server 2005 Express
>> Edition and MSDE installed on your system?
>>
>> Because these editions of SQL Server does not have SQL Server Agent
>> service
>> and can not be installed as a seperate package. You can install and use
>> this
>> service only using other editions of SQL Server such as Workgroup,
>> Standard,
>> Developer, Enterprise.
>>
>> I do not have any clue why it appears in that list. I just can think of
>> another installed edition of SQL Server other then Express and MSDE.
>>
>> --
>> Ekrem Önsoy
>>
>>
>>
>> "Anders Balslev" <AndersBalslev@discussions.microsoft.com> wrote in
>> message
>> news:C03CFC69-15D5-450A-876F-87DD314B417C@microsoft.com...
>> > Win XP Pro
>> > I have - apparently successful - installed SQL Server 2005 Express,
>> > with
>> > all
>> > the possible options Incl replication option.
>> > I also have - successfully - installed the SSMS Express
>> >
>> > (concurrently, SQL Server 2000 Desktop Engine is installed and running
>> > in
>> > 2
>> > instances)
>> >
>> > However, When I go into the SQL Server service Management, select the
>> > installed 2005 server, and select the SQL Server Agent, following
>> > errormessage pops up:
>> >
>> > "The specified service does not exist as an installed service"
>> >
>> > How can I install this service?
>> >
>> > Regards
>> >
>> > Anders
>>