Showing posts with label management. Show all posts
Showing posts with label management. Show all posts

Monday, March 19, 2012

MSDE Management Tools

Hi all
Has anyone used the MSDE Manager Program from Vale Software? I am chasing
any reviews, thoughts and praise/criticism of the software. I have the
trial version and it appears to be ok, just wondering if there are any known
bugs etc.
Also, are there many other SQL Server/MSDE management tools (similar to
Enterprise Manager) on the market. I am developing some off the shelf
software and was hoping to make use of MSDE to lower costs (current software
version implemented in Access but looking for a client/server
implementation). Unfortunately due to the nature of our clients we need
something nice to manage the database/s, specifically a tool that includes
the maintenance plan wizard/feature of Enterprise Manager.> Also, are there many other SQL Server/MSDE management tools (similar to
> Enterprise Manager) on the market.
http://www.aspfaq.com/2442

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

MSDE Maintanence Problem

I am trying to create a maintanence plan for a MSDE database using
Enterprise Manager. Under my MSDE SQL Server/Management, Database
Maintenance Plans icon does not show up. In my three other SQL Servers (1
MSDE, 2 SQL 2000) this icon does show up. And I cannot right click the
database and choose Maintenance Plans under all tasks. I am doing this via
an Enterprise Manage remotely. When I physically view the Enterprise
Manager I can setup Maintenance Plans however the plans do not work. When I
view the properties, none of the schedule shwos up and I get an error. Is
my only choice to reinstall MSDE and Enterprise Manager? Any ideas?
Thanks
hi George,
"George" <george@.noemail.com> ha scritto nel messaggio
news:OOmpQ51bEHA.2840@.TK2MSFTNGP11.phx.gbl...
> I am trying to create a maintanence plan for a MSDE database using
> Enterprise Manager. Under my MSDE SQL Server/Management, Database
> Maintenance Plans icon does not show up. In my three other SQL Servers (1
> MSDE, 2 SQL 2000) this icon does show up. And I cannot right click the
> database and choose Maintenance Plans under all tasks. I am doing this via
> an Enterprise Manage remotely. When I physically view the Enterprise
> Manager I can setup Maintenance Plans however the plans do not work. When
I
> view the properties, none of the schedule shwos up and I get an error. Is
> my only choice to reinstall MSDE and Enterprise Manager? Any ideas?
> Thanks
>
that's weird... never heard about :-(
but, FWIW, you are not allowed to manage MSDE instance with the regular SQL
Server client tools like Enterprise Manager and/or Query Analyzer...
you shoul'd resort on third party tools..
a list of some tools can be found at
http://www.microsoft.com/sql/msde/partners/default.asp and/or
http://www.aspfaq.com/show.asp?id=2442
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Why can't I use Enterprise Manager to manage a MSDE Instance? I do have
licenses for SQL Server.
Thanks
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2m81boFjj6hjU1@.uni-berlin.de...[vbcol=seagreen]
> hi George,
> "George" <george@.noemail.com> ha scritto nel messaggio
> news:OOmpQ51bEHA.2840@.TK2MSFTNGP11.phx.gbl...
(1[vbcol=seagreen]
via[vbcol=seagreen]
When[vbcol=seagreen]
> I
Is
> that's weird... never heard about :-(
> but, FWIW, you are not allowed to manage MSDE instance with the regular
SQL
> Server client tools like Enterprise Manager and/or Query Analyzer...
> you shoul'd resort on third party tools..
> a list of some tools can be found at
> http://www.microsoft.com/sql/msde/partners/default.asp and/or
> http://www.aspfaq.com/show.asp?id=2442
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi George,
"George" <george@.noemail.com> ha scritto nel messaggio
news:Od%23dg7$bEHA.384@.TK2MSFTNGP10.phx.gbl...
> Why can't I use Enterprise Manager to manage a MSDE Instance? I do have
> licenses for SQL Server.
there's an open thread about it in Microsoft it self =;-D
a little extract of such a "flame" is a position by a Microsoft
representative like
"...
The tricky part here is the bit about using MSDE in conjunction with a
properly licensed copy of SQL Server 2000 and the fact that we don't go
into detail about exactly what that means. XXXX (name) has stated many times
in
the private SQL MVP newsgroup that that requires a bunch of lawyers and
a white board. It's almost never the case. In my opinion, we simply need
to tell folks that right now you cannot do it with MS tools at them
moment, here's a bunch of 3rd-party tools you can look at, and we'll be
providing tools with SQL Express and here's how you get a sneak preview
of that...
..."
dev/test environments can be managed with SQL Server Dev edition at will, as
test requires MSDE management too, but production enviroments seem not to be
legitimated...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply