Installing SQL Server 2000 on WindowsXP

Hi All,
Can you install the Standard Edition of SQL Server2000 on WindowsXP?
Thanks,
GloriaNo, SQL Server2000 standard/enterprise edition requires server OS (Win2K
Server or Win2003).
"Gloria" <Gloria@.discussions.microsoft.com> wrote in message
news:0D80B9B2-D1ED-4B6D-AD4E-F98599F1C75F@.microsoft.com...
> Hi All,
> Can you install the Standard Edition of SQL Server2000 on WindowsXP?
> Thanks,
> Gloria|||Thanks.
I read that I can use the developer edition with WindowsXP but this is for
an OEM system and don't want to ship a system with a developer edition.
Can I use the personal edition or do I have to go with MSDE?
Gloria
"Norman Yuan" wrote:

> No, SQL Server2000 standard/enterprise edition requires server OS (Win2K
> Server or Win2003).
> "Gloria" <Gloria@.discussions.microsoft.com> wrote in message
> news:0D80B9B2-D1ED-4B6D-AD4E-F98599F1C75F@.microsoft.com...
>
>|||SQL Server developer edition can be installed on Win2KPro/WinXP. It is
equivalent to SQL Server enterprise Edition in functionalities and only cost
you $50. However, you may not be able to buy SQL Server2000 Developer
Edition any more. Instead, you would buy SQL Server2005 Developer Edition.
BTW, SQL Server2005 Standard Edition runs on Win2KPro/WinXP (if my recall it
correctly).
"Gloria" <Gloria@.discussions.microsoft.com> wrote in message
news:31D2CA06-7B12-488E-AE4D-1DD3168A903A@.microsoft.com...[vbcol=seagreen]
> Thanks.
> I read that I can use the developer edition with WindowsXP but this is for
> an OEM system and don't want to ship a system with a developer edition.
> Can I use the personal edition or do I have to go with MSDE?
> Gloria
> "Norman Yuan" wrote:
>|||> SQL Server developer edition can be installed on Win2KPro/WinXP.
Yes, but running it for other than development and test is violating the lic
ensing agreement.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Norman Yuan" <NotReal@.NotReal.not> wrote in message news:u3Op9KpgHHA.4596@.TK2MSFTNGP05.phx.
gbl...
> SQL Server developer edition can be installed on Win2KPro/WinXP. It is
> equivalent to SQL Server enterprise Edition in functionalities and only co
st
> you $50. However, you may not be able to buy SQL Server2000 Developer
> Edition any more. Instead, you would buy SQL Server2005 Developer Edition.
> BTW, SQL Server2005 Standard Edition runs on Win2KPro/WinXP (if my recall
it
> correctly).
> "Gloria" <Gloria@.discussions.microsoft.com> wrote in message
> news:31D2CA06-7B12-488E-AE4D-1DD3168A903A@.microsoft.com...
>|||Thanks for the info.
I found that I can use SQL Server2000 Personal Edition. I will need to
upgrade later. The SQL Server2005 edition that maps to the Personal Edition
would be which?
I see that there is a Standard Edition in 2005 that can use WindowsXP but it
probably costs alot more. Could I use the Server2005 Express Advance?
Thanks again!
Gloria
"Tibor Karaszi" wrote:

> Yes, but running it for other than development and test is violating the l
icensing agreement.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Norman Yuan" <NotReal@.NotReal.not> wrote in message news:u3Op9KpgHHA.4596
@.TK2MSFTNGP05.phx.gbl...
>|||With using the personal Edition, there is a question about the number of
connections you can have to the server. I believe the number is 5. To
clarify the meaning of connection, if I have an application running on 10
different computers and it is accessing the database at the same time, will
using the personal edition of SQL Server2000 prevent 5 of the people from
accessing the database?
Thanks,
Gloria
"Tibor Karaszi" wrote:

> Yes, but running it for other than development and test is violating the l
icensing agreement.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Norman Yuan" <NotReal@.NotReal.not> wrote in message news:u3Op9KpgHHA.4596
@.TK2MSFTNGP05.phx.gbl...
>|||> I found that I can use SQL Server2000 Personal Edition.
As I understand you, you are re-distributing this with your app? I doubt you
are allowed to
re-distribute personal edition, so make sure that you check with MS so you d
on't do anything illegal
here.

> The SQL Server2005 edition that maps to the Personal Edition
> would be which?
There is no directly corresponding edition. Express would be the closest, bu
t it is actually closer
to MSDE being free and re-distributable.

> Could I use the Server2005 Express Advance?
Probably, but you want to read up on MS web-site first. But, as always when
in doubt, contact your
MS rep to be certain.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Gloria" <Gloria@.discussions.microsoft.com> wrote in message
news:D502AB21-7EC7-4514-B9EF-C7B2E923C45E@.microsoft.com...[vbcol=seagreen]
> Thanks for the info.
> I found that I can use SQL Server2000 Personal Edition. I will need to
> upgrade later. The SQL Server2005 edition that maps to the Personal Editi
on
> would be which?
> I see that there is a Standard Edition in 2005 that can use WindowsXP but
it
> probably costs alot more. Could I use the Server2005 Express Advance?
> Thanks again!
> Gloria
> "Tibor Karaszi" wrote:
>|||> With using the personal Edition, there is a question about the number of
> connections you can have to the server. I believe the number is 5.
No, that is only a performance throttler. It doesn't limit either connection
s or users per se. You
will only see performance degrade when having > 5 simultaneously execution s
tatements. Express
doesn't have this throttler.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Gloria" <Gloria@.discussions.microsoft.com> wrote in message
news:91381CD7-73FF-48BE-9447-6CE730EB1667@.microsoft.com...[vbcol=seagreen]
> With using the personal Edition, there is a question about the number of
> connections you can have to the server. I believe the number is 5. To
> clarify the meaning of connection, if I have an application running on 10
> different computers and it is accessing the database at the same time, wil
l
> using the personal edition of SQL Server2000 prevent 5 of the people from
> accessing the database?
> Thanks,
> Gloria
> "Tibor Karaszi" wrote:
>|||What we do is buy a license and software disc and load SQL Server2000
Personal Edition on the system. I believe this is fine to do.
One final question...can you point me to documentation regarding the
connections using Personal Edition and that it is not limited to 5
connections. It would be nice to have in case this issue comes up again and
I have the documentation to prove it.
Thanks...as always,
Gloria
"Tibor Karaszi" wrote:

> As I understand you, you are re-distributing this with your app? I doubt y
ou are allowed to
> re-distribute personal edition, so make sure that you check with MS so you
don't do anything illegal
> here.
>
> There is no directly corresponding edition. Express would be the closest,
but it is actually closer
> to MSDE being free and re-distributable.
>
> Probably, but you want to read up on MS web-site first. But, as always whe
n in doubt, contact your
> MS rep to be certain.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Gloria" <Gloria@.discussions.microsoft.com> wrote in message
> news:D502AB21-7EC7-4514-B9EF-C7B2E923C45E@.microsoft.com...
>