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...
> > Hi All,
> >
> > Can you install the Standard Edition of SQL Server2000 on WindowsXP?
> >
> > Thanks,
> > Gloria
>
>|||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...
> 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...
>> > Hi All,
>> >
>> > Can you install the Standard Edition of SQL Server2000 on WindowsXP?
>> >
>> > Thanks,
>> > Gloria
>>|||> SQL Server developer edition can be installed on Win2KPro/WinXP.
Yes, but running it for other than development and test is violating the licensing 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 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...
>> 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...
>> > Hi All,
>> >
>> > Can you install the Standard Edition of SQL Server2000 on WindowsXP?
>> >
>> > Thanks,
>> > Gloria
>>
>|||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:
> > SQL Server developer edition can be installed on Win2KPro/WinXP.
> Yes, but running it for other than development and test is violating the licensing 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 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...
> >> 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...
> >> > Hi All,
> >> >
> >> > Can you install the Standard Edition of SQL Server2000 on WindowsXP?
> >> >
> >> > Thanks,
> >> > Gloria
> >>
> >>
> >>
> >
> >
>|||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:
> > SQL Server developer edition can be installed on Win2KPro/WinXP.
> Yes, but running it for other than development and test is violating the licensing 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 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...
> >> 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...
> >> > Hi All,
> >> >
> >> > Can you install the Standard Edition of SQL Server2000 on WindowsXP?
> >> >
> >> > Thanks,
> >> > Gloria
> >>
> >>
> >>
> >
> >
>|||> 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 don'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, but 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...
> 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:
>> > SQL Server developer edition can be installed on Win2KPro/WinXP.
>> Yes, but running it for other than development and test is violating the licensing 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 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...
>> >> 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...
>> >> > Hi All,
>> >> >
>> >> > Can you install the Standard Edition of SQL Server2000 on WindowsXP?
>> >> >
>> >> > Thanks,
>> >> > Gloria
>> >>
>> >>
>> >>
>> >
>> >|||> 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 connections or users per se. You
will only see performance degrade when having > 5 simultaneously execution statements. 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...
> 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:
>> > SQL Server developer edition can be installed on Win2KPro/WinXP.
>> Yes, but running it for other than development and test is violating the licensing 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 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...
>> >> 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...
>> >> > Hi All,
>> >> >
>> >> > Can you install the Standard Edition of SQL Server2000 on WindowsXP?
>> >> >
>> >> > Thanks,
>> >> > Gloria
>> >>
>> >>
>> >>
>> >
>> >|||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:
> > 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 don'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, but 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...
> > 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:
> >
> >> > SQL Server developer edition can be installed on Win2KPro/WinXP.
> >>
> >> Yes, but running it for other than development and test is violating the licensing 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 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...
> >> >> 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...
> >> >> > Hi All,
> >> >> >
> >> >> > Can you install the Standard Edition of SQL Server2000 on WindowsXP?
> >> >> >
> >> >> > Thanks,
> >> >> > Gloria
> >> >>
> >> >>
> >> >>
> >> >
> >> >
> >>
>|||Here's a good blog on the subject:
http://blogs.msdn.com/euanga/archive/2006/03/09/545576.aspx
--
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:EC50317E-CA9C-4891-859C-5CA0DC0A3E73@.microsoft.com...
> 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:
>> > 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 don'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, but 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...
>> > 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:
>> >
>> >> > SQL Server developer edition can be installed on Win2KPro/WinXP.
>> >>
>> >> Yes, but running it for other than development and test is violating the licensing 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 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...
>> >> >> 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...
>> >> >> > Hi All,
>> >> >> >
>> >> >> > Can you install the Standard Edition of SQL Server2000 on WindowsXP?
>> >> >> >
>> >> >> > Thanks,
>> >> >> > Gloria
>> >> >>
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>>