|
 |
aspx thread: Enterprise Manager for SQL Server 2000
Message #1 by Kapil <subscribaa@y...> on Wed, 14 Mar 2001 03:11:49 -0800 (PST)
|
|
Then what is the use of shipping SQL server with .NET
if I cannot create a database or stored procedures
using enterprise Manager? Is there another way of
doing this without using Enterprise Manager?
The Enterprise manager for SQL Server 7 refuses to
connect to the SQL server 2000.
Kapil.
--- Carrico Todd <TCarrico@f...> wrote:
> I am pretty sure the SQL 7 Enterprise Manager will
> not work on SQL 2000
> instances. You should be able to get a 120 day Eval
> for free.
>
> Your mileage may vary.
>
> tc
>
> -----Original Message-----
> From: Gerhard Wentink [mailto:wentink@w...]
> Sent: Friday, March 09, 2001 1:55 AM
> To: ASP+
> Subject: [aspx] Re: .net stuff
>
> As far as I know the Enterprise manager comes with
> SQL Server.
> I installed SQL Server 7 on a W2K server together
> with the SDK and I the
> Entreprise manager is there in the programs menu.
>
> Gerhard wentink
>
>
> ----- Original Message -----
> From: "Kapil" <subscribaa@y...>
> To: "ASP+" <aspx@p...>
> Sent: Friday, March 09, 2001 7:25 AM
> Subject: [aspx] Re: .net stuff
>
>
> > Is there no Enterprise Manager for the SQL server
> 2000
> > which comes with .NET? Where can I get this?
> >
> > Kapil
> >
> >
> > --- Jerry Diegel <jerryd@h...> wrote:
> > > If I have a W2K server that I uses to develop on
> and
> > > I install the beta .Net
> > > platform, will I still be able to run existing
> asp
> > > pages on that server.
> > > I've seen a few things that seemed to point
> towards
> > > yes, but I wanted to be
> > > sure.
> > >
> > > Thanks,
> > >
> > > Jerry
> > >
>
>
Message #2 by "Juan T. Llibre" <j.llibre@c...> on Wed, 14 Mar 2001 09:08:15 -0500
|
|
There seems to be some confusion here.
What you're saying is akin to wondering why
Windows XP can't be managed from Windows 2.11.
What you get with the .NET Framework and VS.NET betas
is NOT SQL Server. It's MSDE, which is a "Personal SQL Server"
comprised of just the SQL Server Data Engine and can only accept
up to 5 simultaneous connections. It's designed to be used as a
test platform for SQL Server applications, and the code used to
access MSDE data is identical to that needed by SQL Server.
Enterprise Manager is NOT included with MSDE, though it's included
in both SQL Server 7.0 and SQL Server 2000 and though SQL 7.0's
EM can't manage SQL 2000.
You can create databases and SPs for MSDE,
with the Data Explorer included in the VS.NET Beta
or programmatically, with .sql scripts.
If you want the ease of use which Enterprise Manager
gives you, you have to purchase SQL Server 7 or SQL Server 2000.
You CAN, though, use SQL Server 7 as a data source for .NET Applications.
regards,
Juan T. Llibre
Microsoft MVP [IIS/ASP]
ASP.Net En Espaņol : http://207.176.17.140/
http://www.asplists.com/asplists/aspnges.asp
http://p2p.wrox.com/scripts/lyris.pl?join=aspx_espanol
ASP en Espaņol : http://aspespanol.com/
===============================
----- Original Message -----
From: "Kapil" <subscribaa@y...>
To: "ASP+" <aspx@p...>
Sent: Wednesday, March 14, 2001 6:11 AM
Subject: [aspx] Enterprise Manager for SQL Server 2000
> Then what is the use of shipping SQL server with .NET
> if I cannot create a database or stored procedures
> using enterprise Manager? Is there another way of
> doing this without using Enterprise Manager?
>
> The Enterprise manager for SQL Server 7 refuses to
> connect to the SQL server 2000.
>
> Kapil.
>
> --- Carrico Todd <TCarrico@f...> wrote:
> > I am pretty sure the SQL 7 Enterprise Manager will
> > not work on SQL 2000
> > instances. You should be able to get a 120 day Eval
> > for free.
> >
> > Your mileage may vary.
> >
> > tc
> >
> > -----Original Message-----
> > From: Gerhard Wentink [mailto:wentink@w...]
> > Sent: Friday, March 09, 2001 1:55 AM
> > To: ASP+
> > Subject: [aspx] Re: .net stuff
> >
> > As far as I know the Enterprise manager comes with
> > SQL Server.
> > I installed SQL Server 7 on a W2K server together
> > with the SDK and I the
> > Entreprise manager is there in the programs menu.
> >
> > Gerhard wentink
> >
> >
> > ----- Original Message -----
> > From: "Kapil" <subscribaa@y...>
> > To: "ASP+" <aspx@p...>
> > Sent: Friday, March 09, 2001 7:25 AM
> > Subject: [aspx] Re: .net stuff
> >
> >
> > > Is there no Enterprise Manager for the SQL server
> > 2000
> > > which comes with .NET? Where can I get this?
> > >
> > > Kapil
> > >
> > >
> > > --- Jerry Diegel <jerryd@h...> wrote:
> > > > If I have a W2K server that I uses to develop on
> > and
> > > > I install the beta .Net
> > > > platform, will I still be able to run existing
> > asp
> > > > pages on that server.
> > > > I've seen a few things that seemed to point
> > towards
> > > > yes, but I wanted to be
> > > > sure.
> > > >
> > > > Thanks,
> > > >
> > > > Jerry
> > > >
> >
> >
>
> ---
> SoftArtisans helps developers build robust, scalable Web applications!
> Excel Web reports, charts: http://www.softartisans.com/excelwriter.html
> File uploads: http://www.softartisans.com/saf.html
> Transactional file management: http://www.softartisans.com/saf1.html
> Scalability: http://www.softartisans.com/saxsession.html
> ASPstudio value pack: http://www.softartisans.com/aspstudiosuite.html
>
Message #3 by "Steve Schofield" <steve@a...> on Thu, 15 Mar 2001 19:09:33 -0500
|
|
Kapil,
If you have Access 2000 then you can use a local database called .adp. this
will allow you to connect to the MSDE version running on your local machine.
* -----------------------------------------*
* Steve Schofield
* steve@a...
*
* Webmaster
* http://www.aspfree.com
* http://www.abc2xml.com
* http://www.thinclientzone.com
* -----------------------------------------*
----- Original Message -----
From: "Kapil" <subscribaa@y...>
To: "ASP+" <aspx@p...>
Sent: Wednesday, March 14, 2001 6:11 AM
Subject: [aspx] Enterprise Manager for SQL Server 2000
> Then what is the use of shipping SQL server with .NET
> if I cannot create a database or stored procedures
> using enterprise Manager? Is there another way of
> doing this without using Enterprise Manager?
>
> The Enterprise manager for SQL Server 7 refuses to
> connect to the SQL server 2000.
>
> Kapil.
>
> --- Carrico Todd <TCarrico@f...> wrote:
> > I am pretty sure the SQL 7 Enterprise Manager will
> > not work on SQL 2000
> > instances. You should be able to get a 120 day Eval
> > for free.
> >
> > Your mileage may vary.
> >
> > tc
> >
> > -----Original Message-----
> > From: Gerhard Wentink [mailto:wentink@w...]
> > Sent: Friday, March 09, 2001 1:55 AM
> > To: ASP+
> > Subject: [aspx] Re: .net stuff
> >
> > As far as I know the Enterprise manager comes with
> > SQL Server.
> > I installed SQL Server 7 on a W2K server together
> > with the SDK and I the
> > Entreprise manager is there in the programs menu.
> >
> > Gerhard wentink
> >
> >
> > ----- Original Message -----
> > From: "Kapil" <subscribaa@y...>
> > To: "ASP+" <aspx@p...>
> > Sent: Friday, March 09, 2001 7:25 AM
> > Subject: [aspx] Re: .net stuff
> >
> >
> > > Is there no Enterprise Manager for the SQL server
> > 2000
> > > which comes with .NET? Where can I get this?
> > >
> > > Kapil
|
|
|
View Cart
