SQL licensing for Service Connect and APM use

Sorry Bill, we're going live next week so I didn't read your message
until now.

We're using both Service Connect and APM with SQL Express in a very
similar environment to what you have. I have successfully done
several data imports using Service Connect with no problem
whatsoever. We are phasing in APM so I have only sent a few test
messages, but again, had no problem.

I hope this helps.

--- In vantage@yahoogroups.com, "hoomail4me" <hoomail4me@...> wrote:
>
> Apparently no one using Service Connect or APM and/or don't
understand
> SQL licensing?
>
> Bill
>
> --- In vantage@yahoogroups.com, "hoomail4me" <hoomail4me@> wrote:
> >
> > We are running Vantage 8.03.404B on OpenEdge. I need SQL for APM
and
> > Service Connect and am getting conflicting advise on the version
and
> > licensing requirements for SQL to support these two applications.
> > Users are not accessing the SQL database directly, it's the
> > applications that use SQL so it creates some confusion on
licensing.
> >
> > I understand that I could use SQL Express edition but am afraid of
> > running into it's limitations at some point. Will be running on
Win03
> > Enterprise Edition 32Bit server w/2 dual core 3GHz CPUs and 8GB
ram.
> >
> > Can anyone comment on the best and most cost effective choice?
> >
> > Version:
> > 1) SQL 2005 Express Edition
> > 2) SQL 2005 Standard
> > 3) SQL 2005 Workgroup
> >
> > Licensing:
> > 1) Server + Device CALs
> > 2) Server + User CALs
> > 3) Processor
> >
> > Thanks
> >
>
We are running Vantage 8.03.404B on OpenEdge. I need SQL for APM and
Service Connect and am getting conflicting advise on the version and
licensing requirements for SQL to support these two applications.
Users are not accessing the SQL database directly, it's the
applications that use SQL so it creates some confusion on licensing.

I understand that I could use SQL Express edition but am afraid of
running into it's limitations at some point. Will be running on Win03
Enterprise Edition 32Bit server w/2 dual core 3GHz CPUs and 8GB ram.

Can anyone comment on the best and most cost effective choice?

Version:
1) SQL 2005 Express Edition
2) SQL 2005 Standard
3) SQL 2005 Workgroup

Licensing:
1) Server + Device CALs
2) Server + User CALs
3) Processor

Thanks
Apparently no one using Service Connect or APM and/or don't understand
SQL licensing?

Bill

--- In vantage@yahoogroups.com, "hoomail4me" <hoomail4me@...> wrote:
>
> We are running Vantage 8.03.404B on OpenEdge. I need SQL for APM and
> Service Connect and am getting conflicting advise on the version and
> licensing requirements for SQL to support these two applications.
> Users are not accessing the SQL database directly, it's the
> applications that use SQL so it creates some confusion on licensing.
>
> I understand that I could use SQL Express edition but am afraid of
> running into it's limitations at some point. Will be running on Win03
> Enterprise Edition 32Bit server w/2 dual core 3GHz CPUs and 8GB ram.
>
> Can anyone comment on the best and most cost effective choice?
>
> Version:
> 1) SQL 2005 Express Edition
> 2) SQL 2005 Standard
> 3) SQL 2005 Workgroup
>
> Licensing:
> 1) Server + Device CALs
> 2) Server + User CALs
> 3) Processor
>
> Thanks
>
Licensing per processor is the most expensive option if you're a SMB
depending on the amount of users you have accessing the database.
User CAL's are the most cost effective for a limited amount of users.
Device CAL's are best when multiple users attached via the same
device (ie: shared machines on the shop floor). Applications
accessing data are not relevant to licensing. Users and/or devices
are. If one application is accessing data, but there are 50 users
utilizing that application you need licenses to cover the 50 users.

Editions are also dependent on access requirements. I'm not familiar
with the workgroup edition, but standard is the way to go for most
SMB unless you have machines with more than 4 processors, more than 2
clusters or need things such as indexed views that enterprise ed
allows. Express is the the new desktop edition it seems to me and I
don't believe will work in your environment.


--- In vantage@yahoogroups.com, "hoomail4me" <hoomail4me@...> wrote:
>
> Apparently no one using Service Connect or APM and/or don't
understand
> SQL licensing?
>
> Bill
>
> --- In vantage@yahoogroups.com, "hoomail4me" <hoomail4me@> wrote:
> >
> > We are running Vantage 8.03.404B on OpenEdge. I need SQL for APM
and
> > Service Connect and am getting conflicting advise on the version
and
> > licensing requirements for SQL to support these two applications.
> > Users are not accessing the SQL database directly, it's the
> > applications that use SQL so it creates some confusion on
licensing.
> >
> > I understand that I could use SQL Express edition but am afraid of
> > running into it's limitations at some point. Will be running on
Win03
> > Enterprise Edition 32Bit server w/2 dual core 3GHz CPUs and 8GB
ram.
> >
> > Can anyone comment on the best and most cost effective choice?
> >
> > Version:
> > 1) SQL 2005 Express Edition
> > 2) SQL 2005 Standard
> > 3) SQL 2005 Workgroup
> >
> > Licensing:
> > 1) Server + Device CALs
> > 2) Server + User CALs
> > 3) Processor
> >
> > Thanks
> >
>