From where to download sql MSDE CLIENT TOOLS

Hi,
I am installing MSDE 2000 on client machines. Where can I dowload the client
connectivity tools for MSDE so that users can see and work with thier
databases?
Do I have to download sql sp4 for that? Can someone please send me the link
for downloading the client tools?
Thanks
pmud
Microsoft does not provide any 'client tools' for MSDE.
Users must have an application, or programming environment such as Visual
Studio -or even Access.
There are some third party management tools on the internet -but I don't
recall that any of them where tools for "users can see and work with thier
databases", if by that you mean execute queries, etc.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"pmud" <pmud@.discussions.microsoft.com> wrote in message
news:520FF8F8-271E-4AE3-84B0-7433C04B9E5A@.microsoft.com...
> Hi,
> I am installing MSDE 2000 on client machines. Where can I dowload the
> client
> connectivity tools for MSDE so that users can see and work with thier
> databases?
> Do I have to download sql sp4 for that? Can someone please send me the
> link
> for downloading the client tools?
> Thanks
> --
> pmud
|||Hi Arnie,
By users seeing the databases , I mean like in Enterpsir Manager, users can
see all the databases by right clicking and can see teh schema of the tables.
Also, I have SQL SErver 2000 CD with valid license. So do I think I can copy
the client tools from there and put it on all machines Ineed MSDE on?
Which files do i need to copy for taking the client tools only?
Thanks
pmud
"Arnie Rowland" wrote:

> Microsoft does not provide any 'client tools' for MSDE.
> Users must have an application, or programming environment such as Visual
> Studio -or even Access.
> There are some third party management tools on the internet -but I don't
> recall that any of them where tools for "users can see and work with thier
> databases", if by that you mean execute queries, etc.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "pmud" <pmud@.discussions.microsoft.com> wrote in message
> news:520FF8F8-271E-4AE3-84B0-7433C04B9E5A@.microsoft.com...
>
>
|||The client tools you have on your "SQL SErver 2000 CD" are NOT be licensed
as client tools for MSDE.
Do all the of computers that you contemplate needing 'client tools'
currently have a SQL Server Client Access License (CAL)?
I would suggest that you verify with Microsoft licensing before you put your
company/agency at risk.
Licensing -VL Contact
(800) 426-9400
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"pmud" <pmud@.discussions.microsoft.com> wrote in message
news:23129FFE-B1D1-4C97-8E9B-6FE5F9913B7D@.microsoft.com...[vbcol=seagreen]
> Hi Arnie,
> By users seeing the databases , I mean like in Enterpsir Manager, users
> can
> see all the databases by right clicking and can see teh schema of the
> tables.
> Also, I have SQL SErver 2000 CD with valid license. So do I think I can
> copy
> the client tools from there and put it on all machines Ineed MSDE on?
> Which files do i need to copy for taking the client tools only?
> Thanks
> --
> pmud
>
> "Arnie Rowland" wrote:
|||Hi Arni e,
Thanks for your response. I think if we have Process license for sql server
2000, we should be able to install sql server 2000 teself on any no. of
mahcines...without worrying about installing sql msde 2000... What do you
think?
Thanks
pmud
"Arnie Rowland" wrote:

> The client tools you have on your "SQL SErver 2000 CD" are NOT be licensed
> as client tools for MSDE.
> Do all the of computers that you contemplate needing 'client tools'
> currently have a SQL Server Client Access License (CAL)?
> I would suggest that you verify with Microsoft licensing before you put your
> company/agency at risk.
> Licensing -VL Contact
> (800) 426-9400
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "pmud" <pmud@.discussions.microsoft.com> wrote in message
> news:23129FFE-B1D1-4C97-8E9B-6FE5F9913B7D@.microsoft.com...
>
>
|||If you are doing 'new' development, I suggest that you may wish to explore
SQL Server 2005 Developer Edition. Then there will be no question/issue
about client tools and licensing.
I believe the cost is about $50 (US) per developer, and you are allowed to
have as many SQL Servers as necessary to support your development efforts.
For more details:
Licensing -Developer Edition
My understanding of the Developers Edition license is that you are covered
for a Development server, an Integration/Staging server, even a QA/Test
server, local servers on the developers computer, etc. -as long as no one
except developers access those SQL Servers, and as long as each developer
and/or Tester has a Developer Edition License.
For a more definitive answer, check with the VL folks at: (800) 426-9400.
From: http://www.microsoft.com/sql/edition...r/default.mspx
Each license of SQL Server 2005 Developer Edition entitles one developer to
use the software on as many systems as necessary and additional developers
can use the software by purchasing additional licenses.
From:
http://download.microsoft.com/downlo...ensingv1.1.doc
DEVELOPER EDITION
SQL Server Developer Edition is a separate product and is used for
development and testing purposes only. It is licensed per developer or
tester (person).
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"pmud" <pmud@.discussions.microsoft.com> wrote in message
news:BC52F760-BD17-4C22-8DD0-916DDE4BB2B2@.microsoft.com...[vbcol=seagreen]
> Also Arnie, we have sql developer edition too. Do you think I can install
> that on the machines... since this will be for development only,... we
> wont
> be using this developer edition for production.
> Please let me know your thoughts.
> Thanks
> --
> pmud
>
> "Arnie Rowland" wrote:
|||Thanks Arnie. It was helpful.
pmud
"Arnie Rowland" wrote:

> That is not correct. Your 'processor' license allows you to install SQL
> Server on ONE computer, and allow unlimited clients to have access to that
> ONE SQL Server. And you must have one license per CPU in that computer.
> If you have a second SQL Server, it must have its own license.
> I suggest that you may wish to chat with Microsoft licensing to clear up any
> 'uncertainties'. And to also verify what is allowed use for SQL 2000 client
> tools and multiple installations of MSDE.
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
> "pmud" <pmud@.discussions.microsoft.com> wrote in message
> news:9406756B-9235-4387-B180-2A2ECFECAA9D@.microsoft.com...
>
>
|||Actually, Microsoft does have a tool for administering MSDE
databases. SQL Server Web Data Administrator was developed
with this in mind. You can download it from:
http://www.microsoft.com/downloads/d...displaylang=en
You can find a list of other alternatives, options at:
http://sqlserver2000.databases.aspfa...rver/msde.html
-Sue
On Tue, 26 Sep 2006 11:14:02 -0700, pmud
<pmud@.discussions.microsoft.com> wrote:

>Also Arnie, we have sql developer edition too. Do you think I can install
>that on the machines... since this will be for development only,... we wont
>be using this developer edition for production.
>Please let me know your thoughts.
>Thanks
|||Hi Sue,
Its great to know about the SQL Web Data Admin. I installed it , but then I
go to view the page from http://localhost/webadmin/default.aspx, its showing
me the code instead of the web page.
I know this is happening coz in IIS my web sites are not configured to
regonize to .aspx extension. How to configure IIS to understand .aspx
extension? I know we have to right lick on teh properties for the node called
Web Sites in IIS, then go to Home Diretory tab, click Configuration button at
the bottom, BUt what do I enter in the next window that pulls up , i.e what
will be the executable path for .aspx extension?
Thanks
pmud
"Sue Hoegemeier" wrote:

> Actually, Microsoft does have a tool for administering MSDE
> databases. SQL Server Web Data Administrator was developed
> with this in mind. You can download it from:
> http://www.microsoft.com/downloads/d...displaylang=en
> You can find a list of other alternatives, options at:
> http://sqlserver2000.databases.aspfa...rver/msde.html
> -Sue
> On Tue, 26 Sep 2006 11:14:02 -0700, pmud
> <pmud@.discussions.microsoft.com> wrote:
>
>
|||If you have the .Net framework installed and need to
configure IIS for ASP.Net, you should be able to just run
aspnet_regiis -i
from the framework's folder location and it will do the
necessary steps to configure IIS for ASP.NET
This article addresses the gist of what you would need to
do:
http://support.microsoft.com/?id=306005
-Sue
On Tue, 26 Sep 2006 15:24:02 -0700, pmud
<pmud@.discussions.microsoft.com> wrote:

>Hi Sue,
>Its great to know about the SQL Web Data Admin. I installed it , but then I
>go to view the page from http://localhost/webadmin/default.aspx, its showing
>me the code instead of the web page.
>I know this is happening coz in IIS my web sites are not configured to
>regonize to .aspx extension. How to configure IIS to understand .aspx
>extension? I know we have to right lick on teh properties for the node called
>Web Sites in IIS, then go to Home Diretory tab, click Configuration button at
>the bottom, BUt what do I enter in the next window that pulls up , i.e what
>will be the executable path for .aspx extension?
>Thanks