Enterprise Manager won't Start

Why would SQL Enterprise Manager fail to start, and yet
all other applications in the SQL Server program group
start run ok? This is the error message greeting us you
when we click on Enterprise Manager - 'SQLDMO has not
been registered, please re-run SQL Server setup and
contact your system administrator'.
Well, reinstallation didn't help. Users whose
applications are backended by an SQL database are running
ok. I am suspecting a application for remote application
control called Royal TS. Terminal Services are installed
on this server but I doubt this could be the reason, or
could it?
Thanks in advanceThis error normally can be rectified by registering SQLDMO using "regsvr32".
Not sure if your remote server application may be the problem.
--
HTH,
SriSamp
Please reply to the whole group only!
http://www32.brinkster.com/srisamp
"T" <anonymous@.discussions.microsoft.com> wrote in message
news:0a6001c3af5d$b91200d0$a401280a@.phx.gbl...
> Why would SQL Enterprise Manager fail to start, and yet
> all other applications in the SQL Server program group
> start run ok? This is the error message greeting us you
> when we click on Enterprise Manager - 'SQLDMO has not
> been registered, please re-run SQL Server setup and
> contact your system administrator'.
> Well, reinstallation didn't help. Users whose
> applications are backended by an SQL database are running
> ok. I am suspecting a application for remote application
> control called Royal TS. Terminal Services are installed
> on this server but I doubt this could be the reason, or
> could it?
> Thanks in advance

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