Installing Without CD - Help

Hello:

We just leased a dedicated server and now want to install SQL Server
2000. We though we could just copy the contents of the CD to a folder
on the server and run AUTORUN. While it does load the splash screen,
when we click install SQL Server Components, the demoshield splash
screen comes up and then disappears. The install stops.

Any ideas? Is this even possible?

Thanks in advance.

Jason SweetHi

This should be possible.

If you are using remote control software it may not be displaying the
dialogue correctly.

John

<jason_sweet@.earthlink.net> wrote in message
news:1112413509.668538.132160@.l41g2000cwc.googlegr oups.com...
> Hello:
> We just leased a dedicated server and now want to install SQL Server
> 2000. We though we could just copy the contents of the CD to a folder
> on the server and run AUTORUN. While it does load the splash screen,
> when we click install SQL Server Components, the demoshield splash
> screen comes up and then disappears. The install stops.
> Any ideas? Is this even possible?
> Thanks in advance.
> Jason Sweet|||(jason_sweet@.earthlink.net) writes:
> We just leased a dedicated server and now want to install SQL Server
> 2000. We though we could just copy the contents of the CD to a folder
> on the server and run AUTORUN. While it does load the splash screen,
> when we click install SQL Server Components, the demoshield splash
> screen comes up and then disappears. The install stops.

Instead of the autorun, just trying running SETUP.BAT.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Installing SQL server2000 / windows 2003 server

I am going to start installing sql server soon, do I have to have IIS installed? Is it a requirement?
Thanks.Not at all...................U can proceed without IIS.........but need to install SP3a to run sql server 2000 on windows 2003 OS|||Oh, ok. Thanks so much.

-Laura

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...
>

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).
"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 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 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 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...
>
|||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 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...
>
|||> 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...[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 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:
|||> 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...[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, will
> 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 you 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 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...
>

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
>> >> >>
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >>
>>