|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Installing SQL Server 2000 on WindowsXP
Hi All,
Can you install the Standard Edition of SQL Server2000 on WindowsXP? Thanks, Gloria No, SQL Server2000 standard/enterprise edition requires server OS (Win2K
Server or Win2003). Show quoteHide quote "Gloria" <Glo***@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 Show quoteHide quote "Norman Yuan" wrote: > No, SQL Server2000 standard/enterprise edition requires server OS (Win2K > Server or Win2003). > > "Gloria" <Glo***@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). Show quoteHide quote "Gloria" <Glo***@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" <Glo***@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.-- Show quoteHide quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Norman Yuan" <NotR***@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" <Glo***@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" <Glo***@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 Show quoteHide quote "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" <NotR***@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" <Glo***@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" <Glo***@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 There is no directly corresponding edition. Express would be the closest, but it is actually closer > would be which? 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. -- Show quoteHide quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Gloria" <Glo***@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" <NotR***@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" <Glo***@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" <Glo***@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 Show quoteHide quote "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" <Glo***@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" <NotR***@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" <Glo***@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" <Glo***@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 -- Show quoteHide quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Gloria" <Glo***@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" <Glo***@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" <NotR***@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" <Glo***@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" <Glo***@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 Show quoteHide quote "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" <NotR***@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" <Glo***@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" <Glo***@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 No, that is only a performance throttler. It doesn't limit either connections or users per se. You > connections you can have to the server. I believe the number is 5. will only see performance degrade when having > 5 simultaneously execution statements. Express doesn't have this throttler. -- Show quoteHide quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Gloria" <Glo***@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" <NotR***@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" <Glo***@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" <Glo***@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 >> >>> >> >>> >> >>> >> > >> > >>  
Other interesting topics
Need help with server configuration.
BCP problem on different servers Left outer join v. Union Query compiling time Problem with scripting in SQL 2005 after SP2 UPDATE won't execute on 2k5 installation Monitoring free space in database and log files with script How do I ignore server errors in Stored Proc run via SQL Agent How to Improve SQL Server performance with web application Server migration |
|||||||||||||||||||||||
