Enterprise Manager on a workstation

Hi
I have a customer who uses SQL running on an SBS2000 server for several
applications. They have asked if
they can install SQL Enterprise manager on a workstation to manage an
Internet booking system they use.
Can anyone suggest any issues with this please? I'm assuming that there's a
licensing issue, but would there also be a network issue?
Regards
Nick
As long as the workstation has a licence to use the SQL Server it can also
use the managing tools.
There are no Networking issues as far as the EM is also only just a client
app with some more features than only quering or manipulating some data.
HTH, Jens Smeyer.
http://www.sqlserver2005.de
"Nick Hill" <please@.dont.use> schrieb im Newsbeitrag
news:d3jfu0$4ft$1$8302bc10@.news.demon.co.uk...
> Hi
> I have a customer who uses SQL running on an SBS2000 server for several
> applications. They have asked if
> they can install SQL Enterprise manager on a workstation to manage an
> Internet booking system they use.
> Can anyone suggest any issues with this please? I'm assuming that there's
> a licensing issue, but would there also be a network issue?
> Regards
> Nick
>
|||There is no problem in principle running Enterprise Manager or any of
the other client tools on a client PC - they are designed for that. You
need either a Client Access Licence or a Processor Licence for the
server.
If you are thinking about access over the Internet however, you won't
have the necessary ports open, except maybe via a secure VPN. You'll
most likely want some kind of remote access solution and then run EM
from there.
David Portas
SQL Server MVP
|||Doesn't MSDE come with the Enterprise Manager and as far as i know the MSDE
is free.
Does that mean that using the Enterprise Manager that MSDE comes with to
connect to another SQL server engine requires a licence?
-Ash
"David Portas" wrote:

> There is no problem in principle running Enterprise Manager or any of
> the other client tools on a client PC - they are designed for that. You
> need either a Client Access Licence or a Processor Licence for the
> server.
> If you are thinking about access over the Internet however, you won't
> have the necessary ports open, except maybe via a secure VPN. You'll
> most likely want some kind of remote access solution and then run EM
> from there.
> --
> David Portas
> SQL Server MVP
> --
>
|||> Doesn't MSDE come with the Enterprise Manager and as far as i know the
> MSDE
> is free.
MSDE comes with OSQL , no EM :-)

> Does that mean that using the Enterprise Manager that MSDE comes with to
> connect to another SQL server engine requires a licence?
But there is a webTool from MS to administer SQl Server Databases with basic
functionality:
http://www.microsoft.com/downloads/d...DisplayLang=en
HTH, Jens Smeyer
http://www.sqlserver2005.de
"Ash Metry" <AshMetry@.discussions.microsoft.com> schrieb im Newsbeitrag
news:033E925D-FB59-4211-BC67-7904A8686A89@.microsoft.com...[vbcol=seagreen]
> Doesn't MSDE come with the Enterprise Manager and as far as i know the
> MSDE
> is free.
> Does that mean that using the Enterprise Manager that MSDE comes with to
> connect to another SQL server engine requires a licence?
> -Ash
> "David Portas" wrote:
|||MSDE does not come with Enterprise Manager. The MSDE license does not cover
using Enterprise Manager.
Geoff N. Hiten
Microsoft SQL Server MVP
"Ash Metry" <AshMetry@.discussions.microsoft.com> wrote in message
news:033E925D-FB59-4211-BC67-7904A8686A89@.microsoft.com...[vbcol=seagreen]
> Doesn't MSDE come with the Enterprise Manager and as far as i know the
> MSDE
> is free.
> Does that mean that using the Enterprise Manager that MSDE comes with to
> connect to another SQL server engine requires a licence?
> -Ash
> "David Portas" wrote:
|||Ya i remember now.
Sorry about that, I posted without thinking.
"Geoff N. Hiten" wrote:

> MSDE does not come with Enterprise Manager. The MSDE license does not cover
> using Enterprise Manager.
> Geoff N. Hiten
> Microsoft SQL Server MVP
> "Ash Metry" <AshMetry@.discussions.microsoft.com> wrote in message
> news:033E925D-FB59-4211-BC67-7904A8686A89@.microsoft.com...
>
>