Can MSDE 2000A still be used to distribute in an application for sale?
Regards,
jz
Yes. You need to have a license though (see
http://www.microsoft.com/sql/msde/ho...msderights.asp) or you can
register:
http://www.microsoft.com/sql/msde/ho...stregister.asp
Jacco Schalkwijk
SQL Server MVP
"Jeff" <joedirt@.datahook.com> wrote in message
news:eU501BVaEHA.1840@.TK2MSFTNGP11.phx.gbl...
> Can MSDE 2000A still be used to distribute in an application for sale?
> Regards,
> jz
>
Showing posts with label distribute. Show all posts
Showing posts with label distribute. Show all posts
Monday, March 26, 2012
MSDE 2000 named instance with my application
I am writing an application and wish to distribute MSDE with it.
I was considering using a batch file to do the install using the line
setup INSTANCENAME="InstanceName" SAPWD="AStrongSAPwd"
However, the next step would be to call osql to either script the schema or
sp_attach_db the database. Well this raises the issue of once installed
with a named instance how do I do osql -E -S MACHINENAME\InstanceName
without knowing it ahead of time? Is there perhaps 1. an easier way or 2. a
different syntax to achieving it? I am pretty sure I will run into more
grief when attempting to set up the ODBC connections also.
Maybe I'd just be better off rewriting this to use an Access database
instead
hi Bradley,
"Bradley M. Small" <BSmall@.XNOSPAMXmjsi.com> ha scritto nel messaggio
news:ejW7scifEHA.1424@.tk2msftngp13.phx.gbl...
> I am writing an application and wish to distribute MSDE with it.
> I was considering using a batch file to do the install using the line
> setup INSTANCENAME="InstanceName" SAPWD="AStrongSAPwd"
> However, the next step would be to call osql to either script the schema
or
> sp_attach_db the database. Well this raises the issue of once installed
> with a named instance how do I do osql -E -S MACHINENAME\InstanceName
> without knowing it ahead of time? Is there perhaps 1. an easier way or 2.
a
> different syntax to achieving it? I am pretty sure I will run into more
> grief when attempting to set up the ODBC connections also.
> Maybe I'd just be better off rewriting this to use an Access database
> instead
you don't actually need to reference the Machine name... just refer to it as
"(local)" or "."
so, the full instance name will be
(local)\InstanceName
stay this MSDE... you'll love it =;-D
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
|||"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2npor3F3baroU1@.uni-berlin.de...
> hi Bradley,
> "Bradley M. Small" <BSmall@.XNOSPAMXmjsi.com> ha scritto nel messaggio
> news:ejW7scifEHA.1424@.tk2msftngp13.phx.gbl...
> you don't actually need to reference the Machine name... just refer to it
as
> "(local)" or "."
> so, the full instance name will be
> (local)\InstanceName
> stay this MSDE... you'll love it =;-D
> --
Great!!! Seemed like there had to be a better syntax
Now, all I need to figure out is how to add the odbc connection from a batch
file. Is that even possible?
I was considering using a batch file to do the install using the line
setup INSTANCENAME="InstanceName" SAPWD="AStrongSAPwd"
However, the next step would be to call osql to either script the schema or
sp_attach_db the database. Well this raises the issue of once installed
with a named instance how do I do osql -E -S MACHINENAME\InstanceName
without knowing it ahead of time? Is there perhaps 1. an easier way or 2. a
different syntax to achieving it? I am pretty sure I will run into more
grief when attempting to set up the ODBC connections also.
Maybe I'd just be better off rewriting this to use an Access database
instead
hi Bradley,
"Bradley M. Small" <BSmall@.XNOSPAMXmjsi.com> ha scritto nel messaggio
news:ejW7scifEHA.1424@.tk2msftngp13.phx.gbl...
> I am writing an application and wish to distribute MSDE with it.
> I was considering using a batch file to do the install using the line
> setup INSTANCENAME="InstanceName" SAPWD="AStrongSAPwd"
> However, the next step would be to call osql to either script the schema
or
> sp_attach_db the database. Well this raises the issue of once installed
> with a named instance how do I do osql -E -S MACHINENAME\InstanceName
> without knowing it ahead of time? Is there perhaps 1. an easier way or 2.
a
> different syntax to achieving it? I am pretty sure I will run into more
> grief when attempting to set up the ODBC connections also.
> Maybe I'd just be better off rewriting this to use an Access database
> instead
you don't actually need to reference the Machine name... just refer to it as
"(local)" or "."
so, the full instance name will be
(local)\InstanceName
stay this MSDE... you'll love it =;-D
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
|||"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2npor3F3baroU1@.uni-berlin.de...
> hi Bradley,
> "Bradley M. Small" <BSmall@.XNOSPAMXmjsi.com> ha scritto nel messaggio
> news:ejW7scifEHA.1424@.tk2msftngp13.phx.gbl...
> you don't actually need to reference the Machine name... just refer to it
as
> "(local)" or "."
> so, the full instance name will be
> (local)\InstanceName
> stay this MSDE... you'll love it =;-D
> --
Great!!! Seemed like there had to be a better syntax
Now, all I need to figure out is how to add the odbc connection from a batch
file. Is that even possible?
MSDE 2000 license
After careful reading the MSDE 2000 EULA I still have a question about MSDE
license. May we use/distribute MSDE free of charge as a database back-end for
our product on customer’s desktops running Windows 2000/XP and servers
running Windows Server 2000/2003?
I believe it is free for a single user environment. I don't "believe"
you can use this as a backend database where multiple users
connect to the same sql server instance without it counting
towards the CAL license requirements.
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.learncsharp.net/home/listings.aspx
"Stan" <Stan@.discussions.microsoft.com> wrote in message
news:E6DC9496-49DF-44AE-8D52-6017F6D05785@.microsoft.com...
> After careful reading the MSDE 2000 EULA I still have a question about
> MSDE
> license. May we use/distribute MSDE free of charge as a database back-end
> for
> our product on customer's desktops running Windows 2000/XP and servers
> running Windows Server 2000/2003?
|||"Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
news:%23Th9n0fHFHA.3648@.TK2MSFTNGP09.phx.gbl...
>I believe it is free for a single user environment. I don't "believe"
> you can use this as a backend database where multiple users
> connect to the same sql server instance without it counting
> towards the CAL license requirements.
>
MSDE is free. You can use it as the back end of a multi user application
within its built-in limitations. There is a limit of 2g per database and a
built-in query governor to reduce performance when more than 5 concurrent
workloads hit the server. Also MSDE does not come with a license for the
management tools. If you can live with these restrictions then you can use
MSDE as a backend for your application.
As you application grows and needs to scale to more users, you can upgrade
MSDE to the full version of SQL Server.
David
|||Didn't they used to require that you register with MS in order to distribute
MSDE with your apps? Is that still a condition?
Thanks,
Mike C.
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:%23YVC7FgHFHA.400@.TK2MSFTNGP14.phx.gbl...
> "Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
> news:%23Th9n0fHFHA.3648@.TK2MSFTNGP09.phx.gbl...
> MSDE is free. You can use it as the back end of a multi user application
> within its built-in limitations. There is a limit of 2g per database and
> a built-in query governor to reduce performance when more than 5
> concurrent workloads hit the server. Also MSDE does not come with a
> license for the management tools. If you can live with these restrictions
> then you can use MSDE as a backend for your application.
> As you application grows and needs to scale to more users, you can upgrade
> MSDE to the full version of SQL Server.
> David
>
|||I wasn't dead on regarding licensing. However, I had the right idea.
The various links about licensing and performance would appear to
rule ouf the use of MSDE in a multi-user environment of more than
just a few people.
http://www.microsoft.com/sql/msde/default.asp
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.learncsharp.net/home/listings.aspx
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:%23YVC7FgHFHA.400@.TK2MSFTNGP14.phx.gbl...
> "Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
> news:%23Th9n0fHFHA.3648@.TK2MSFTNGP09.phx.gbl...
> MSDE is free. You can use it as the back end of a multi user application
> within its built-in limitations. There is a limit of 2g per database and
> a built-in query governor to reduce performance when more than 5
> concurrent workloads hit the server. Also MSDE does not come with a
> license for the management tools. If you can live with these restrictions
> then you can use MSDE as a backend for your application.
> As you application grows and needs to scale to more users, you can upgrade
> MSDE to the full version of SQL Server.
> David
>
|||"Michael C#" <xyz@.abcdef.com> wrote in message
news:T6RUd.5566$kO5.4576@.fe12.lga...
> Didn't they used to require that you register with MS in order to
> distribute MSDE with your apps? Is that still a condition?
>
MSDE used to be distributed only as a part of other products, like Visual
Studio, .NET Framework SDK, Web Matrix etc. But now it's available from
download directly. See http://www.microsoft.com/sql/msde/default.asp.
It appears that you need to register if you didn't receive MSDE as part of
another application. But anyone interested in MSDE should buy the Developer
Edition of SQL Server. It's $50, it includes MSDE and all the SQL Server
tools. So you can develop against SQL Server and possibly deploy on MSDE.
David
|||"Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
news:O6A$JzgHFHA.4048@.TK2MSFTNGP15.phx.gbl...
>I wasn't dead on regarding licensing. However, I had the right idea.
> The various links about licensing and performance would appear to
> rule ouf the use of MSDE in a multi-user environment of more than
> just a few people.
> http://www.microsoft.com/sql/msde/default.asp
>
Indeed. MSDE is indended for small client-server deployments and small web
applications. It gives the developer the freedom of not having to make a
technology choice based on money. Just code to SQL Server. If your
application is small enough you can deploy on MSDE for free. If your
application is larger, buy and deploy on SQL Server.
David
|||"David Browne" wrote:
> "Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
> news:O6A$JzgHFHA.4048@.TK2MSFTNGP15.phx.gbl...
> Indeed. MSDE is indended for small client-server deployments and small web
> applications. It gives the developer the freedom of not having to make a
> technology choice based on money. Just code to SQL Server. If your
> application is small enough you can deploy on MSDE for free. If your
> application is larger, buy and deploy on SQL Server.
> David
>
>
May somebody from Microsoft confirm this please?
Stan
license. May we use/distribute MSDE free of charge as a database back-end for
our product on customer’s desktops running Windows 2000/XP and servers
running Windows Server 2000/2003?
I believe it is free for a single user environment. I don't "believe"
you can use this as a backend database where multiple users
connect to the same sql server instance without it counting
towards the CAL license requirements.
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.learncsharp.net/home/listings.aspx
"Stan" <Stan@.discussions.microsoft.com> wrote in message
news:E6DC9496-49DF-44AE-8D52-6017F6D05785@.microsoft.com...
> After careful reading the MSDE 2000 EULA I still have a question about
> MSDE
> license. May we use/distribute MSDE free of charge as a database back-end
> for
> our product on customer's desktops running Windows 2000/XP and servers
> running Windows Server 2000/2003?
|||"Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
news:%23Th9n0fHFHA.3648@.TK2MSFTNGP09.phx.gbl...
>I believe it is free for a single user environment. I don't "believe"
> you can use this as a backend database where multiple users
> connect to the same sql server instance without it counting
> towards the CAL license requirements.
>
MSDE is free. You can use it as the back end of a multi user application
within its built-in limitations. There is a limit of 2g per database and a
built-in query governor to reduce performance when more than 5 concurrent
workloads hit the server. Also MSDE does not come with a license for the
management tools. If you can live with these restrictions then you can use
MSDE as a backend for your application.
As you application grows and needs to scale to more users, you can upgrade
MSDE to the full version of SQL Server.
David
|||Didn't they used to require that you register with MS in order to distribute
MSDE with your apps? Is that still a condition?
Thanks,
Mike C.
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:%23YVC7FgHFHA.400@.TK2MSFTNGP14.phx.gbl...
> "Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
> news:%23Th9n0fHFHA.3648@.TK2MSFTNGP09.phx.gbl...
> MSDE is free. You can use it as the back end of a multi user application
> within its built-in limitations. There is a limit of 2g per database and
> a built-in query governor to reduce performance when more than 5
> concurrent workloads hit the server. Also MSDE does not come with a
> license for the management tools. If you can live with these restrictions
> then you can use MSDE as a backend for your application.
> As you application grows and needs to scale to more users, you can upgrade
> MSDE to the full version of SQL Server.
> David
>
|||I wasn't dead on regarding licensing. However, I had the right idea.
The various links about licensing and performance would appear to
rule ouf the use of MSDE in a multi-user environment of more than
just a few people.
http://www.microsoft.com/sql/msde/default.asp
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.learncsharp.net/home/listings.aspx
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:%23YVC7FgHFHA.400@.TK2MSFTNGP14.phx.gbl...
> "Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
> news:%23Th9n0fHFHA.3648@.TK2MSFTNGP09.phx.gbl...
> MSDE is free. You can use it as the back end of a multi user application
> within its built-in limitations. There is a limit of 2g per database and
> a built-in query governor to reduce performance when more than 5
> concurrent workloads hit the server. Also MSDE does not come with a
> license for the management tools. If you can live with these restrictions
> then you can use MSDE as a backend for your application.
> As you application grows and needs to scale to more users, you can upgrade
> MSDE to the full version of SQL Server.
> David
>
|||"Michael C#" <xyz@.abcdef.com> wrote in message
news:T6RUd.5566$kO5.4576@.fe12.lga...
> Didn't they used to require that you register with MS in order to
> distribute MSDE with your apps? Is that still a condition?
>
MSDE used to be distributed only as a part of other products, like Visual
Studio, .NET Framework SDK, Web Matrix etc. But now it's available from
download directly. See http://www.microsoft.com/sql/msde/default.asp.
It appears that you need to register if you didn't receive MSDE as part of
another application. But anyone interested in MSDE should buy the Developer
Edition of SQL Server. It's $50, it includes MSDE and all the SQL Server
tools. So you can develop against SQL Server and possibly deploy on MSDE.
David
|||"Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
news:O6A$JzgHFHA.4048@.TK2MSFTNGP15.phx.gbl...
>I wasn't dead on regarding licensing. However, I had the right idea.
> The various links about licensing and performance would appear to
> rule ouf the use of MSDE in a multi-user environment of more than
> just a few people.
> http://www.microsoft.com/sql/msde/default.asp
>
Indeed. MSDE is indended for small client-server deployments and small web
applications. It gives the developer the freedom of not having to make a
technology choice based on money. Just code to SQL Server. If your
application is small enough you can deploy on MSDE for free. If your
application is larger, buy and deploy on SQL Server.
David
|||"David Browne" wrote:
> "Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
> news:O6A$JzgHFHA.4048@.TK2MSFTNGP15.phx.gbl...
> Indeed. MSDE is indended for small client-server deployments and small web
> applications. It gives the developer the freedom of not having to make a
> technology choice based on money. Just code to SQL Server. If your
> application is small enough you can deploy on MSDE for free. If your
> application is larger, buy and deploy on SQL Server.
> David
>
>
May somebody from Microsoft confirm this please?
Stan
MSDE 2000 license
After careful reading the MSDE 2000 EULA I still have a question about MSDE
license. May we use/distribute MSDE free of charge as a database back-end for
our product on customerâ's desktops running Windows 2000/XP and servers
running Windows Server 2000/2003?I believe it is free for a single user environment. I don't "believe"
you can use this as a backend database where multiple users
connect to the same sql server instance without it counting
towards the CAL license requirements.
--
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.learncsharp.net/home/listings.aspx
"Stan" <Stan@.discussions.microsoft.com> wrote in message
news:E6DC9496-49DF-44AE-8D52-6017F6D05785@.microsoft.com...
> After careful reading the MSDE 2000 EULA I still have a question about
> MSDE
> license. May we use/distribute MSDE free of charge as a database back-end
> for
> our product on customer's desktops running Windows 2000/XP and servers
> running Windows Server 2000/2003?|||"Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
news:%23Th9n0fHFHA.3648@.TK2MSFTNGP09.phx.gbl...
>I believe it is free for a single user environment. I don't "believe"
> you can use this as a backend database where multiple users
> connect to the same sql server instance without it counting
> towards the CAL license requirements.
>
MSDE is free. You can use it as the back end of a multi user application
within its built-in limitations. There is a limit of 2g per database and a
built-in query governor to reduce performance when more than 5 concurrent
workloads hit the server. Also MSDE does not come with a license for the
management tools. If you can live with these restrictions then you can use
MSDE as a backend for your application.
As you application grows and needs to scale to more users, you can upgrade
MSDE to the full version of SQL Server.
David|||Didn't they used to require that you register with MS in order to distribute
MSDE with your apps? Is that still a condition?
Thanks,
Mike C.
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:%23YVC7FgHFHA.400@.TK2MSFTNGP14.phx.gbl...
> "Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
> news:%23Th9n0fHFHA.3648@.TK2MSFTNGP09.phx.gbl...
>>I believe it is free for a single user environment. I don't "believe"
>> you can use this as a backend database where multiple users
>> connect to the same sql server instance without it counting
>> towards the CAL license requirements.
> MSDE is free. You can use it as the back end of a multi user application
> within its built-in limitations. There is a limit of 2g per database and
> a built-in query governor to reduce performance when more than 5
> concurrent workloads hit the server. Also MSDE does not come with a
> license for the management tools. If you can live with these restrictions
> then you can use MSDE as a backend for your application.
> As you application grows and needs to scale to more users, you can upgrade
> MSDE to the full version of SQL Server.
> David
>|||I wasn't dead on regarding licensing. However, I had the right idea.
The various links about licensing and performance would appear to
rule ouf the use of MSDE in a multi-user environment of more than
just a few people.
http://www.microsoft.com/sql/msde/default.asp
--
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.learncsharp.net/home/listings.aspx
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:%23YVC7FgHFHA.400@.TK2MSFTNGP14.phx.gbl...
> "Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
> news:%23Th9n0fHFHA.3648@.TK2MSFTNGP09.phx.gbl...
>>I believe it is free for a single user environment. I don't "believe"
>> you can use this as a backend database where multiple users
>> connect to the same sql server instance without it counting
>> towards the CAL license requirements.
> MSDE is free. You can use it as the back end of a multi user application
> within its built-in limitations. There is a limit of 2g per database and
> a built-in query governor to reduce performance when more than 5
> concurrent workloads hit the server. Also MSDE does not come with a
> license for the management tools. If you can live with these restrictions
> then you can use MSDE as a backend for your application.
> As you application grows and needs to scale to more users, you can upgrade
> MSDE to the full version of SQL Server.
> David
>|||"Michael C#" <xyz@.abcdef.com> wrote in message
news:T6RUd.5566$kO5.4576@.fe12.lga...
> Didn't they used to require that you register with MS in order to
> distribute MSDE with your apps? Is that still a condition?
>
MSDE used to be distributed only as a part of other products, like Visual
Studio, .NET Framework SDK, Web Matrix etc. But now it's available from
download directly. See http://www.microsoft.com/sql/msde/default.asp.
It appears that you need to register if you didn't receive MSDE as part of
another application. But anyone interested in MSDE should buy the Developer
Edition of SQL Server. It's $50, it includes MSDE and all the SQL Server
tools. So you can develop against SQL Server and possibly deploy on MSDE.
David|||"Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
news:O6A$JzgHFHA.4048@.TK2MSFTNGP15.phx.gbl...
>I wasn't dead on regarding licensing. However, I had the right idea.
> The various links about licensing and performance would appear to
> rule ouf the use of MSDE in a multi-user environment of more than
> just a few people.
> http://www.microsoft.com/sql/msde/default.asp
>
Indeed. MSDE is indended for small client-server deployments and small web
applications. It gives the developer the freedom of not having to make a
technology choice based on money. Just code to SQL Server. If your
application is small enough you can deploy on MSDE for free. If your
application is larger, buy and deploy on SQL Server.
David|||"David Browne" wrote:
> "Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
> news:O6A$JzgHFHA.4048@.TK2MSFTNGP15.phx.gbl...
> >I wasn't dead on regarding licensing. However, I had the right idea.
> > The various links about licensing and performance would appear to
> > rule ouf the use of MSDE in a multi-user environment of more than
> > just a few people.
> >
> > http://www.microsoft.com/sql/msde/default.asp
> >
> Indeed. MSDE is indended for small client-server deployments and small web
> applications. It gives the developer the freedom of not having to make a
> technology choice based on money. Just code to SQL Server. If your
> application is small enough you can deploy on MSDE for free. If your
> application is larger, buy and deploy on SQL Server.
> David
>
>
May somebody from Microsoft confirm this please?
Stan
license. May we use/distribute MSDE free of charge as a database back-end for
our product on customerâ's desktops running Windows 2000/XP and servers
running Windows Server 2000/2003?I believe it is free for a single user environment. I don't "believe"
you can use this as a backend database where multiple users
connect to the same sql server instance without it counting
towards the CAL license requirements.
--
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.learncsharp.net/home/listings.aspx
"Stan" <Stan@.discussions.microsoft.com> wrote in message
news:E6DC9496-49DF-44AE-8D52-6017F6D05785@.microsoft.com...
> After careful reading the MSDE 2000 EULA I still have a question about
> MSDE
> license. May we use/distribute MSDE free of charge as a database back-end
> for
> our product on customer's desktops running Windows 2000/XP and servers
> running Windows Server 2000/2003?|||"Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
news:%23Th9n0fHFHA.3648@.TK2MSFTNGP09.phx.gbl...
>I believe it is free for a single user environment. I don't "believe"
> you can use this as a backend database where multiple users
> connect to the same sql server instance without it counting
> towards the CAL license requirements.
>
MSDE is free. You can use it as the back end of a multi user application
within its built-in limitations. There is a limit of 2g per database and a
built-in query governor to reduce performance when more than 5 concurrent
workloads hit the server. Also MSDE does not come with a license for the
management tools. If you can live with these restrictions then you can use
MSDE as a backend for your application.
As you application grows and needs to scale to more users, you can upgrade
MSDE to the full version of SQL Server.
David|||Didn't they used to require that you register with MS in order to distribute
MSDE with your apps? Is that still a condition?
Thanks,
Mike C.
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:%23YVC7FgHFHA.400@.TK2MSFTNGP14.phx.gbl...
> "Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
> news:%23Th9n0fHFHA.3648@.TK2MSFTNGP09.phx.gbl...
>>I believe it is free for a single user environment. I don't "believe"
>> you can use this as a backend database where multiple users
>> connect to the same sql server instance without it counting
>> towards the CAL license requirements.
> MSDE is free. You can use it as the back end of a multi user application
> within its built-in limitations. There is a limit of 2g per database and
> a built-in query governor to reduce performance when more than 5
> concurrent workloads hit the server. Also MSDE does not come with a
> license for the management tools. If you can live with these restrictions
> then you can use MSDE as a backend for your application.
> As you application grows and needs to scale to more users, you can upgrade
> MSDE to the full version of SQL Server.
> David
>|||I wasn't dead on regarding licensing. However, I had the right idea.
The various links about licensing and performance would appear to
rule ouf the use of MSDE in a multi-user environment of more than
just a few people.
http://www.microsoft.com/sql/msde/default.asp
--
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.learncsharp.net/home/listings.aspx
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:%23YVC7FgHFHA.400@.TK2MSFTNGP14.phx.gbl...
> "Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
> news:%23Th9n0fHFHA.3648@.TK2MSFTNGP09.phx.gbl...
>>I believe it is free for a single user environment. I don't "believe"
>> you can use this as a backend database where multiple users
>> connect to the same sql server instance without it counting
>> towards the CAL license requirements.
> MSDE is free. You can use it as the back end of a multi user application
> within its built-in limitations. There is a limit of 2g per database and
> a built-in query governor to reduce performance when more than 5
> concurrent workloads hit the server. Also MSDE does not come with a
> license for the management tools. If you can live with these restrictions
> then you can use MSDE as a backend for your application.
> As you application grows and needs to scale to more users, you can upgrade
> MSDE to the full version of SQL Server.
> David
>|||"Michael C#" <xyz@.abcdef.com> wrote in message
news:T6RUd.5566$kO5.4576@.fe12.lga...
> Didn't they used to require that you register with MS in order to
> distribute MSDE with your apps? Is that still a condition?
>
MSDE used to be distributed only as a part of other products, like Visual
Studio, .NET Framework SDK, Web Matrix etc. But now it's available from
download directly. See http://www.microsoft.com/sql/msde/default.asp.
It appears that you need to register if you didn't receive MSDE as part of
another application. But anyone interested in MSDE should buy the Developer
Edition of SQL Server. It's $50, it includes MSDE and all the SQL Server
tools. So you can develop against SQL Server and possibly deploy on MSDE.
David|||"Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
news:O6A$JzgHFHA.4048@.TK2MSFTNGP15.phx.gbl...
>I wasn't dead on regarding licensing. However, I had the right idea.
> The various links about licensing and performance would appear to
> rule ouf the use of MSDE in a multi-user environment of more than
> just a few people.
> http://www.microsoft.com/sql/msde/default.asp
>
Indeed. MSDE is indended for small client-server deployments and small web
applications. It gives the developer the freedom of not having to make a
technology choice based on money. Just code to SQL Server. If your
application is small enough you can deploy on MSDE for free. If your
application is larger, buy and deploy on SQL Server.
David|||"David Browne" wrote:
> "Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
> news:O6A$JzgHFHA.4048@.TK2MSFTNGP15.phx.gbl...
> >I wasn't dead on regarding licensing. However, I had the right idea.
> > The various links about licensing and performance would appear to
> > rule ouf the use of MSDE in a multi-user environment of more than
> > just a few people.
> >
> > http://www.microsoft.com/sql/msde/default.asp
> >
> Indeed. MSDE is indended for small client-server deployments and small web
> applications. It gives the developer the freedom of not having to make a
> technology choice based on money. Just code to SQL Server. If your
> application is small enough you can deploy on MSDE for free. If your
> application is larger, buy and deploy on SQL Server.
> David
>
>
May somebody from Microsoft confirm this please?
Stan
MSDE 2000 license
After careful reading the MSDE 2000 EULA I still have a question about MSDE
license. May we use/distribute MSDE free of charge as a database back-end fo
r
our product on customer’s desktops running Windows 2000/XP and servers
running Windows Server 2000/2003?I believe it is free for a single user environment. I don't "believe"
you can use this as a backend database where multiple users
connect to the same sql server instance without it counting
towards the CAL license requirements.
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.learncsharp.net/home/listings.aspx
"Stan" <Stan@.discussions.microsoft.com> wrote in message
news:E6DC9496-49DF-44AE-8D52-6017F6D05785@.microsoft.com...
> After careful reading the MSDE 2000 EULA I still have a question about
> MSDE
> license. May we use/distribute MSDE free of charge as a database back-end
> for
> our product on customer's desktops running Windows 2000/XP and servers
> running Windows Server 2000/2003?|||"Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
news:%23Th9n0fHFHA.3648@.TK2MSFTNGP09.phx.gbl...
>I believe it is free for a single user environment. I don't "believe"
> you can use this as a backend database where multiple users
> connect to the same sql server instance without it counting
> towards the CAL license requirements.
>
MSDE is free. You can use it as the back end of a multi user application
within its built-in limitations. There is a limit of 2g per database and a
built-in query governor to reduce performance when more than 5 concurrent
workloads hit the server. Also MSDE does not come with a license for the
management tools. If you can live with these restrictions then you can use
MSDE as a backend for your application.
As you application grows and needs to scale to more users, you can upgrade
MSDE to the full version of SQL Server.
David|||Didn't they used to require that you register with MS in order to distribute
MSDE with your apps? Is that still a condition?
Thanks,
Mike C.
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:%23YVC7FgHFHA.400@.TK2MSFTNGP14.phx.gbl...
> "Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
> news:%23Th9n0fHFHA.3648@.TK2MSFTNGP09.phx.gbl...
> MSDE is free. You can use it as the back end of a multi user application
> within its built-in limitations. There is a limit of 2g per database and
> a built-in query governor to reduce performance when more than 5
> concurrent workloads hit the server. Also MSDE does not come with a
> license for the management tools. If you can live with these restrictions
> then you can use MSDE as a backend for your application.
> As you application grows and needs to scale to more users, you can upgrade
> MSDE to the full version of SQL Server.
> David
>|||I wasn't dead on regarding licensing. However, I had the right idea.
The various links about licensing and performance would appear to
rule ouf the use of MSDE in a multi-user environment of more than
just a few people.
http://www.microsoft.com/sql/msde/default.asp
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.learncsharp.net/home/listings.aspx
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:%23YVC7FgHFHA.400@.TK2MSFTNGP14.phx.gbl...
> "Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
> news:%23Th9n0fHFHA.3648@.TK2MSFTNGP09.phx.gbl...
> MSDE is free. You can use it as the back end of a multi user application
> within its built-in limitations. There is a limit of 2g per database and
> a built-in query governor to reduce performance when more than 5
> concurrent workloads hit the server. Also MSDE does not come with a
> license for the management tools. If you can live with these restrictions
> then you can use MSDE as a backend for your application.
> As you application grows and needs to scale to more users, you can upgrade
> MSDE to the full version of SQL Server.
> David
>|||"Michael C#" <xyz@.abcdef.com> wrote in message
news:T6RUd.5566$kO5.4576@.fe12.lga...
> Didn't they used to require that you register with MS in order to
> distribute MSDE with your apps? Is that still a condition?
>
MSDE used to be distributed only as a part of other products, like Visual
Studio, .NET Framework SDK, Web Matrix etc. But now it's available from
download directly. See http://www.microsoft.com/sql/msde/default.asp.
It appears that you need to register if you didn't receive MSDE as part of
another application. But anyone interested in MSDE should buy the Developer
Edition of SQL Server. It's $50, it includes MSDE and all the SQL Server
tools. So you can develop against SQL Server and possibly deploy on MSDE.
David|||"Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
news:O6A$JzgHFHA.4048@.TK2MSFTNGP15.phx.gbl...
>I wasn't dead on regarding licensing. However, I had the right idea.
> The various links about licensing and performance would appear to
> rule ouf the use of MSDE in a multi-user environment of more than
> just a few people.
> http://www.microsoft.com/sql/msde/default.asp
>
Indeed. MSDE is indended for small client-server deployments and small web
applications. It gives the developer the freedom of not having to make a
technology choice based on money. Just code to SQL Server. If your
application is small enough you can deploy on MSDE for free. If your
application is larger, buy and deploy on SQL Server.
David|||"David Browne" wrote:
> "Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
> news:O6A$JzgHFHA.4048@.TK2MSFTNGP15.phx.gbl...
> Indeed. MSDE is indended for small client-server deployments and small we
b
> applications. It gives the developer the freedom of not having to make a
> technology choice based on money. Just code to SQL Server. If your
> application is small enough you can deploy on MSDE for free. If your
> application is larger, buy and deploy on SQL Server.
> David
>
>
May somebody from Microsoft confirm this please?
Stan
license. May we use/distribute MSDE free of charge as a database back-end fo
r
our product on customer’s desktops running Windows 2000/XP and servers
running Windows Server 2000/2003?I believe it is free for a single user environment. I don't "believe"
you can use this as a backend database where multiple users
connect to the same sql server instance without it counting
towards the CAL license requirements.
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.learncsharp.net/home/listings.aspx
"Stan" <Stan@.discussions.microsoft.com> wrote in message
news:E6DC9496-49DF-44AE-8D52-6017F6D05785@.microsoft.com...
> After careful reading the MSDE 2000 EULA I still have a question about
> MSDE
> license. May we use/distribute MSDE free of charge as a database back-end
> for
> our product on customer's desktops running Windows 2000/XP and servers
> running Windows Server 2000/2003?|||"Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
news:%23Th9n0fHFHA.3648@.TK2MSFTNGP09.phx.gbl...
>I believe it is free for a single user environment. I don't "believe"
> you can use this as a backend database where multiple users
> connect to the same sql server instance without it counting
> towards the CAL license requirements.
>
MSDE is free. You can use it as the back end of a multi user application
within its built-in limitations. There is a limit of 2g per database and a
built-in query governor to reduce performance when more than 5 concurrent
workloads hit the server. Also MSDE does not come with a license for the
management tools. If you can live with these restrictions then you can use
MSDE as a backend for your application.
As you application grows and needs to scale to more users, you can upgrade
MSDE to the full version of SQL Server.
David|||Didn't they used to require that you register with MS in order to distribute
MSDE with your apps? Is that still a condition?
Thanks,
Mike C.
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:%23YVC7FgHFHA.400@.TK2MSFTNGP14.phx.gbl...
> "Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
> news:%23Th9n0fHFHA.3648@.TK2MSFTNGP09.phx.gbl...
> MSDE is free. You can use it as the back end of a multi user application
> within its built-in limitations. There is a limit of 2g per database and
> a built-in query governor to reduce performance when more than 5
> concurrent workloads hit the server. Also MSDE does not come with a
> license for the management tools. If you can live with these restrictions
> then you can use MSDE as a backend for your application.
> As you application grows and needs to scale to more users, you can upgrade
> MSDE to the full version of SQL Server.
> David
>|||I wasn't dead on regarding licensing. However, I had the right idea.
The various links about licensing and performance would appear to
rule ouf the use of MSDE in a multi-user environment of more than
just a few people.
http://www.microsoft.com/sql/msde/default.asp
2005 Microsoft MVP C#
Robbe Morris
http://www.robbemorris.com
http://www.learncsharp.net/home/listings.aspx
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> wrote in
message news:%23YVC7FgHFHA.400@.TK2MSFTNGP14.phx.gbl...
> "Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
> news:%23Th9n0fHFHA.3648@.TK2MSFTNGP09.phx.gbl...
> MSDE is free. You can use it as the back end of a multi user application
> within its built-in limitations. There is a limit of 2g per database and
> a built-in query governor to reduce performance when more than 5
> concurrent workloads hit the server. Also MSDE does not come with a
> license for the management tools. If you can live with these restrictions
> then you can use MSDE as a backend for your application.
> As you application grows and needs to scale to more users, you can upgrade
> MSDE to the full version of SQL Server.
> David
>|||"Michael C#" <xyz@.abcdef.com> wrote in message
news:T6RUd.5566$kO5.4576@.fe12.lga...
> Didn't they used to require that you register with MS in order to
> distribute MSDE with your apps? Is that still a condition?
>
MSDE used to be distributed only as a part of other products, like Visual
Studio, .NET Framework SDK, Web Matrix etc. But now it's available from
download directly. See http://www.microsoft.com/sql/msde/default.asp.
It appears that you need to register if you didn't receive MSDE as part of
another application. But anyone interested in MSDE should buy the Developer
Edition of SQL Server. It's $50, it includes MSDE and all the SQL Server
tools. So you can develop against SQL Server and possibly deploy on MSDE.
David|||"Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
news:O6A$JzgHFHA.4048@.TK2MSFTNGP15.phx.gbl...
>I wasn't dead on regarding licensing. However, I had the right idea.
> The various links about licensing and performance would appear to
> rule ouf the use of MSDE in a multi-user environment of more than
> just a few people.
> http://www.microsoft.com/sql/msde/default.asp
>
Indeed. MSDE is indended for small client-server deployments and small web
applications. It gives the developer the freedom of not having to make a
technology choice based on money. Just code to SQL Server. If your
application is small enough you can deploy on MSDE for free. If your
application is larger, buy and deploy on SQL Server.
David|||"David Browne" wrote:
> "Robbe Morris [C# MVP]" <info@.turnkeytools.com> wrote in message
> news:O6A$JzgHFHA.4048@.TK2MSFTNGP15.phx.gbl...
> Indeed. MSDE is indended for small client-server deployments and small we
b
> applications. It gives the developer the freedom of not having to make a
> technology choice based on money. Just code to SQL Server. If your
> application is small enough you can deploy on MSDE for free. If your
> application is larger, buy and deploy on SQL Server.
> David
>
>
May somebody from Microsoft confirm this please?
Stan
Subscribe to:
Posts (Atom)