availability of Enterprise Manager

Is there a way to run the user interface tools for SQL Server, such as
Enterprise Manager and Query Analyzer, from two different computers on a
network, or do you need a separate license for each computer that will be
running them?
We are considering migrating to SQL Server, and we will have two developers
working on it. We will be installing our data in only one database, so we
only need one copy of SQL Server for the actual database. However, both
developers will need access to the user interface tools. Does this mean we
need to purchase two copies of SQL Server if the developers are working from
two different computers?
Thanks in advance,
Paul
"Paul Ponzelli" <begone@.spam.forever> wrote in
news:O4VpAi5PFHA.2252@.TK2MSFTNGP15.phx.gbl:

> Is there a way to run the user interface tools for SQL Server, such as
> Enterprise Manager and Query Analyzer, from two different computers on
> a network, or do you need a separate license for each computer that
> will be running them?
> We are considering migrating to SQL Server, and we will have two
> developers working on it. We will be installing our data in only one
> database, so we only need one copy of SQL Server for the actual
> database. However, both developers will need access to the user
> interface tools. Does this mean we need to purchase two copies of SQL
> Server if the developers are working from two different computers?
Licensing is not my field, but I try... If you're running in per processor
licensing mode I do not think that you need extra licenses for the
developers. Otherwise I think you only have to ensure that the developers
have client license to the database. What you should consider (in my
opinion) since this seems to be a development project, is to buy one MSDN
license for each developer. As far as I've understood Microsofts policy,
that should do, even without any licenses for the Server.
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging
|||Thanks for your reply, Ole. However, everyone in my organization already
has a copy of Access 2002, and thus a license for MSDE. But MSDE doesn't
have the Enterprise Manager tool, and that's what I'm asking about. Can
developers on two different computers use Enterprise Manager for a SQL
Server database without having to buy two copies of SQL Server, or is there
a way they can both use Enterprise Manager from a single copy of SQL Server?
"Ole Kristian Bangs" <olekristian.bangas@.masterminds.no> wrote in message
news:Xns9636EFC48769Folekristianbangaas@.207.46.248 .16...
> "Paul Ponzelli" <begone@.spam.forever> wrote in
> news:O4VpAi5PFHA.2252@.TK2MSFTNGP15.phx.gbl:
>
> Licensing is not my field, but I try... If you're running in per processor
> licensing mode I do not think that you need extra licenses for the
> developers. Otherwise I think you only have to ensure that the developers
> have client license to the database. What you should consider (in my
> opinion) since this seems to be a development project, is to buy one MSDN
> license for each developer. As far as I've understood Microsofts policy,
> that should do, even without any licenses for the Server.
> --
> Ole Kristian Bangs
> MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging
|||"Paul Ponzelli" <begone@.spam.forever> wrote in
news:u6WUar6PFHA.3336@.TK2MSFTNGP09.phx.gbl:

> Thanks for your reply, Ole. However, everyone in my organization
> already has a copy of Access 2002, and thus a license for MSDE. But
> MSDE doesn't have the Enterprise Manager tool, and that's what I'm
> asking about. Can developers on two different computers use
> Enterprise Manager for a SQL Server database without having to buy two
> copies of SQL Server, or is there a way they can both use Enterprise
> Manager from a single copy of SQL Server?
Note: I said MSDN, not MSDE. MSDN is Microsoft Developer Network, which
gives access to software for testing and development purposes. One MSDN
membership is (as far as I know) required per developer. Except for that,
no other licenses should be neccessary. For further information:
http://msdn.microsoft.com/howtobuy/vs2005/subscribe/
Ole Kristian Bangs
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging
|||>> I said MSDN, not MSDE.
You're right! Duh.
Thanks so much, Ole.
|||hi,
in addition to Ole answer, you can get SQL Server Developer edition for
about $50, which includes all the client tools ...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.11.1 - DbaMgr ver 0.57.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||That's Great! Thanks, Andrea.