enterprise to standard

dear all,

if one has purchased enterprise edition of sql server, could he install the standard version instead of the enterprise one without violating software license?

regards

My suggestion would be to contact the vendor that you purchased the licenese through and check with them.

Thanks,
Sam Lester (MSFT)

enterprise to standard

dear all,

if one has purchased enterprise edition of sql server, could he install the standard version instead of the enterprise one without violating software license?

regards

My suggestion would be to contact the vendor that you purchased the licenese through and check with them.

Thanks,
Sam Lester (MSFT)

Enterprise or not?

Dear ALL,
I'm going to install a new cluster (2 X HP DL380 , MSA1000 Storage) based on
Win 2003 R2 Enterprise and I 'd like to know if I have to install SQL SERVER
2005 Enterprise or standard version could be fine.
Regards
Alberto BrivioStandard will work on a two node cluster but you may loose some other
features you need. Check out the feature comparison in BOL.
--
Jason Massie
Web: http://statisticsio.com
RSS: http://feeds.feedburner.com/statisticsio
"Alberto Brivio" <a.brivio@.adb.it> wrote in message
news:uZci$GBPIHA.1208@.TK2MSFTNGP05.phx.gbl...
> Dear ALL,
> I'm going to install a new cluster (2 X HP DL380 , MSA1000 Storage) based
> on Win 2003 R2 Enterprise and I 'd like to know if I have to install SQL
> SERVER 2005 Enterprise or standard version could be fine.
>
> Regards
> Alberto Brivio
>|||You better determine your needs first...
--
Ekrem Önsoy
"Alberto Brivio" <a.brivio@.adb.it> wrote in message
news:uZci$GBPIHA.1208@.TK2MSFTNGP05.phx.gbl...
> Dear ALL,
> I'm going to install a new cluster (2 X HP DL380 , MSA1000 Storage) based
> on Win 2003 R2 Enterprise and I 'd like to know if I have to install SQL
> SERVER 2005 Enterprise or standard version could be fine.
>
> Regards
> Alberto Brivio
>|||Alberto,
With SQL2005 the version will depend on the number of CPU's rather than the
memory and of course the features you require. If your server has more than
4 CPU's and you want SQL to use them then you must use Enterprise.
Chris
"Alberto Brivio" <a.brivio@.adb.it> wrote in message
news:uZci$GBPIHA.1208@.TK2MSFTNGP05.phx.gbl...
> Dear ALL,
> I'm going to install a new cluster (2 X HP DL380 , MSA1000 Storage) based
> on Win 2003 R2 Enterprise and I 'd like to know if I have to install SQL
> SERVER 2005 Enterprise or standard version could be fine.
>
> Regards
> Alberto Brivio
>

Enterprise or not?

Dear ALL,
I'm going to install a new cluster (2 X HP DL380 , MSA1000 Storage) based on
Win 2003 R2 Enterprise and I 'd like to know if I have to install SQL SERVER
2005 Enterprise or standard version could be fine.
Regards
Alberto BrivioStandard will work on a two node cluster but you may loose some other
features you need. Check out the feature comparison in BOL.
Jason Massie
Web: http://statisticsio.com
RSS: http://feeds.feedburner.com/statisticsio
"Alberto Brivio" <a.brivio@.adb.it> wrote in message
news:uZci$GBPIHA.1208@.TK2MSFTNGP05.phx.gbl...
> Dear ALL,
> I'm going to install a new cluster (2 X HP DL380 , MSA1000 Storage) based
> on Win 2003 R2 Enterprise and I 'd like to know if I have to install SQL
> SERVER 2005 Enterprise or standard version could be fine.
>
> Regards
> Alberto Brivio
>|||You better determine your needs first...
Ekrem nsoy
"Alberto Brivio" <a.brivio@.adb.it> wrote in message
news:uZci$GBPIHA.1208@.TK2MSFTNGP05.phx.gbl...
> Dear ALL,
> I'm going to install a new cluster (2 X HP DL380 , MSA1000 Storage) based
> on Win 2003 R2 Enterprise and I 'd like to know if I have to install SQL
> SERVER 2005 Enterprise or standard version could be fine.
>
> Regards
> Alberto Brivio
>|||Alberto,
With SQL2005 the version will depend on the number of CPU's rather than the
memory and of course the features you require. If your server has more than
4 CPU's and you want SQL to use them then you must use Enterprise.
Chris
"Alberto Brivio" <a.brivio@.adb.it> wrote in message
news:uZci$GBPIHA.1208@.TK2MSFTNGP05.phx.gbl...
> Dear ALL,
> I'm going to install a new cluster (2 X HP DL380 , MSA1000 Storage) based
> on Win 2003 R2 Enterprise and I 'd like to know if I have to install SQL
> SERVER 2005 Enterprise or standard version could be fine.
>
> Regards
> Alberto Brivio
>

Enterprise Manager tail snap-in initialization

Hi Guys,
I tried to install client tools of Sql Server 2005 DevEd. Wow! Big
product... but my boss imposed me to deinstall this tools.
Now when I launch Enterprise Manager I get this message:
Snap-in failed to initialize.
Name:<unknown>
CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F}
I already tried to verify to have access my local register (I'm
connected to a domain) and reregister DMO typing:
regsvr32 "c:\Program Files\Microsoft SQL
Server\80\Tools\Binn\SQLDMO.DLL"
Registration succeed but.. the problem it's not solved.
I would not to reinstall Sql Server 2000 if it's possible.
Can you give me an help, please?
My Best Regards
PierpaoloI am afraid you need to install the tools, otherwise you can=B4t access
the EM.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--|||Uninstalling SQL 2005 unregisters the dmo dll's so EM doesn't work in SQL
2000 anymore, try this:
regsvr32 "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqldmo.dll"
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Pierpaolo" <pierpaolo.simoncini@.txt.it> wrote in message
news:1144061808.495311.176670@.e56g2000cwe.googlegroups.com...
> Hi Guys,
> I tried to install client tools of Sql Server 2005 DevEd. Wow! Big
> product... but my boss imposed me to deinstall this tools.
> Now when I launch Enterprise Manager I get this message:
> Snap-in failed to initialize.
> Name:<unknown>
> CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F}
> I already tried to verify to have access my local register (I'm
> connected to a domain) and reregister DMO typing:
> regsvr32 "c:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\SQLDMO.DLL"
> Registration succeed but.. the problem it's not solved.
> I would not to reinstall Sql Server 2000 if it's possible.
> Can you give me an help, please?
> My Best Regards
> Pierpaolo
>

Enterprise Manager tail snap-in initialization

Hi Guys,
I tried to install client tools of Sql Server 2005 DevEd. Wow! Big
product... but my boss imposed me to deinstall this tools.
Now when I launch Enterprise Manager I get this message:
Snap-in failed to initialize.
Name:<unknown>
CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F}
I already tried to verify to have access my local register (I'm
connected to a domain) and reregister DMO typing:
regsvr32 "c:\Program Files\Microsoft SQL
Server\80\Tools\Binn\SQLDMO.DLL"
Registration succeed but.. the problem it's not solved.
I would not to reinstall Sql Server 2000 if it's possible.
Can you give me an help, please?
My Best Regards
Pierpaolo
I am afraid you need to install the tools, otherwise you can=B4t access
the EM.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||Uninstalling SQL 2005 unregisters the dmo dll's so EM doesn't work in SQL
2000 anymore, try this:
regsvr32 "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqldmo.dll"
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Pierpaolo" <pierpaolo.simoncini@.txt.it> wrote in message
news:1144061808.495311.176670@.e56g2000cwe.googlegr oups.com...
> Hi Guys,
> I tried to install client tools of Sql Server 2005 DevEd. Wow! Big
> product... but my boss imposed me to deinstall this tools.
> Now when I launch Enterprise Manager I get this message:
> Snap-in failed to initialize.
> Name:<unknown>
> CLSID:{00100100-1816-11D0-8EF5-00AA0062C58F}
> I already tried to verify to have access my local register (I'm
> connected to a domain) and reregister DMO typing:
> regsvr32 "c:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\SQLDMO.DLL"
> Registration succeed but.. the problem it's not solved.
> I would not to reinstall Sql Server 2000 if it's possible.
> Can you give me an help, please?
> My Best Regards
> Pierpaolo
>

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...
>
>

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
NickAs 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/...&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 cov
er
> 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...
>
>

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
NickAs 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 Süßmeyer.
--
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.
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/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&DisplayLang=en
HTH, Jens Süßmeyer
--
http://www.sqlserver2005.de
--
"Ash Metry" <AshMetry@.discussions.microsoft.com> schrieb im Newsbeitrag
news:033E925D-FB59-4211-BC67-7904A8686A89@.microsoft.com...
> 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
>> --
>>|||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...
> 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
>> --
>>

Enterprise Manager No Longer connects

Hi,
After an install of visual stiudo team 2005 beta 2 I can no longer connect
to any SQL Server in my enterprise manager (But showes SQL Server running)
and I get a connection error when I try to edit an SP from query analyzer.
this is the error I see in both places.
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
do I need to reinstall MDAC? Remove VS 2005? Reinstall SQL Server Service
pack?
don
Silly question, but did you reboot your computer ? Did you uninstall all
further installation (perhaps another prerelase) there is an article about
that:
http://download.microsoft.com/downlo...ilCTPNotes.mht
http://www.sqlserver2005.de
HTH, Jens Suessmeyer.
"donron" <donron@.discussions.microsoft.com> schrieb im Newsbeitrag
news:F3DEB1F1-3ABD-4F48-B687-266D3C394AE4@.microsoft.com...
> Hi,
> After an install of visual stiudo team 2005 beta 2 I can no longer connect
> to any SQL Server in my enterprise manager (But showes SQL Server running)
> and I get a connection error when I try to edit an SP from query analyzer.
> this is the error I see in both places.
> [Microsoft][ODBC Driver Manager] Data source name not found and no default
> driver specified
> do I need to reinstall MDAC? Remove VS 2005? Reinstall SQL Server Service
> pack?
> --
> don
|||Hi,
I had no other pre-relase of VS 2005 on this system and have rebooted many
times since I had this problem.
"Jens Sü?meyer" wrote:

> Silly question, but did you reboot your computer ? Did you uninstall all
> further installation (perhaps another prerelase) there is an article about
> that:
> http://download.microsoft.com/downlo...ilCTPNotes.mht
> http://www.sqlserver2005.de
> HTH, Jens Suessmeyer.
> "donron" <donron@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:F3DEB1F1-3ABD-4F48-B687-266D3C394AE4@.microsoft.com...
>
>

Enterprise Manager No Longer connects

Hi,
After an install of visual stiudo team 2005 beta 2 I can no longer connect
to any SQL Server in my enterprise manager (But showes SQL Server running)
and I get a connection error when I try to edit an SP from query analyzer.
this is the error I see in both places.
[Microsoft][ODBC Driver Manager] Data source name not found and no d
efault
driver specified
do I need to reinstall MDAC? Remove VS 2005? Reinstall SQL Server Service
pack?
donSilly question, but did you reboot your computer ? Did you uninstall all
further installation (perhaps another prerelase) there is an article about
that:
AprilCTPNotes.mht" target="_blank">http://download.microsoft.com/downl...rilCTPNotes.mht
http://www.sqlserver2005.de
HTH, Jens Suessmeyer.
"donron" <donron@.discussions.microsoft.com> schrieb im Newsbeitrag
news:F3DEB1F1-3ABD-4F48-B687-266D3C394AE4@.microsoft.com...
> Hi,
> After an install of visual stiudo team 2005 beta 2 I can no longer connect
> to any SQL Server in my enterprise manager (But showes SQL Server running)
> and I get a connection error when I try to edit an SP from query analyzer.
> this is the error I see in both places.
> [Microsoft][ODBC Driver Manager] Data source name not found and no
default
> driver specified
> do I need to reinstall MDAC? Remove VS 2005? Reinstall SQL Server Service
> pack?
> --
> don|||Hi,
I had no other pre-relase of VS 2005 on this system and have rebooted many
times since I had this problem.
"Jens Sü?meyer" wrote:

> Silly question, but did you reboot your computer ? Did you uninstall all
> further installation (perhaps another prerelase) there is an article about
> that:
> 4/AprilCTPNotes.mht" target="_blank">http://download.microsoft.com/downl...rilCTPNotes.mht
> http://www.sqlserver2005.de
> HTH, Jens Suessmeyer.
> "donron" <donron@.discussions.microsoft.com> schrieb im Newsbeitrag
> news:F3DEB1F1-3ABD-4F48-B687-266D3C394AE4@.microsoft.com...
>
>

Enterprise Manager licensing question.

Hi,
Complete SQL Server newbie here.
I have one instance of SQL server and Enterprise Manager installed on my
server. Can I install Enterprise manager on two client computers so they
can administer the server from their desktop rather than sitting at the
server?
Thanks for your help,
Andy.Yes, if they have valid client licenses (or the SQL Server is licensed as per processor). As far as
I understand, I should add...
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Andy" <PLEASEREPLY@.THEGROUP.COM> wrote in message news:ejDjaVImDHA.2068@.TK2MSFTNGP09.phx.gbl...
> Hi,
> Complete SQL Server newbie here.
> I have one instance of SQL server and Enterprise Manager installed on my
> server. Can I install Enterprise manager on two client computers so they
> can administer the server from their desktop rather than sitting at the
> server?
> Thanks for your help,
> Andy.
>

Enterprise manager licencing

1. If someone is using SQL2000 MSDE, can he install enterprise manager to
manage it without SQL server licence?
2. If someone has a SQL2000 standard licence, can he install enterprise
manager (or any other CLIENT tools) to other client machines too?
3. SQL2005 express now has a GUI tool called Microsoft SQL Server Management
Studio Express that is free for download from Microsoft. Can it be used to
manage 2000 MSDE too?
Thanks
Tom
Hi Tom,
1. Yes. EM is a client tool which does not need to be licensed, because SQL
Server is licensed.
2. Yes. See above.
3. I'm not sure, but I think it is possible.
Danijel Novak
"Tom" <mcseman@.hotmail.com> wrote in message
news:%23LyUS4hGGHA.648@.TK2MSFTNGP14.phx.gbl...
> 1. If someone is using SQL2000 MSDE, can he install enterprise manager to
> manage it without SQL server licence?
> 2. If someone has a SQL2000 standard licence, can he install enterprise
> manager (or any other CLIENT tools) to other client machines too?
> 3. SQL2005 express now has a GUI tool called Microsoft SQL Server
> Management Studio Express that is free for download from Microsoft. Can it
> be used to manage 2000 MSDE too?
> Thanks
> Tom
>
|||Sorry Danijel & Tom, but:
1. No, you can't use SQL EM to manage the MSDE without a "real" SQL Server
license being involved. EM is licensed via a client access license from a
"real" SQL Server license.
2. Yes, if those systems have SQL Server CALs themselves.
3. Yes
HTH,
Greg
"Danijel Novak" <danijel.novak@.triera.net> wrote in message
news:ugwNzDnGGHA.1288@.TK2MSFTNGP09.phx.gbl...
> Hi Tom,
> 1. Yes. EM is a client tool which does not need to be licensed, because
> SQL Server is licensed.
> 2. Yes. See above.
> 3. I'm not sure, but I think it is possible.
> --
> Danijel Novak
>
> "Tom" <mcseman@.hotmail.com> wrote in message
> news:%23LyUS4hGGHA.648@.TK2MSFTNGP14.phx.gbl...
>
|||Danijel Novak wrote:
> Hi Tom,
> 1. Yes. EM is a client tool which does not need to be licensed, because SQL
> Server is licensed.
> 2. Yes. See above.
> 3. I'm not sure, but I think it is possible.
> --
> Danijel Novak
>
Danijel,

> 1. Yes. EM is a client tool which does not need to be licensed, because SQL
> Server is licensed.
That's not so. Client tools must ALWAYS be licensed. Tom either needs
to purchase a Server Processor licence or purchase a client licence for
each Enterprise Manager installation or user.
As to the other questions, if in doubt consult a Microsoft
representative but my understanding is that you cannot use Enterprise
Manager to manage MSDE installations.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
|||Hi Greg,
1. Is then any possibility to buy just EM license as buying SQL Server
license and CALs is to expensive for using just MSDE.
Thanks,
Danijel Novak
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:uB742BoGGHA.376@.TK2MSFTNGP12.phx.gbl...
> Sorry Danijel & Tom, but:
> 1. No, you can't use SQL EM to manage the MSDE without a "real" SQL Server
> license being involved. EM is licensed via a client access license from a
> "real" SQL Server license.
> 2. Yes, if those systems have SQL Server CALs themselves.
> 3. Yes
> HTH,
> Greg
> "Danijel Novak" <danijel.novak@.triera.net> wrote in message
> news:ugwNzDnGGHA.1288@.TK2MSFTNGP09.phx.gbl...
>
|||Hi Danijel,
No, that's why myself and others have built tools to do this. Mine were at
www.whitebearconsulting.com. There is a free personal use license for MSDE
Manager there.
Tons of others can be found online, both free and paid. It will be less of
an issue now with SQL Server Express edition which I'd suggest you look
into.
HTH,
Greg
"Danijel Novak" <danijel.novak@.triera.net> wrote in message
news:%23j1h6ToGGHA.596@.TK2MSFTNGP10.phx.gbl...
> Hi Greg,
> 1. Is then any possibility to buy just EM license as buying SQL Server
> license and CALs is to expensive for using just MSDE.
> Thanks,
> --
> Danijel Novak
>
> "Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
> news:uB742BoGGHA.376@.TK2MSFTNGP12.phx.gbl...
>

Enterprise manager licencing

1. If someone is using SQL2000 MSDE, can he install enterprise manager to
manage it without SQL server licence?
2. If someone has a SQL2000 standard licence, can he install enterprise
manager (or any other CLIENT tools) to other client machines too?
3. SQL2005 express now has a GUI tool called Microsoft SQL Server Management
Studio Express that is free for download from Microsoft. Can it be used to
manage 2000 MSDE too?
Thanks
TomHi Tom,
1. Yes. EM is a client tool which does not need to be licensed, because SQL
Server is licensed.
2. Yes. See above.
3. I'm not sure, but I think it is possible.
--
Danijel Novak
"Tom" <mcseman@.hotmail.com> wrote in message
news:%23LyUS4hGGHA.648@.TK2MSFTNGP14.phx.gbl...
> 1. If someone is using SQL2000 MSDE, can he install enterprise manager to
> manage it without SQL server licence?
> 2. If someone has a SQL2000 standard licence, can he install enterprise
> manager (or any other CLIENT tools) to other client machines too?
> 3. SQL2005 express now has a GUI tool called Microsoft SQL Server
> Management Studio Express that is free for download from Microsoft. Can it
> be used to manage 2000 MSDE too?
> Thanks
> Tom
>|||Sorry Danijel & Tom, but:
1. No, you can't use SQL EM to manage the MSDE without a "real" SQL Server
license being involved. EM is licensed via a client access license from a
"real" SQL Server license.
2. Yes, if those systems have SQL Server CALs themselves.
3. Yes
HTH,
Greg
"Danijel Novak" <danijel.novak@.triera.net> wrote in message
news:ugwNzDnGGHA.1288@.TK2MSFTNGP09.phx.gbl...
> Hi Tom,
> 1. Yes. EM is a client tool which does not need to be licensed, because
> SQL Server is licensed.
> 2. Yes. See above.
> 3. I'm not sure, but I think it is possible.
> --
> Danijel Novak
>
> "Tom" <mcseman@.hotmail.com> wrote in message
> news:%23LyUS4hGGHA.648@.TK2MSFTNGP14.phx.gbl...
>> 1. If someone is using SQL2000 MSDE, can he install enterprise manager to
>> manage it without SQL server licence?
>> 2. If someone has a SQL2000 standard licence, can he install enterprise
>> manager (or any other CLIENT tools) to other client machines too?
>> 3. SQL2005 express now has a GUI tool called Microsoft SQL Server
>> Management Studio Express that is free for download from Microsoft. Can
>> it be used to manage 2000 MSDE too?
>> Thanks
>> Tom
>|||Danijel Novak wrote:
> Hi Tom,
> 1. Yes. EM is a client tool which does not need to be licensed, because SQL
> Server is licensed.
> 2. Yes. See above.
> 3. I'm not sure, but I think it is possible.
> --
> Danijel Novak
>
Danijel,
> 1. Yes. EM is a client tool which does not need to be licensed, because SQL
> Server is licensed.
That's not so. Client tools must ALWAYS be licensed. Tom either needs
to purchase a Server Processor licence or purchase a client licence for
each Enterprise Manager installation or user.
As to the other questions, if in doubt consult a Microsoft
representative but my understanding is that you cannot use Enterprise
Manager to manage MSDE installations.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Hi Greg,
1. Is then any possibility to buy just EM license as buying SQL Server
license and CALs is to expensive for using just MSDE.
Thanks,
--
Danijel Novak
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:uB742BoGGHA.376@.TK2MSFTNGP12.phx.gbl...
> Sorry Danijel & Tom, but:
> 1. No, you can't use SQL EM to manage the MSDE without a "real" SQL Server
> license being involved. EM is licensed via a client access license from a
> "real" SQL Server license.
> 2. Yes, if those systems have SQL Server CALs themselves.
> 3. Yes
> HTH,
> Greg
> "Danijel Novak" <danijel.novak@.triera.net> wrote in message
> news:ugwNzDnGGHA.1288@.TK2MSFTNGP09.phx.gbl...
>> Hi Tom,
>> 1. Yes. EM is a client tool which does not need to be licensed, because
>> SQL Server is licensed.
>> 2. Yes. See above.
>> 3. I'm not sure, but I think it is possible.
>> --
>> Danijel Novak
>>
>> "Tom" <mcseman@.hotmail.com> wrote in message
>> news:%23LyUS4hGGHA.648@.TK2MSFTNGP14.phx.gbl...
>> 1. If someone is using SQL2000 MSDE, can he install enterprise manager
>> to manage it without SQL server licence?
>> 2. If someone has a SQL2000 standard licence, can he install enterprise
>> manager (or any other CLIENT tools) to other client machines too?
>> 3. SQL2005 express now has a GUI tool called Microsoft SQL Server
>> Management Studio Express that is free for download from Microsoft. Can
>> it be used to manage 2000 MSDE too?
>> Thanks
>> Tom
>>
>|||Hi Danijel,
No, that's why myself and others have built tools to do this. Mine were at
www.whitebearconsulting.com. There is a free personal use license for MSDE
Manager there.
Tons of others can be found online, both free and paid. It will be less of
an issue now with SQL Server Express edition which I'd suggest you look
into.
HTH,
Greg
"Danijel Novak" <danijel.novak@.triera.net> wrote in message
news:%23j1h6ToGGHA.596@.TK2MSFTNGP10.phx.gbl...
> Hi Greg,
> 1. Is then any possibility to buy just EM license as buying SQL Server
> license and CALs is to expensive for using just MSDE.
> Thanks,
> --
> Danijel Novak
>
> "Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
> news:uB742BoGGHA.376@.TK2MSFTNGP12.phx.gbl...
>> Sorry Danijel & Tom, but:
>> 1. No, you can't use SQL EM to manage the MSDE without a "real" SQL
>> Server license being involved. EM is licensed via a client access license
>> from a "real" SQL Server license.
>> 2. Yes, if those systems have SQL Server CALs themselves.
>> 3. Yes
>> HTH,
>> Greg
>> "Danijel Novak" <danijel.novak@.triera.net> wrote in message
>> news:ugwNzDnGGHA.1288@.TK2MSFTNGP09.phx.gbl...
>> Hi Tom,
>> 1. Yes. EM is a client tool which does not need to be licensed, because
>> SQL Server is licensed.
>> 2. Yes. See above.
>> 3. I'm not sure, but I think it is possible.
>> --
>> Danijel Novak
>>
>> "Tom" <mcseman@.hotmail.com> wrote in message
>> news:%23LyUS4hGGHA.648@.TK2MSFTNGP14.phx.gbl...
>> 1. If someone is using SQL2000 MSDE, can he install enterprise manager
>> to manage it without SQL server licence?
>> 2. If someone has a SQL2000 standard licence, can he install enterprise
>> manager (or any other CLIENT tools) to other client machines too?
>> 3. SQL2005 express now has a GUI tool called Microsoft SQL Server
>> Management Studio Express that is free for download from Microsoft. Can
>> it be used to manage 2000 MSDE too?
>> Thanks
>> Tom
>>
>>
>

Enterprise manager licencing

1. If someone is using SQL2000 MSDE, can he install enterprise manager to
manage it without SQL server licence?
2. If someone has a SQL2000 standard licence, can he install enterprise
manager (or any other CLIENT tools) to other client machines too?
3. SQL2005 express now has a GUI tool called Microsoft SQL Server Management
Studio Express that is free for download from Microsoft. Can it be used to
manage 2000 MSDE too?
Thanks
TomHi Tom,
1. Yes. EM is a client tool which does not need to be licensed, because SQL
Server is licensed.
2. Yes. See above.
3. I'm not sure, but I think it is possible.
Danijel Novak
"Tom" <mcseman@.hotmail.com> wrote in message
news:%23LyUS4hGGHA.648@.TK2MSFTNGP14.phx.gbl...
> 1. If someone is using SQL2000 MSDE, can he install enterprise manager to
> manage it without SQL server licence?
> 2. If someone has a SQL2000 standard licence, can he install enterprise
> manager (or any other CLIENT tools) to other client machines too?
> 3. SQL2005 express now has a GUI tool called Microsoft SQL Server
> Management Studio Express that is free for download from Microsoft. Can it
> be used to manage 2000 MSDE too?
> Thanks
> Tom
>|||Sorry Danijel & Tom, but:
1. No, you can't use SQL EM to manage the MSDE without a "real" SQL Server
license being involved. EM is licensed via a client access license from a
"real" SQL Server license.
2. Yes, if those systems have SQL Server CALs themselves.
3. Yes
HTH,
Greg
"Danijel Novak" <danijel.novak@.triera.net> wrote in message
news:ugwNzDnGGHA.1288@.TK2MSFTNGP09.phx.gbl...
> Hi Tom,
> 1. Yes. EM is a client tool which does not need to be licensed, because
> SQL Server is licensed.
> 2. Yes. See above.
> 3. I'm not sure, but I think it is possible.
> --
> Danijel Novak
>
> "Tom" <mcseman@.hotmail.com> wrote in message
> news:%23LyUS4hGGHA.648@.TK2MSFTNGP14.phx.gbl...
>|||Danijel Novak wrote:
> Hi Tom,
> 1. Yes. EM is a client tool which does not need to be licensed, because SQ
L
> Server is licensed.
> 2. Yes. See above.
> 3. I'm not sure, but I think it is possible.
> --
> Danijel Novak
>
Danijel,

> 1. Yes. EM is a client tool which does not need to be licensed, because SQ
L
> Server is licensed.
That's not so. Client tools must ALWAYS be licensed. Tom either needs
to purchase a Server Processor licence or purchase a client licence for
each Enterprise Manager installation or user.
As to the other questions, if in doubt consult a Microsoft
representative but my understanding is that you cannot use Enterprise
Manager to manage MSDE installations.
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--|||Hi Greg,
1. Is then any possibility to buy just EM license as buying SQL Server
license and CALs is to expensive for using just MSDE.
Thanks,
Danijel Novak
"Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
news:uB742BoGGHA.376@.TK2MSFTNGP12.phx.gbl...
> Sorry Danijel & Tom, but:
> 1. No, you can't use SQL EM to manage the MSDE without a "real" SQL Server
> license being involved. EM is licensed via a client access license from a
> "real" SQL Server license.
> 2. Yes, if those systems have SQL Server CALs themselves.
> 3. Yes
> HTH,
> Greg
> "Danijel Novak" <danijel.novak@.triera.net> wrote in message
> news:ugwNzDnGGHA.1288@.TK2MSFTNGP09.phx.gbl...
>|||Hi Danijel,
No, that's why myself and others have built tools to do this. Mine were at
www.whitebearconsulting.com. There is a free personal use license for MSDE
Manager there.
Tons of others can be found online, both free and paid. It will be less of
an issue now with SQL Server Express edition which I'd suggest you look
into.
HTH,
Greg
"Danijel Novak" <danijel.novak@.triera.net> wrote in message
news:%23j1h6ToGGHA.596@.TK2MSFTNGP10.phx.gbl...
> Hi Greg,
> 1. Is then any possibility to buy just EM license as buying SQL Server
> license and CALs is to expensive for using just MSDE.
> Thanks,
> --
> Danijel Novak
>
> "Greg Low [MVP]" <greglow@.lowell.com.au> wrote in message
> news:uB742BoGGHA.376@.TK2MSFTNGP12.phx.gbl...
>

Enterprise manager install...

How can I install Enterprise Manager on a work station? Where in the SQL
2000 serve CD is the setup for the Enterprise Manager?
TIA
Carlos San Miguel
Hi,
Start the setup program (SETUP.EXE), there you can select the Custom install
option and select the client tools only. In the list you can select
Enterprise manager and click ok and continue installation.
Thanks
Hari
MCDBA
"Carlos San Miguel" <yatuchabe@.hotmil.com> wrote in message
news:u1e2ZCDNEHA.3668@.TK2MSFTNGP11.phx.gbl...
> How can I install Enterprise Manager on a work station? Where in the SQL
> 2000 serve CD is the setup for the Enterprise Manager?
> TIA
> Carlos San Miguel
>

Enterprise manager install...

How can I install Enterprise Manager on a work station? Where in the SQL
2000 serve CD is the setup for the Enterprise Manager?
TIA
Carlos San MiguelHi,
Start the setup program (SETUP.EXE), there you can select the Custom install
option and select the client tools only. In the list you can select
Enterprise manager and click ok and continue installation.
Thanks
Hari
MCDBA
"Carlos San Miguel" <yatuchabe@.hotmil.com> wrote in message
news:u1e2ZCDNEHA.3668@.TK2MSFTNGP11.phx.gbl...
> How can I install Enterprise Manager on a work station? Where in the SQL
> 2000 serve CD is the setup for the Enterprise Manager?
> TIA
> Carlos San Miguel
>

Enterprise manager install...

How can I install Enterprise Manager on a work station? Where in the SQL
2000 serve CD is the setup for the Enterprise Manager?
TIA
Carlos San MiguelHi,
Start the setup program (SETUP.EXE), there you can select the Custom install
option and select the client tools only. In the list you can select
Enterprise manager and click ok and continue installation.
Thanks
Hari
MCDBA
"Carlos San Miguel" <yatuchabe@.hotmil.com> wrote in message
news:u1e2ZCDNEHA.3668@.TK2MSFTNGP11.phx.gbl...
> How can I install Enterprise Manager on a work station? Where in the SQL
> 2000 serve CD is the setup for the Enterprise Manager?
> TIA
> Carlos San Miguel
>

Enterprise Manager from desktop

Is there a way to install just the Enterprise Manager on my workstation so I
can access databases on our servers without having to install the whole SQL
Server 2000 program? Thanks.
David
Yes, install just the client tools. This can be done by only selecting the
"Client Tools Only" radio button on the "Installation Definition"
installation window.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"David" <dlchase@.lifetimeinc.com> wrote in message
news:ew0zW4hUEHA.3988@.tk2msftngp13.phx.gbl...
> Is there a way to install just the Enterprise Manager on my workstation so
I
> can access databases on our servers without having to install the whole
SQL
> Server 2000 program? Thanks.
> David
>

Enterprise Manager from desktop

Is there a way to install just the Enterprise Manager on my workstation so I
can access databases on our servers without having to install the whole SQL
Server 2000 program? Thanks.
DavidYes, install just the client tools. This can be done by only selecting the
"Client Tools Only" radio button on the "Installation Definition"
installation window.
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"David" <dlchase@.lifetimeinc.com> wrote in message
news:ew0zW4hUEHA.3988@.tk2msftngp13.phx.gbl...
> Is there a way to install just the Enterprise Manager on my workstation so
I
> can access databases on our servers without having to install the whole
SQL
> Server 2000 program? Thanks.
> David
>