MSDE Failed Install: enterprise

Showing posts with label enterprise. Show all posts

Friday, March 30, 2012

MSDE to SQL

When scaling a system's back end from MSDE to the enterprise version of SQL what types of issues or concerns would you watch for?
ThanksI am sure there are tons of white papers on this, but I dont suspect that
you'll experience any huge hurdles.
MSDE is essentially a throttled down version of the SQL Server Engine.
"Because it is fully compatible with other editions of SQL Server,
developers can easily target both SQL Server and MSDE 2000 with the same
core code base. This provides a seamless upgrade path from MSDE 2000 to SQL
Server if an application grows beyond the storage and scalability limits of
MSDE 2000."
http://www.microsoft.com/sql/msde/productinfo/overview.asp
Greg Jackson
PDX, Oregon|||i have a MS Windows 2003 Enterprise Edition but i don't have PDC installed so i don't have a domain in the LAN, i installed SQL Server 2000 on this server, but the clients ( MSDE 2000 ) can not se the SQL server.
My cuestion is , i have to install a pdc and then mount SQL server , and add the clients to the domain
"Jaxon" wrote:
> I am sure there are tons of white papers on this, but I dont suspect that
> you'll experience any huge hurdles.
> MSDE is essentially a throttled down version of the SQL Server Engine.
> "Because it is fully compatible with other editions of SQL Server,
> developers can easily target both SQL Server and MSDE 2000 with the same
> core code base. This provides a seamless upgrade path from MSDE 2000 to SQL
> Server if an application grows beyond the storage and scalability limits of
> MSDE 2000."
>
> http://www.microsoft.com/sql/msde/productinfo/overview.asp
>
>
> Greg Jackson
> PDX, Oregon
>
>|||MSDE doesn't have network access enabled by default. Enable using svrnetcn.exe.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Visual FoxPro programmer" <VisualFoxProprogrammer@.discussions.microsoft.com> wrote in message
news:927CFF5D-751E-4040-AF0D-B3896E64D68C@.microsoft.com...
> i have a MS Windows 2003 Enterprise Edition but i don't have PDC installed so i don't have a
domain in the LAN, i installed SQL Server 2000 on this server, but the clients ( MSDE 2000 ) can not
se the SQL server.
> My cuestion is , i have to install a pdc and then mount SQL server , and add the clients to the
domain
>
> "Jaxon" wrote:
> > I am sure there are tons of white papers on this, but I dont suspect that
> > you'll experience any huge hurdles.
> >
> > MSDE is essentially a throttled down version of the SQL Server Engine.
> >
> > "Because it is fully compatible with other editions of SQL Server,
> > developers can easily target both SQL Server and MSDE 2000 with the same
> > core code base. This provides a seamless upgrade path from MSDE 2000 to SQL
> > Server if an application grows beyond the storage and scalability limits of
> > MSDE 2000."
> >
> >
> > http://www.microsoft.com/sql/msde/productinfo/overview.asp
> >
> >
> >
> >
> > Greg Jackson
> > PDX, Oregon
> >
> >
> >|||Miles,
MSDE IS SQL Server... You should have no problems at all...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:5A4CD4C1-9923-436B-B711-C3F702A505DB@.microsoft.com...
> When scaling a system's back end from MSDE to the enterprise version of
SQL what types of issues or concerns would you watch for?
> Thanks

MSDE to MSDE replication with T-SQL/sp?

How can we replicate data in one MSDE to the other MSDE without having to
pay for MSSQL2000 full version to use the sql enterprise manager?
It seems that Enterprise Manager or SQL-DMO based programs rely on
system-provided stored procedures to do replication. So why not run sp thru
osql?
Is is possible for a t-sql expert to create such an sp? I searched
Internet and found few resources about msde to msde replication.
hi,
"news.microsoft.com" <martinc@.hume-travel.com> ha scritto nel messaggio
news:u40hNYVWEHA.4092@.TK2MSFTNGP11.phx.gbl...
> How can we replicate data in one MSDE to the other MSDE without having to
> pay for MSSQL2000 full version to use the sql enterprise manager?
> It seems that Enterprise Manager or SQL-DMO based programs rely on
> system-provided stored procedures to do replication. So why not run sp
thru
> osql?
> Is is possible for a t-sql expert to create such an sp? I searched
> Internet and found few resources about msde to msde replication.
>
yep... it's not very documented, but you can even use SQL-DMO replication
ActiveX controls
this is a great article,
http://www.winnetmag.com/Article/Art...079/39079.html , but only for
SQL Server Magazine subscribers...
http://www.compman.co.uk/cgi-win/browse.exe?ref=552118 has an entire
(little) chapter about replication and SQL-DMO... this is the best book
about SQL-DMO ever released...
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
|||With the developers edition of SQL Server you can setup replication between
test systems, then script out the the entire replication setup. The script
can then be used as a template for setting up future replications.
Jim
"news.microsoft.com" <martinc@.hume-travel.com> wrote in message
news:u40hNYVWEHA.4092@.TK2MSFTNGP11.phx.gbl...
> How can we replicate data in one MSDE to the other MSDE without having to
> pay for MSSQL2000 full version to use the sql enterprise manager?
> It seems that Enterprise Manager or SQL-DMO based programs rely on
> system-provided stored procedures to do replication. So why not run sp
thru
> osql?
> Is is possible for a t-sql expert to create such an sp? I searched
> Internet and found few resources about msde to msde replication.
>

Friday, March 23, 2012

MSDE prototyping

I haven't used MSDE yet. Does it run with an Enterprise Manager & Sql analyser interface?
I'm working on an asp.net vb project using sql2000. Users request me to create a protype for their review and training use. Can I deploy my project with only dlls forthe front end and an MSDE backend created from a script of the original Sql2000 database? Is there any potential discrepacy or problem with my prototyping plan? How can I copy my original database from sql2000 to msde?

Thanks for any help.Yes, Enterprise Manager and Query Analyzer can be interfaces to MSDE.

Yes, you can use MSDE as the back end for development but deploy to a SQL Server 2000 database.

When I mean "can" I mean "technically possible". I am not 100% sure of "legally possible". The licensing information for MSDE is fairly confusion, IMO.

The SQL Server 2000 Developer's edition is made specifically for situations like yours. It is $49.95 US and would give you the EM and QA tools plus the database. SeeDevelopment Edition Licensing.

I think the best way to transfer the data and schema would be to restore a backup.

Terri

MSDE pricing policy about CAL

hi
i have a right to use and deploy MSDE with my application
because i am a member of MSDN enterprise subscription..
but
1. i dont know should i buy CAL for client if my solution is server/client
architecture?
2. i dont know should i buy CAL for client if my solution is internet
architecture?
JINYou don't need CALs for use with MSDE, it's all free if you have an MSDN
subscription.
The downside of MSDE is ofcourse that the database size is limited (2GB max)
and the number of concurrent workloads as well, so not many users can
connect to it at the same time, which all makes it only usuable for small
scale applications:
For more info see:
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
Jacco Schalkwijk
SQL Server MVP
"ice" <yjwon@.geomania.com> wrote in message
news:blua3h$2a9$1@.news.hananet.net...
> hi
> i have a right to use and deploy MSDE with my application
> because i am a member of MSDN enterprise subscription..
> but
> 1. i dont know should i buy CAL for client if my solution is server/client
> architecture?
> 2. i dont know should i buy CAL for client if my solution is internet
> architecture?
> JIN
>
>|||You would only need CALs in this case, I believe, if you are going to use
SQL Server client tools (such as Enterprise Manager, Query Analyzer, etc) to
manage the database(s).
However, I am not a lawyer, and have not spent the last 8 years forensically
examining the EULA for MSDE. So don't consider this legal advice, only
practical and largely unsolicited. :-)
"ice" <yjwon@.geomania.com> wrote in message
news:blua3h$2a9$1@.news.hananet.net...
> hi
> i have a right to use and deploy MSDE with my application
> because i am a member of MSDN enterprise subscription..
> but
> 1. i dont know should i buy CAL for client if my solution is server/client
> architecture?
> 2. i dont know should i buy CAL for client if my solution is internet
> architecture?
> JIN
>
>|||Maybe it is time for microsoft.public.sqlserver.licensing? ;-)
Your answer made me think, and after some searching I now think that you
don't need CALs to use EM with MSDE, but you need a SQL Server production
license (Standard or Enterprise) to use EM, MSDN or Developer Edition won't
do. Alternatively, there are freeware tools available for use with MSDE,
search google for "MSDE tools".
--
Jacco Schalkwijk
SQL Server MVP
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:OA$n4xNjDHA.2560@.TK2MSFTNGP12.phx.gbl...
> You would only need CALs in this case, I believe, if you are going to use
> SQL Server client tools (such as Enterprise Manager, Query Analyzer, etc)
to
> manage the database(s).
> However, I am not a lawyer, and have not spent the last 8 years
forensically
> examining the EULA for MSDE. So don't consider this legal advice, only
> practical and largely unsolicited. :-)
>
>
> "ice" <yjwon@.geomania.com> wrote in message
> news:blua3h$2a9$1@.news.hananet.net...
> > hi
> >
> > i have a right to use and deploy MSDE with my application
> > because i am a member of MSDN enterprise subscription..
> >
> > but
> >
> > 1. i dont know should i buy CAL for client if my solution is
server/client
> > architecture?
> >
> > 2. i dont know should i buy CAL for client if my solution is internet
> > architecture?
> >
> > JIN
> >
> >
> >
> >
>|||> Maybe it is time for microsoft.public.sqlserver.licensing? ;-)
I agree. MS legal should be responsible for fielding questions about
licensing, because none of us can ever seem to get it straight.
> Your answer made me think, and after some searching I now think that you
> don't need CALs to use EM with MSDE, but you need a SQL Server production
> license (Standard or Enterprise) to use EM,
That might be true. I assume, though, that if you have a SQL Server
production license and are using EM against it, you either need a CAL to do
so (and in turn to use it against MSDE as well), or else you have paid for
processor license(s) (in which case you've spent enough money that, ideally,
they shouldn't hassle you for MSDE :-))))).
Again, not legal advice, of course.
> Alternatively, there are freeware tools available for use with MSDE,
> search google for "MSDE tools".
I also maintain a list: http://www.aspfaq.com/2442|||Also, this verbage is interesting, from
http://www.microsoft.com/sql/howtobuy/faq.asp :
Q. What type of license do I need if SQL Server Personal Edition or
Microsoft SQL Server Desktop Engine (MSDE) accesses SQL Server?
A. It depends on which licensing model you have for SQL Server. Here are the
guidelines:
- Processor license. You can install SQL Server Personal Edition and
MSDE on any number of devices for use with SQL Server.
- Server plus device CAL. You must have a CAL for each device on which
SQL Server Personal Edition or MSDE is installed.
- Server plus user CAL. You must have a CAL for each user accessing SQL
Server Personal Edition or MSDE.
I don't even think the web site has it right... they're lumping PE and MSDE
together, when they are clearly different beasts.

Monday, March 19, 2012

msde manager

I have installed msde on W2K pro and I am looking for an msde manager, something similar to sql enterprise manager. Does anyone have any suggestions?There are several tools you can use to administer MSDE:

ASP.NET Enterprise Manager, an open source SQL Server and MSDE management tool.

ASP.NET WebMatrix (which includes a database management tool) from this web site (click on the Web Matrix tab at the top of this page).

Microsoft's Web Data Administrator is a free web-based MSDE management program written using C# and ASP.NET, and includes source code.

You can also access MSDE using Access.

Don|||Thanks for the info donkiely! Just what I needed|||The Microsoft's Web Data Administrator MSDE Manager has moved it's URL. you get a redirect at the link provided by donkiely. however, in case that link redirect gets taken away the new URL is: http://msdn.microsoft.com/library/default.asp?url=/downloads/list/aspnet.asp

Farewell,
Quilnux|||Got it! Thank You!

Friday, March 9, 2012

MSDE instance registration in Enterprise Manager

Hi All,
I'm trying to register an instance of MSDE on a remote machine using EM on my desktop. The remote machine has 2
named instances of MSDE running. I am able to register 1 instance with no problems. I had to register it using
"RemoteServer1\InstanceName" rather than just the remote machines name.
For the life of me I can not get the other instance to register. I get the "SQL Server does not exist or access
denied" error. I've tried just registering the 2nd instance without the first with the same results. I can see
no difference in the way either of the 2 instances were set up or in their properties. I am a machine admin on
the remote machine and am connecting using Windows Auth.
What am I missing and how can I register that 2nd instance?
Thank you.
gdr
Gary D. Rezek
University Networking Systems and Services
South Dakota State University
hi Gary,
Gary D. Rezek wrote:
> Hi All,
> I'm trying to register an instance of MSDE on a remote machine using
> EM on my desktop. The remote machine has 2 named instances of MSDE
> running. I am able to register 1 instance with no problems. I had to
> register it using "RemoteServer1\InstanceName" rather than just the
> remote machines name.
this is normal as a named instance full qualified name is
ComputerName\InstanceName...

> For the life of me I can not get the other instance to register. I
> get the "SQL Server does not exist or access denied" error. I've
> tried just registering the 2nd instance without the first with the
> same results. I can see no difference in the way either of the 2
> instances were set up or in their properties. I am a machine admin on
> the remote machine and am connecting using Windows Auth. What am I
> missing and how can I register that 2nd instance?
at least 1 difference must be present... the name... MSDE/SQL Server 2000
can be installed as a default instance or a named instance... but only a
default instance can be present, wit up to other 15 named instances per
computer...
as you already saw, a default instance is available as ComputerName, where a
named instance will be as ComputerName\InstanceName...
you can inspect your (remote) services for MSSQLSERVER and
MSSQL$InstanceName to see what is going on...
MSDE installs by default disabling network protocols, thus not allowing
remote connections... please verify using the Server Network Utiliy
(svrnetcn.exe) that the "failing" instance has enabled network protocols...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea,
Thanks for your answer. It eventually led me to http://tinyurl.com/8q95s this post. In that post I found this
quote...
"You need to look for a line in the error log which states:
"SQL server listening on TCP, Shared Memory, Named Pipes.
"If you only have Shared Memory on this list, then only local connections are allowed."
In the instance I have been trying to connect, Shared Memory is the only thing listed in the errorlog, so no
TCP/IP or Named Pipes. I asked the individual who is responsible for the application which created this instance
of MSDE (and also the one who asked me WHY can't he connect through EM), I learned that this is the way it
should be. :^/ I've worked with MSDE very, very little, but I still should have looked at the ErrorLog to
begin with.
Thank you very much for your help
gdr
Gary D. Rezek
University Networking Systems and Services
South Dakota State University
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message news:3jg2rjFpnmhnU1@.individual.net...
> hi Gary,
> Gary D. Rezek wrote:
> this is normal as a named instance full qualified name is ComputerName\InstanceName...
>
> at least 1 difference must be present... the name... MSDE/SQL Server 2000 can be installed as a default
> instance or a named instance... but only a default instance can be present, wit up to other 15 named instances
> per computer...
> as you already saw, a default instance is available as ComputerName, where a named instance will be as
> ComputerName\InstanceName...
> you can inspect your (remote) services for MSSQLSERVER and MSSQL$InstanceName to see what is going on...
> MSDE installs by default disabling network protocols, thus not allowing remote connections... please verify
> using the Server Network Utiliy (svrnetcn.exe) that the "failing" instance has enabled network protocols...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual interface)
> -- remove DMO to reply
>
|||h Gary,
Gary D. Rezek wrote:
> Hi Andrea,
> Thanks for your answer. It eventually led me to
> http://tinyurl.com/8q95s this post. In that post I found this quote...
> "You need to look for a line in the error log which states:
> "SQL server listening on TCP, Shared Memory, Named Pipes.
> "If you only have Shared Memory on this list, then only local
> connections are allowed."
you always have to verify (on the server using Server Network Utility
[svrnetcn.exe] and on the client using Client Network Utility
[cliconfg.exe]) that a common network protocol is available for the client
and the server to dialog...

> In the instance I have been trying to connect, Shared Memory is the
> only thing listed in the errorlog, so no TCP/IP or Named Pipes. I
> asked the individual who is responsible for the application which
> created this instance of MSDE (and also the one who asked me WHY
> can't he connect through EM), I learned that this is the way it
> should be. :^/
if Shared Memory is the only protocol that "must" be enabled, then no remote
connections will be available... but it can be ok in local scenarios

..
MSDE will then actually be used as a local desktop database..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

MSDE instance being broadcast

I work in a domain environment with a couple of Enterprise Edition SQL
Servers. Using SSMS, when I go to register a new installation and I 'Browse
for more' in the dialog box, I see a whole bunch of workstations that I know
are set up with MSDE.
How do I keep these machines from broadcasting their presence to the domain?
All these MSDE installs are strictly for local machine use only and none of
them should allow external connections. The fact that they are broadcasting
their presence (they don't have SQL Browser because they are only MSDE) I see
as a security risk. How can I stop this?
Any suggestions.
Thanks
Todd Chittenden
Yes, it is a security risk. It's been some time since I worked with MSDE,
but I would investigate disabling the ports and protocols--much as the
surface area configuration tool does for SQL Express 2005. This can be done
if the applications are coded to use the shared memory provider (and bypass
the network) and are not (in fact) shared on the net.
hth
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Todd C" <ToddC@.discussions.microsoft.com> wrote in message
news:E302F2D1-165D-4DDB-BCA4-9BA587CBB237@.microsoft.com...
>I work in a domain environment with a couple of Enterprise Edition SQL
> Servers. Using SSMS, when I go to register a new installation and I
> 'Browse
> for more' in the dialog box, I see a whole bunch of workstations that I
> know
> are set up with MSDE.
> How do I keep these machines from broadcasting their presence to the
> domain?
> All these MSDE installs are strictly for local machine use only and none
> of
> them should allow external connections. The fact that they are
> broadcasting
> their presence (they don't have SQL Browser because they are only MSDE) I
> see
> as a security risk. How can I stop this?
> Any suggestions.
> Thanks
> --
> Todd Chittenden
>
|||Bill:
That's all well and good, but HOW do I go about configuring an instance of
MSDE when there is no user interface installed because it came packaged as
part of some 3rd party app?
Thanks
Todd Chittenden
"William (Bill) Vaughn" wrote:

> Yes, it is a security risk. It's been some time since I worked with MSDE,
> but I would investigate disabling the ports and protocols--much as the
> surface area configuration tool does for SQL Express 2005. This can be done
> if the applications are coded to use the shared memory provider (and bypass
> the network) and are not (in fact) shared on the net.
> hth
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> ------
> "Todd C" <ToddC@.discussions.microsoft.com> wrote in message
> news:E302F2D1-165D-4DDB-BCA4-9BA587CBB237@.microsoft.com...
>
>
|||Again, it's been some time since I worked with MSDE and no, I know it does
not come with configuration tools. I expect you're going to have to visit
each system and run a reconfig script or use SQL Server Management studio
(not as easy). I found a site that seems to address some of these issues.
http://www.codeproject.com/database/ConfigureMSDE.asp#7. I hope it helps.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Todd C" <ToddC@.discussions.microsoft.com> wrote in message
news:2DF6889A-A64A-483F-BE42-766155FC8AF7@.microsoft.com...[vbcol=seagreen]
> Bill:
> That's all well and good, but HOW do I go about configuring an instance of
> MSDE when there is no user interface installed because it came packaged as
> part of some 3rd party app?
> Thanks
> --
> Todd Chittenden
> "William (Bill) Vaughn" wrote:
|||Bill:
Thanks.
Good stuff!
Todd

MSDE instance being broadcast

I work in a domain environment with a couple of Enterprise Edition SQL
Servers. Using SSMS, when I go to register a new installation and I 'Browse
for more' in the dialog box, I see a whole bunch of workstations that I know
are set up with MSDE.
How do I keep these machines from broadcasting their presence to the domain?
All these MSDE installs are strictly for local machine use only and none of
them should allow external connections. The fact that they are broadcasting
their presence (they don't have SQL Browser because they are only MSDE) I se
e
as a security risk. How can I stop this?
Any suggestions.
Thanks
--
Todd ChittendenYes, it is a security risk. It's been some time since I worked with MSDE,
but I would investigate disabling the ports and protocols--much as the
surface area configuration tool does for SQL Express 2005. This can be done
if the applications are coded to use the shared memory provider (and bypass
the network) and are not (in fact) shared on the net.
hth
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"Todd C" <ToddC@.discussions.microsoft.com> wrote in message
news:E302F2D1-165D-4DDB-BCA4-9BA587CBB237@.microsoft.com...
>I work in a domain environment with a couple of Enterprise Edition SQL
> Servers. Using SSMS, when I go to register a new installation and I
> 'Browse
> for more' in the dialog box, I see a whole bunch of workstations that I
> know
> are set up with MSDE.
> How do I keep these machines from broadcasting their presence to the
> domain?
> All these MSDE installs are strictly for local machine use only and none
> of
> them should allow external connections. The fact that they are
> broadcasting
> their presence (they don't have SQL Browser because they are only MSDE) I
> see
> as a security risk. How can I stop this?
> Any suggestions.
> Thanks
> --
> Todd Chittenden
>|||Bill:
That's all well and good, but HOW do I go about configuring an instance of
MSDE when there is no user interface installed because it came packaged as
part of some 3rd party app?
Thanks
--
Todd Chittenden
"William (Bill) Vaughn" wrote:

> Yes, it is a security risk. It's been some time since I worked with MSDE,
> but I would investigate disabling the ports and protocols--much as the
> surface area configuration tool does for SQL Express 2005. This can be don
e
> if the applications are coded to use the shared memory provider (and bypas
s
> the network) and are not (in fact) shared on the net.
> hth
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant
> Microsoft MVP
> INETA Speaker
> www.betav.com/blog/billva
> www.betav.com
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> ----
---
> "Todd C" <ToddC@.discussions.microsoft.com> wrote in message
> news:E302F2D1-165D-4DDB-BCA4-9BA587CBB237@.microsoft.com...
>
>|||Again, it's been some time since I worked with MSDE and no, I know it does
not come with configuration tools. I expect you're going to have to visit
each system and run a reconfig script or use SQL Server Management studio
(not as easy). I found a site that seems to address some of these issues.
http://www.codeproject.com/database...gureMSDE.asp#7. I hope it helps.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"Todd C" <ToddC@.discussions.microsoft.com> wrote in message
news:2DF6889A-A64A-483F-BE42-766155FC8AF7@.microsoft.com...[vbcol=seagreen]
> Bill:
> That's all well and good, but HOW do I go about configuring an instance of
> MSDE when there is no user interface installed because it came packaged as
> part of some 3rd party app?
> Thanks
> --
> Todd Chittenden
> "William (Bill) Vaughn" wrote:
>|||Bill:
Thanks.
Good stuff!
Todd

MSDE installation messes up Query Analayzer and Enterprise Manager

Does anyone out there know how to fix the problem with the SQL tools and MSDE?
I have found that if you install MSDE after installing SQL Server's Tools
the tools don't work anymore. Any help or suggestions here would be
appreciated.
Try reapplying latest service pack.
"jdehne" <jdehne@.discussions.microsoft.com> wrote in message
news:8E64752E-84F1-462D-A614-2E6CCF943300@.microsoft.com...
> Does anyone out there know how to fix the problem with the SQL tools and
> MSDE?
> I have found that if you install MSDE after installing SQL Server's Tools
> the tools don't work anymore. Any help or suggestions here would be
> appreciated.

Saturday, February 25, 2012

MSDE Install

I'm running Server 2003 Standard Edition... I'm having
problems installing MSDE (light).
Is it mandatory to run Server 2003 Enterprise Edition in
order to install MSDE?
Thanks!
CJ
It is not necessary to have a previous installation of any edition of SQL
Server for installing MSDE. Please go through the following Microsoft
Articles for more information and how to custom install MSDE.
Software and Hardware requirements for various editions of SQL Server 2000
http://msdn.microsoft.com/library/de...us/instsql/in_
overview_74vn.asp
http://msdn.microsoft.com/library/de...us/architec/8_
ar_ts_7eur.asp
MSDE Installation
http://msdn.microsoft.com/library/de...us/distsql/dis
tsql_3usf.asp
http://msdn.microsoft.com/library/de...us/distsql/dis
tsql_84xl.asp
Thanks
Soma Sekhara Reddy

MSDE in Enterprise manager: strange number with managed tasks...

Without having read the manual (just assuming it should work), I have a
problem with MSDE and using the Enterprise Manager to create a database
maintenance plan.
I have a desktop machine with SQL2K(sp3) and a portable with MSDE
(msderela.exe). I am testing (developing) an application that should
bee able to pull a subscription-db (portable in this case) from the
main-server (desktop in this case). I've setup all directories needed
(repldata) and the installation-log for MSDE (installed with /L*v)
didn't gave me any error... I've attached a DB (for testing purposes)
and (using the Enterprise manager) it seems to return everything I want
it to return (data that is).
But, when I was trying to setup a maintenance plan on the laptop (so
that user has a backup in case he's traveling and would like to revert
to a backup-file), I run into some very strange errors. Although I can
create a plan (either using the wizard or 'plain'), certain values are,
well, let's say damaged...
For example, the "complete backup" tab. On the right side of the
checkbox "Remove files older then" you have a combo with 'days',
'weeks', etc. For some reason, this combo is empty.
Having skipped this functionality completely, I've setup a complete
plan and saved it. Backup every 1 days at 18:00 (there's more, but for
the example's sake I don't include all settings).
Now, when I open that plan again, I see that the every 1 days is
changed to 366 days (not only for this one, but for all where I've set
it to every 1 day). I can't save the plan anymore (errors complaining
about having the wrong value-types). When I change it back to 1 day,
save it and re-open it, it comes back with the 366 days again...
Any ideas on what's going on here?
Thx,
GB
Dit is een automatische handtekening van MesNews.
Site : http://www.mesnews.net
Are you sure you're properly licensed to manage MSDE with Enterprise
Manager?
http://www.aspfaq.com/
(Reverse address to reply.)
"Gijs Beukenoot" <gijs.beukenoot@.wanadoo.nl> wrote in message
news:mn.8c937d4b9fda54cf.22563@.wanadoo.nl...
> Without having read the manual (just assuming it should work), I have a
> problem with MSDE and using the Enterprise Manager to create a database
> maintenance plan.
> I have a desktop machine with SQL2K(sp3) and a portable with MSDE
> (msderela.exe). I am testing (developing) an application that should
> bee able to pull a subscription-db (portable in this case) from the
> main-server (desktop in this case). I've setup all directories needed
> (repldata) and the installation-log for MSDE (installed with /L*v)
> didn't gave me any error... I've attached a DB (for testing purposes)
> and (using the Enterprise manager) it seems to return everything I want
> it to return (data that is).
> But, when I was trying to setup a maintenance plan on the laptop (so
> that user has a backup in case he's traveling and would like to revert
> to a backup-file), I run into some very strange errors. Although I can
> create a plan (either using the wizard or 'plain'), certain values are,
> well, let's say damaged...
> For example, the "complete backup" tab. On the right side of the
> checkbox "Remove files older then" you have a combo with 'days',
> 'weeks', etc. For some reason, this combo is empty.
> Having skipped this functionality completely, I've setup a complete
> plan and saved it. Backup every 1 days at 18:00 (there's more, but for
> the example's sake I don't include all settings).
> Now, when I open that plan again, I see that the every 1 days is
> changed to 366 days (not only for this one, but for all where I've set
> it to every 1 day). I can't save the plan anymore (errors complaining
> about having the wrong value-types). When I change it back to 1 day,
> save it and re-open it, it comes back with the 366 days again...
> Any ideas on what's going on here?
> Thx,
> GB
> --
> Dit is een automatische handtekening van MesNews.
> Site : http://www.mesnews.net
>
|||Aaron [SQL Server MVP] drukte met precisie uit :
> Are you sure you're properly licensed to manage MSDE with Enterprise
> Manager?
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
I fail to see what the licensing has to do with this problem...
But anyway, I have at least three developer licenses (7 and 2x2K); two
standard licenses (7 and 2K) and one Enterprise license (2K) (all
processor); I also have one dev lic with with Office-xp-dev and I have
an MSDN universal... But from memory (I used to have @.microsoft.com
behind my (not-mentioned-here-due-to-spam)-address although that is a
few years ago), having just one valid SQL license is enough to do what
I want to do.
Dit is een automatische handtekening van MesNews.
Site : http://www.mesnews.net
|||> I fail to see what the licensing has to do with this problem...
Maybe trying to push you to create jobs legally using the stored procedures
in MSDB, instead of Enterprise Manager, which (a) you are having problems
with, and (b) is not likely abiding by licensing agreements.

> But anyway, I have at least three developer licenses (7 and 2x2K); two
> standard licenses (7 and 2K) and one Enterprise license (2K) (all
> processor); I also have one dev lic with with Office-xp-dev and I have
> an MSDN universal... But from memory (I used to have @.microsoft.com
> behind my (not-mentioned-here-due-to-spam)-address although that is a
> few years ago), having just one valid SQL license is enough to do what
> I want to do.
I would consult with a Microsoft licensing rep before having confidence in
such a statement. MSDE has very strict limitations on how you can use SQL
Server tools for management, regardless of how many licenses you have for
other editions. And there are very few cases that I've heard of where it's
legal to manage MSDE with Enterprise Manager, sorry.
|||Aaron [SQL Server MVP] drukte met precisie uit :

> I would consult with a Microsoft licensing rep before having confidence in
> such a statement. MSDE has very strict limitations on how you can use SQL
> Server tools for management, regardless of how many licenses you have for
> other editions. And there are very few cases that I've heard of where it's
> legal to manage MSDE with Enterprise Manager, sorry.
Aaron,
Can I point you to the website?
http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp
To be precise :
<cut>
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.
<paste>
And this is exactly what I'm doing...
Sent me a private message if you're still think I am doing something
wrong.
Dit is een automatische handtekening van MesNews.
Site : http://www.mesnews.net
|||> And this is exactly what I'm doing...
I thought the same thing too, but apparently there's much more to it than
that single paragraph, and relying on that paragraph has proved detrimental
in the past.

> Sent me a private message if you're still think I am doing something
> wrong.
Not really my job to prove to you that you are doing something wrong; you
might not be, I don't know because I am neither a lawyer nor a Microsoft
licensing rep. Just reminding you that the onus is on YOU to be sure YOU
are abiding by the licensing agreement(s).
|||Aaron [SQL Server MVP] gebruikte zijn klavier om te schrijven :
> I thought the same thing too, but apparently there's much more to it than
> that single paragraph, and relying on that paragraph has proved detrimental
> in the past.
>
> Not really my job to prove to you that you are doing something wrong; you
> might not be, I don't know because I am neither a lawyer nor a Microsoft
> licensing rep. Just reminding you that the onus is on YOU to be sure YOU
> are abiding by the licensing agreement(s).
Good. Can we go back to the original question then?
Anybody any ideas why the before mentioned method is giving me these
strange numbers?
Dit is een automatische handtekening van MesNews.
Site : http://www.mesnews.net

Monday, February 20, 2012

msde graphic tool

Hi
Is there a graphic tool I can use with msde?
Is it possible to use the enterprise manager?
Thanks,
Cindy
Cindy,
You can certainly use Enterprise Manager running on a different machine
where full SQL server is installed.
If you don't have that try WinSQL at http://www.synametrics.com/winsql.
WinSQL is not a replacement for Enterprise Manager but for Query Analyzer.
Regards,
Dennis
CindyH wrote:
> Hi
> Is there a graphic tool I can use with msde?
> Is it possible to use the enterprise manager?
> Thanks,
> Cindy
>
|||hi Cindy
CindyH wrote:
> Hi
> Is there a graphic tool I can use with msde?
> Is it possible to use the enterprise manager?
please have a look at http://www.microsoft.com/sql/msde/partners and/or
http://www.aspfaq.com/show.asp?id=2442 for a list of commercial and free
tools...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Cindy,
You can certainly use Enterprise Manager running on a different machine
where full SQL server is installed.
If you don't have that try WinSQL at http://www.synametrics.com/winsql.
WinSQL is not a replacement for Enterprise Manager but for Query Analyzer.
Regards,
Dennis
CindyH wrote:
> Hi
> Is there a graphic tool I can use with msde?
> Is it possible to use the enterprise manager?
> Thanks,
> Cindy
>
|||Hi Cindy,
There is a list on the Microsoft Website of third party tools
(www.microsoft.com/sql/msde)
I personally use Vale Software's MSDE Manager (www.valesoftware.com)... it
does all I need.
Regards,
Dave.
"CindyH" <none@.none.com> wrote in message
news:uEjyr%23oqFHA.3920@.TK2MSFTNGP09.phx.gbl...
> Hi
> Is there a graphic tool I can use with msde?
> Is it possible to use the enterprise manager?
> Thanks,
> Cindy
>
|||test this
www.apexsql.com
good tools for sql
"CindyH" <none@.none.com> wrote in message
news:uEjyr%23oqFHA.3920@.TK2MSFTNGP09.phx.gbl...
> Hi
> Is there a graphic tool I can use with msde?
> Is it possible to use the enterprise manager?
> Thanks,
> Cindy
>

MSDE EnterPrise manager

I am using MSDE enterprise manager and when I downloaded it, I cannot log onto the SQL Server, which is on my computer, I used the server name defined in the SQL Server Service manager, and it cannot connect. I was trying to set the conection up with the ODBC manager, although I am not even sure if this is the right way. Someone please help me out.Depends on how you installed it. If it's in native Windows authentication mode, you'll need to ask it to connect as the current logged on user. If you've enabled mixed authentication, you can connect using the current user or using a SQL Server user (sa is the "administrator" of SQL Server which you'll have specified a password for during the installation if you enabled mixed auth).

Best way to test the connectivity is by using the SqlConnection class and try to connect that way. The errors you get on invoking the "Open" method will explain what's wrong.

Check out my other post on managing MSDE as well onthis forum. This can be seen as a kind of replacement for the Enterprise Manager of SQL Server.

Friday, March 30, 2012

MSDE to SQL

MSDE to SQL

MSDE to SQL

MSDE to MSDE replication with T-SQL/sp?

Friday, March 23, 2012

MSDE prototyping

MSDE pricing policy about CAL

Monday, March 19, 2012

msde manager

Friday, March 9, 2012

MSDE instance registration in Enterprise Manager

MSDE instance being broadcast

MSDE instance being broadcast

MSDE installation messes up Query Analayzer and Enterprise Manager

Saturday, February 25, 2012

MSDE Install

MSDE in Enterprise manager: strange number with managed tasks...

Monday, February 20, 2012

msde graphic tool

MSDE EnterPrise manager

MSDE Failed Install

Blog Archive

About Me