Developer Edition Install

Hi, folks.
I've just reached the end of my frustration with trying to learn MSDE with no interface (in addition to ASP.NET), so I'm going to install 2K Developer Edition. However, I'd like to know if it's safe install it on top of MSDE. I'm currently running XP Pr
o, VS.NET, IIS 5.x, so I'm afraid that if I have uninstall MSDE that I'll break a bunch things that I've painstakingly configured. ;-)
Advice?
TIA,
Bob
What have you painstakingly configured? You might be able to easily =
configure these within SQL Server Developer Edition. =20
The other option: install the Developer Edition of SQL Server as a named =
instance. That will allow you to keep MSDE installed as well as give =
you the ability to use SQL Server (Developer Edition) on your computer.
--=20
Keith
"WebGuyBob" <anonymous@.discussions.microsoft.com> wrote in message =
news:1BD19D74-8A5A-4F9C-8FD6-D013309B7A45@.microsoft.com...
> Hi, folks.
>=20
> I've just reached the end of my frustration with trying to learn MSDE =
with no interface (in addition to ASP.NET), so I'm going to install 2K =
Developer Edition. However, I'd like to know if it's safe install it on =
top of MSDE. I'm currently running XP Pro, VS.NET, IIS 5.x, so I'm =
afraid that if I have uninstall MSDE that I'll break a bunch things that =
I've painstakingly configured. ;-)
>=20
> Advice?
>=20
> TIA,
>=20
> Bob
|||Keith,
The configuration statement actually refers to the installation and configuration of IIS and VS.NET. I feared that when I installed MSDE, it dug its hooks into those applications (inherent in many MS apps) and that uninstalling MSDE would "break" things.
I would prefer to have only one DB application on my machine. With that said, since it appears from your comments, because SQL2k DevEd does not install "on top" of MSDE, I will attempt to uninstall it and then install SQL2k DevEd.
I have developed any databases yet, but either VS.NET, MSDE, or the .NET SDK installed various sample databases. I was hoping to use those to learn from. If those happen to get deleted resulting from the uninstall, at least I've found a place where I ca
n get updated ones.
Any parting words of wisdom before I do the uninstall of MSDE and install of SQL2k DevEd?
Thanks,
Bob
|||The many "sample" databases should still exist -- in mdf and ldf form. =
Hopefully you will be able to use sp_attach_db to attach those databases =
to SQL Server Developer Edition.
Words of wisdom: Just do it.
Good luck. Post back if you have any questions along the way. There =
are many helpful people in the newsgroups that should be able to provide =
assistance should you need it.
--=20
Keith
"WebGuyBob" <anonymous@.discussions.microsoft.com> wrote in message =
news:4A5D898D-9A17-4C87-8554-AF6EFBF0F4DB@.microsoft.com...
> Keith,
>=20
> The configuration statement actually refers to the installation and =
configuration of IIS and VS.NET. I feared that when I installed MSDE, =
it dug its hooks into those applications (inherent in many MS apps) and =
that uninstalling MSDE would "break" things.
>=20
> I would prefer to have only one DB application on my machine. With =
that said, since it appears from your comments, because SQL2k DevEd does =
not install "on top" of MSDE, I will attempt to uninstall it and then =
install SQL2k DevEd.
>=20
> I have developed any databases yet, but either VS.NET, MSDE, or the =
..NET SDK installed various sample databases. I was hoping to use those =
to learn from. If those happen to get deleted resulting from the =
uninstall, at least I've found a place where I can get updated ones.
>=20
> Any parting words of wisdom before I do the uninstall of MSDE and =
install of SQL2k DevEd?
>=20
> Thanks,
>=20
> Bob
|||Or you could run the pubsinst.sql scripts from another sql server standard
install.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Developer Edition Install

Hi, folks
I've just reached the end of my frustration with trying to learn MSDE with no interface (in addition to ASP.NET), so I'm going to install 2K Developer Edition. However, I'd like to know if it's safe install it on top of MSDE. I'm currently running XP Pro, VS.NET, IIS 5.x, so I'm afraid that if I have uninstall MSDE that I'll break a bunch things that I've painstakingly configured. ;-
Advice
TIA
BobWhat have you painstakingly configured? You might be able to easily =configure these within SQL Server Developer Edition.
The other option: install the Developer Edition of SQL Server as a named =instance. That will allow you to keep MSDE installed as well as give =you the ability to use SQL Server (Developer Edition) on your computer.
-- Keith
"WebGuyBob" <anonymous@.discussions.microsoft.com> wrote in message =news:1BD19D74-8A5A-4F9C-8FD6-D013309B7A45@.microsoft.com...
> Hi, folks.
> > I've just reached the end of my frustration with trying to learn MSDE =with no interface (in addition to ASP.NET), so I'm going to install 2K =Developer Edition. However, I'd like to know if it's safe install it on =top of MSDE. I'm currently running XP Pro, VS.NET, IIS 5.x, so I'm =afraid that if I have uninstall MSDE that I'll break a bunch things that =I've painstakingly configured. ;-)
> > Advice?
> > TIA,
> > Bob|||Keith
The configuration statement actually refers to the installation and configuration of IIS and VS.NET. I feared that when I installed MSDE, it dug its hooks into those applications (inherent in many MS apps) and that uninstalling MSDE would "break" things
I would prefer to have only one DB application on my machine. With that said, since it appears from your comments, because SQL2k DevEd does not install "on top" of MSDE, I will attempt to uninstall it and then install SQL2k DevEd
I have developed any databases yet, but either VS.NET, MSDE, or the .NET SDK installed various sample databases. I was hoping to use those to learn from. If those happen to get deleted resulting from the uninstall, at least I've found a place where I can get updated ones
Any parting words of wisdom before I do the uninstall of MSDE and install of SQL2k DevEd
Thanks
Bob|||The many "sample" databases should still exist -- in mdf and ldf form. =Hopefully you will be able to use sp_attach_db to attach those databases =to SQL Server Developer Edition.
Words of wisdom: Just do it.
Good luck. Post back if you have any questions along the way. There =are many helpful people in the newsgroups that should be able to provide =assistance should you need it.
-- Keith
"WebGuyBob" <anonymous@.discussions.microsoft.com> wrote in message =news:4A5D898D-9A17-4C87-8554-AF6EFBF0F4DB@.microsoft.com...
> Keith,
> > The configuration statement actually refers to the installation and =configuration of IIS and VS.NET. I feared that when I installed MSDE, =it dug its hooks into those applications (inherent in many MS apps) and =that uninstalling MSDE would "break" things.
> > I would prefer to have only one DB application on my machine. With =that said, since it appears from your comments, because SQL2k DevEd does =not install "on top" of MSDE, I will attempt to uninstall it and then =install SQL2k DevEd.
> > I have developed any databases yet, but either VS.NET, MSDE, or the =.NET SDK installed various sample databases. I was hoping to use those =to learn from. If those happen to get deleted resulting from the =uninstall, at least I've found a place where I can get updated ones.
> > Any parting words of wisdom before I do the uninstall of MSDE and =install of SQL2k DevEd?
> > Thanks,
> > Bob|||Or you could run the pubsinst.sql scripts from another sql server standard
install.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Developer Edition Install

Hi, folks.
I've just reached the end of my frustration with trying to learn MSDE with n
o interface (in addition to ASP.NET), so I'm going to install 2K Developer E
dition. However, I'd like to know if it's safe install it on top of MSDE.
I'm currently running XP Pr
o, VS.NET, IIS 5.x, so I'm afraid that if I have uninstall MSDE that I'll br
eak a bunch things that I've painstakingly configured. ;-)
Advice?
TIA,
BobWhat have you painstakingly configured? You might be able to easily =
configure these within SQL Server Developer Edition. =20
The other option: install the Developer Edition of SQL Server as a named =
instance. That will allow you to keep MSDE installed as well as give =
you the ability to use SQL Server (Developer Edition) on your computer.
--=20
Keith
"WebGuyBob" <anonymous@.discussions.microsoft.com> wrote in message =
news:1BD19D74-8A5A-4F9C-8FD6-D013309B7A45@.microsoft.com...
> Hi, folks.
>=20
> I've just reached the end of my frustration with trying to learn MSDE =
with no interface (in addition to ASP.NET), so I'm going to install 2K =
Developer Edition. However, I'd like to know if it's safe install it on =
top of MSDE. I'm currently running XP Pro, VS.NET, IIS 5.x, so I'm =
afraid that if I have uninstall MSDE that I'll break a bunch things that =
I've painstakingly configured. ;-)
>=20
> Advice?
>=20
> TIA,
>=20
> Bob|||Keith,
The configuration statement actually refers to the installation and configur
ation of IIS and VS.NET. I feared that when I installed MSDE, it dug its ho
oks into those applications (inherent in many MS apps) and that uninstalling
MSDE would "break" things.
I would prefer to have only one DB application on my machine. With that sai
d, since it appears from your comments, because SQL2k DevEd does not install
"on top" of MSDE, I will attempt to uninstall it and then install SQL2k Dev
Ed.
I have developed any databases yet, but either VS.NET, MSDE, or the .NET SDK
installed various sample databases. I was hoping to use those to learn fro
m. If those happen to get deleted resulting from the uninstall, at least I'
ve found a place where I ca
n get updated ones.
Any parting words of wisdom before I do the uninstall of MSDE and install of
SQL2k DevEd?
Thanks,
Bob|||The many "sample" databases should still exist -- in mdf and ldf form. =
Hopefully you will be able to use sp_attach_db to attach those databases =
to SQL Server Developer Edition.
Words of wisdom: Just do it.
Good luck. Post back if you have any questions along the way. There =
are many helpful people in the newsgroups that should be able to provide =
assistance should you need it.
--=20
Keith
"WebGuyBob" <anonymous@.discussions.microsoft.com> wrote in message =
news:4A5D898D-9A17-4C87-8554-AF6EFBF0F4DB@.microsoft.com...
> Keith,
>=20
> The configuration statement actually refers to the installation and =
configuration of IIS and VS.NET. I feared that when I installed MSDE, =
it dug its hooks into those applications (inherent in many MS apps) and =
that uninstalling MSDE would "break" things.
>=20
> I would prefer to have only one DB application on my machine. With =
that said, since it appears from your comments, because SQL2k DevEd does =
not install "on top" of MSDE, I will attempt to uninstall it and then =
install SQL2k DevEd.
>=20
> I have developed any databases yet, but either VS.NET, MSDE, or the =
.NET SDK installed various sample databases. I was hoping to use those =
to learn from. If those happen to get deleted resulting from the =
uninstall, at least I've found a place where I can get updated ones.
>=20
> Any parting words of wisdom before I do the uninstall of MSDE and =
install of SQL2k DevEd?
>=20
> Thanks,
>=20
> Bob|||Or you could run the pubsinst.sql scripts from another sql server standard
install.
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Developer and enterprise edition

s the developer edition functional without having either the standard or
enterprise edition or is it an extended product.
I am trying to learn on the fly on my home pc and want to purchase SQL
server 2000. All other versions are expensive for this purpose.Yes, Developer Edition is stand-alone. You should be able to find it for <
$50.
You can also consider MSDE ($0), but with that edition you can't use
Enterprise Manager / Query Analyzer. There are alternatives, though...
http://www.aspfaq.com/2442
"rpa" <rpa@.discussions.microsoft.com> wrote in message
news:ABC8251E-47C2-4CE8-BAAA-A00B4F447865@.microsoft.com...
> s the developer edition functional without having either the standard or
> enterprise edition or is it an extended product.
> I am trying to learn on the fly on my home pc and want to purchase SQL
> server 2000. All other versions are expensive for this purpose.
>|||Thanks Aaron,
I've been getting conflicting feedback. I want to use the query
analyzer and
enterprise manager and create a little play database and retrieve info so
the MSDE version is out of the question. I used the evaluation edition but i
t
has since run out.
People have just been telling me that the developer edition was an add
on to the enterpise or standard edition, somewhat like the personal edition
is part of the enterprise edition. Is that not the case?
"Aaron [SQL Server MVP]" wrote:

> Yes, Developer Edition is stand-alone. You should be able to find it for
<
> $50.
> You can also consider MSDE ($0), but with that edition you can't use
> Enterprise Manager / Query Analyzer. There are alternatives, though...
> http://www.aspfaq.com/2442
>
> "rpa" <rpa@.discussions.microsoft.com> wrote in message
> news:ABC8251E-47C2-4CE8-BAAA-A00B4F447865@.microsoft.com...
>
>|||> People have just been telling me that the developer edition was an
add
> on to the enterpise or standard edition, somewhat like the personal
edition
> is part of the enterprise edition. Is that not the case?
No, developer edition is completely separate. Ask "people" where they got
their "information"...

Developer and enterprise edition

s the developer edition functional without having either the standard or
enterprise edition or is it an extended product.
I am trying to learn on the fly on my home pc and want to purchase SQL
server 2000. All other versions are expensive for this purpose.
Yes, Developer Edition is stand-alone. You should be able to find it for <
$50.
You can also consider MSDE ($0), but with that edition you can't use
Enterprise Manager / Query Analyzer. There are alternatives, though...
http://www.aspfaq.com/2442
"rpa" <rpa@.discussions.microsoft.com> wrote in message
news:ABC8251E-47C2-4CE8-BAAA-A00B4F447865@.microsoft.com...
> s the developer edition functional without having either the standard or
> enterprise edition or is it an extended product.
> I am trying to learn on the fly on my home pc and want to purchase SQL
> server 2000. All other versions are expensive for this purpose.
>
|||Thanks Aaron,
I've been getting conflicting feedback. I want to use the query
analyzer and
enterprise manager and create a little play database and retrieve info so
the MSDE version is out of the question. I used the evaluation edition but it
has since run out.
People have just been telling me that the developer edition was an add
on to the enterpise or standard edition, somewhat like the personal edition
is part of the enterprise edition. Is that not the case?
"Aaron [SQL Server MVP]" wrote:

> Yes, Developer Edition is stand-alone. You should be able to find it for <
> $50.
> You can also consider MSDE ($0), but with that edition you can't use
> Enterprise Manager / Query Analyzer. There are alternatives, though...
> http://www.aspfaq.com/2442
>
> "rpa" <rpa@.discussions.microsoft.com> wrote in message
> news:ABC8251E-47C2-4CE8-BAAA-A00B4F447865@.microsoft.com...
>
>
|||> People have just been telling me that the developer edition was an
add
> on to the enterpise or standard edition, somewhat like the personal
edition
> is part of the enterprise edition. Is that not the case?
No, developer edition is completely separate. Ask "people" where they got
their "information"...

Developer and enterprise edition

s the developer edition functional without having either the standard or
enterprise edition or is it an extended product.
I am trying to learn on the fly on my home pc and want to purchase SQL
server 2000. All other versions are expensive for this purpose.Yes, Developer Edition is stand-alone. You should be able to find it for <
$50.
You can also consider MSDE ($0), but with that edition you can't use
Enterprise Manager / Query Analyzer. There are alternatives, though...
http://www.aspfaq.com/2442
"rpa" <rpa@.discussions.microsoft.com> wrote in message
news:ABC8251E-47C2-4CE8-BAAA-A00B4F447865@.microsoft.com...
> s the developer edition functional without having either the standard or
> enterprise edition or is it an extended product.
> I am trying to learn on the fly on my home pc and want to purchase SQL
> server 2000. All other versions are expensive for this purpose.
>|||Thanks Aaron,
I've been getting conflicting feedback. I want to use the query
analyzer and
enterprise manager and create a little play database and retrieve info so
the MSDE version is out of the question. I used the evaluation edition but it
has since run out.
People have just been telling me that the developer edition was an add
on to the enterpise or standard edition, somewhat like the personal edition
is part of the enterprise edition. Is that not the case?
"Aaron [SQL Server MVP]" wrote:
> Yes, Developer Edition is stand-alone. You should be able to find it for <
> $50.
> You can also consider MSDE ($0), but with that edition you can't use
> Enterprise Manager / Query Analyzer. There are alternatives, though...
> http://www.aspfaq.com/2442
>
> "rpa" <rpa@.discussions.microsoft.com> wrote in message
> news:ABC8251E-47C2-4CE8-BAAA-A00B4F447865@.microsoft.com...
> > s the developer edition functional without having either the standard or
> > enterprise edition or is it an extended product.
> >
> > I am trying to learn on the fly on my home pc and want to purchase SQL
> > server 2000. All other versions are expensive for this purpose.
> >
> >
>
>|||> People have just been telling me that the developer edition was an
add
> on to the enterpise or standard edition, somewhat like the personal
edition
> is part of the enterprise edition. Is that not the case?
No, developer edition is completely separate. Ask "people" where they got
their "information"...

Dev/Learning Environment

I haven't used RS yet as we have leaned on Crystal Reports but I want to
learn and design in RS. We already have a live intranet RS page or two
developed by former employees hence I want to fill that gap of knowledge.
My questions :
While playing and designing, is it better to take my SQL dev box and add RS,
IIS, .net etc or should I just to tap into the live server that's already set
up? Any risks to running dev on the live box?
The data would reside on a third sql server.
Thanks for any best practice advice you can spare.
--
Mike
If data falls in the woods and nobody is there to see it ...... ?One gotcha that I had was getting SharePoint to use RS. Apparenlty I needed
to install some additional DLL to allow SharePoint to display RS as web
parts and for about an hour I had production SP down as things didn't go
smoothly.
I know you didn't mention SP - but in case you are gong to look forward to
it as your web portal.
"Tigermikefl" <Tigermikefl@.discussions.microsoft.com> wrote in message
news:23619A8F-2482-4CAA-9241-9C854FCE7898@.microsoft.com...
>I haven't used RS yet as we have leaned on Crystal Reports but I want to
> learn and design in RS. We already have a live intranet RS page or two
> developed by former employees hence I want to fill that gap of knowledge.
> My questions :
> While playing and designing, is it better to take my SQL dev box and add
> RS,
> IIS, .net etc or should I just to tap into the live server that's already
> set
> up? Any risks to running dev on the live box?
> The data would reside on a third sql server.
> Thanks for any best practice advice you can spare.
> --
> Mike
> If data falls in the woods and nobody is there to see it ...... ?