MSDE and Enterprise Manager

If you have a machine running MSDE and you use Enterprise
Manager to connect to it, should you be able to set up
database maintenance plans that will delete expired
backups?
I'm seeing a situation where you can set up the
maintenance plan but the drop down box for the type of
period (days, weeks, etc) after which to delete expired
backups is blank.
My first thought is that there's an issue with using EM
to set up maintenance plans on MSDE.
Thanks for any assistance.
hi Charles,
"Charles Allen" <callen@.bkd.com> ha scritto nel messaggio
news:3d2c01c4c1ec$13e369d0$a301280a@.phx.gbl
> If you have a machine running MSDE and you use Enterprise
> Manager to connect to it, should you be able to set up
> database maintenance plans that will delete expired
> backups?
> I'm seeing a situation where you can set up the
> maintenance plan but the drop down box for the type of
> period (days, weeks, etc) after which to delete expired
> backups is blank.
> My first thought is that there's an issue with using EM
> to set up maintenance plans on MSDE.
> Thanks for any assistance.
unfortunately, your first thought should be that you are not licensed to use
Enterprise Manager against MSDE instances, and you should rely on self based
solutions or third party tools
(http://www.microsoft.com/sql/msde/partners/default.asp or
http://www.aspfaq.com/show.asp?id=2442 , google for others)
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thanks for your message. My understanding of the licensing is you can use
Enterprise Manager IF you own a copy of SQL Server Standard or greater. If my
understanding is correct, then the issue goes back to functionality. Do you
agree?
In case you are wondering, you might use MSDE even if you have an installed
version of SQL Server if the application you are using is based on one or the
other. Great Plains, for example, knows which one you are using and has
specific licenses.
"Andrea Montanari" wrote:

> hi Charles,
> "Charles Allen" <callen@.bkd.com> ha scritto nel messaggio
> news:3d2c01c4c1ec$13e369d0$a301280a@.phx.gbl
> unfortunately, your first thought should be that you are not licensed to use
> Enterprise Manager against MSDE instances, and you should rely on self based
> solutions or third party tools
> (http://www.microsoft.com/sql/msde/partners/default.asp or
> http://www.aspfaq.com/show.asp?id=2442 , google for others)
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||That's not quite correct. The Appropriate Uses of MSDE FAQ at
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp says the following:
Q. Can I use SQL Server tools and services in conjunction with MSDE?
A. You can only use SQL Server tools and services in conjunction with
MSDE if you acquired MSDE through SQL Server 2000 (Developer Edition,
Standard Edition, or Enterprise Edition), and if you are using MSDE in
conjunction with a properly licensed copy of SQL Server 2000. Visit the How
to Buy page for information on obtaining a valid SQL Server license.
Note: The tools and services included with SQL Server Developer
Edition may not be used to manage production server environments.
The following utilities are installed by the MSDE setup application
and are provided without restrictions for use with the copy of MSDE that is
installed by your application: bcp.exe, cnfgsvr.exe, dcomscm.exe, osql.exe,
sqlmaint.exe, sqlmangr.exe, scm.exe, sqladhlp.exe, and svrnetcn.exe. The
dtsrun.exe utility is also provided, but can only be used to run existing
Data Transformation Services (DTS) packages against the copy of MSDE
installed by your application; it cannot be used to develop new DTS
packages.
The key phrase here is "using MSDE in conjuntion with a properly licensed
copy of SQL Server 2000." Simply owning a copy of SQL Server Standard
Edition isn't enough, and you'll have to talk to your laywer to figure out
what that phrase means. All I've been told is that it doesn't apply in most
cases and requires a room full of lawyers and a white board to understand.
Rather than go through all that, you're probably better off putting Andrea's
suggestion to work and using a third-party tool.
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Charles Allen" <CharlesAllen@.discussions.microsoft.com> wrote in message
news:18142445-2FBB-43EC-9719-8751C5AC767D@.microsoft.com...[vbcol=seagreen]
> Thanks for your message. My understanding of the licensing is you can use
> Enterprise Manager IF you own a copy of SQL Server Standard or greater. If
> my
> understanding is correct, then the issue goes back to functionality. Do
> you
> agree?
> In case you are wondering, you might use MSDE even if you have an
> installed
> version of SQL Server if the application you are using is based on one or
> the
> other. Great Plains, for example, knows which one you are using and has
> specific licenses.
> "Andrea Montanari" wrote:
begin 666 ts.gif
J1TE&.#EA`0`!`( ``````/___R'Y! $`````+ `````!``$```(!1 `[
`
end

MSDE & Enterprise Manager

I seem to be having problems registering an MSDE instance with my Enterprise
Manager. I keep getting the 'access denied or server does not exist' error.
Is there something special that I need to do or some other version of
Enterprise Manager that I should be using?
thanks for all your help.
JD
Did you consider this article to set up the desired communication ?
http://www.codeproject.com/database/ConfigureMSDE.asp
HTH, jens Suessmeyer.
|||Jens,
Thank you much for this link. It looks very promising. A few years back,
I had some information on how to set this up but have since lost it.
Once again, Thanks,
Joe
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1129564389.827519.206390@.z14g2000cwz.googlegr oups.com...
> Did you consider this article to set up the desired communication ?
>
> http://www.codeproject.com/database/ConfigureMSDE.asp
>
> HTH, jens Suessmeyer.
>
|||Hello,
This is a general error and you can refer to the following article to
troubleshoot the issue:
Potential causes of the "SQL Server does not exist or access denied" error
message
http://support.microsoft.com/kb/328306/
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Sophie,
Thanks for the link. I'll check it out this morning.
Joe D
"Sophie Guo [MSFT]" <v-sguo@.online.microsoft.com> wrote in message
news:fI6TTq60FHA.3328@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> This is a general error and you can refer to the following article to
> troubleshoot the issue:
> Potential causes of the "SQL Server does not exist or access denied" error
> message
> http://support.microsoft.com/kb/328306/
> I hope the information is helpful.
> Sophie Guo
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> ================================================== ===
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
|||Hello,
You are welcome. If anyting is unclear, feel free to post back.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

MSDE & Enterprise Manager

I seem to be having problems registering an MSDE instance with my Enterprise
Manager. I keep getting the 'access denied or server does not exist' error.
Is there something special that I need to do or some other version of
Enterprise Manager that I should be using?
thanks for all your help.
JDDid you consider this article to set up the desired communication ?
http://www.codeproject.com/database/ConfigureMSDE.asp
HTH, jens Suessmeyer.|||Jens,
Thank you much for this link. It looks very promising. A few years back,
I had some information on how to set this up but have since lost it.
Once again, Thanks,
Joe
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1129564389.827519.206390@.z14g2000cwz.googlegroups.com...
> Did you consider this article to set up the desired communication ?
>
> http://www.codeproject.com/database/ConfigureMSDE.asp
>
> HTH, jens Suessmeyer.
>|||Hello,
This is a general error and you can refer to the following article to
troubleshoot the issue:
Potential causes of the "SQL Server does not exist or access denied" error
message
http://support.microsoft.com/kb/328306/
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Sophie,
Thanks for the link. I'll check it out this morning.
Joe D
"Sophie Guo [MSFT]" <v-sguo@.online.microsoft.com> wrote in message
news:fI6TTq60FHA.3328@.TK2MSFTNGXA01.phx.gbl...
> Hello,
> This is a general error and you can refer to the following article to
> troubleshoot the issue:
> Potential causes of the "SQL Server does not exist or access denied" error
> message
> http://support.microsoft.com/kb/328306/
> I hope the information is helpful.
> Sophie Guo
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> ========================================
=============
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hello,
You are welcome. If anyting is unclear, feel free to post back.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.