Monday, March 19, 2012

MSDE management

When I install msde on a W2K professional and go into My Computer/manage and
click on Services and Applications, it shows a MS Sql Server entry from which
I can manage msde. When I install on W2003 server, it's not there. Is this
by design ?
hi,
Dave Mc wrote:
> When I install msde on a W2K professional and go into My
> Computer/manage and click on Services and Applications, it shows a MS
> Sql Server entry from which I can manage msde. When I install on
> W2003 server, it's not there. Is this by design ?
Start -> Administrative Tools-> Services
Start -> Control Panel-> Administrative Tools-> Services
Start -> All Programs-> Administrative Tools-> Services
Start -> My Computer-> Change a setting-> Administrative Tools-> Services
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||I guess I didn't make it clear. The service is there on my W2003 server.
What's different is on my W2k pro, under My Computer/Manage/Services and
Applications, It shows Microsoft SQL Servers/MYLOCALSERVER/ then all the
"normal" Enterprise Manager items -- Databases, Maintenance Plans, etc. As
far as I know, MSDE is the only SQL ever installed on my workstation. When I
do an MSDE install on the server, though, the service is there and running
but I don't get the management tools as above. I was surprised when I saw
them on my workstation because I thought to manage msde, you were either
stuck with command line osql statements or third party "Enterprise Manager
like" management tools. So, I'm a little confused.
Thanks
"Andrea Montanari" wrote:

> hi,
> Dave Mc wrote:
> Start -> Administrative Tools-> Services
> Start -> Control Panel-> Administrative Tools-> Services
> Start -> All Programs-> Administrative Tools-> Services
> Start -> My Computer-> Change a setting-> Administrative Tools-> Services
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||hi Dave,
Dave Mc wrote:
> I guess I didn't make it clear. The service is there on my W2003
> server. What's different is on my W2k pro, under My
> Computer/Manage/Services and Applications, It shows Microsoft SQL
> Servers/MYLOCALSERVER/ then all the "normal" Enterprise Manager
> items -- Databases, Maintenance Plans, etc. As far as I know, MSDE
> is the only SQL ever installed on my workstation. When I do an MSDE
> install on the server, though, the service is there and running but
> I don't get the management tools as above. I was surprised when I
> saw them on my workstation because I thought to manage msde, you were
> either stuck with command line osql statements or third party
> "Enterprise Manager like" management tools. So, I'm a little
> confused.
> Thanks
MSDE comes with no management tool but oSql.exe, the command line tool, full
stop.
if you find them on your pc(s), they have been arbitrarily installed by the
SQL Server CD-Rom and no other way..

Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||You are right. I did some more checking and found that someone had been
doing development on this pc and installed sql 2000 from their msdn cd. Now,
my question is, am I violating a license agreement if I just install Client
Tools from a SQL cd even though I am only installing msde ?
Thanks
"Andrea Montanari" wrote:

> hi Dave,
> Dave Mc wrote:
> MSDE comes with no management tool but oSql.exe, the command line tool, full
> stop.
> if you find them on your pc(s), they have been arbitrarily installed by the
> SQL Server CD-Rom and no other way..
>
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||hi Dave,
Dave Mc wrote:
> You are right. I did some more checking and found that someone had
> been doing development on this pc and installed sql 2000 from their
> msdn cd. Now, my question is, am I violating a license agreement if
> I just install Client Tools from a SQL cd even though I am only
> installing msde ?
AFAIK, unfortunately YES...
in order to manage MSDE instance, you can only rely on self made tools or
third arty tools, but not on SQL Server Client Tools..
please have a look at this post, http://tinyurl.com/4u2zh , by a Microsoft
representative
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

No comments:

Post a Comment