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
pmudMicrosoft 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|||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 yo
ur
> 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...
>
>|||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:

> 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 yo
ur
> 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...
>
>|||> 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
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...[vbcol=seagreen]
> 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:
>|||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/editio...er/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/downl...censingv1.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 a
ny
> 'uncertainties'. And to also verify what is allowed use for SQL 2000 clien
t
> 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/...&displaylang=en
You can find a list of other alternatives, options at:
[url]http://sqlserver2000.databases.aspfaq.com/how-do-i-manage-sql-server/msde.html[/ur
l]
-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 calle
d
Web Sites in IIS, then go to Home Diretory tab, click Configuration button a
t
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/...&displaylang=en
> You can find a list of other alternatives, options at:
> [url]http://sqlserver2000.databases.aspfaq.com/how-do-i-manage-sql-server/msde.html[/
url]
> -Sue
> On Tue, 26 Sep 2006 11:14:02 -0700, pmud
> <pmud@.discussions.microsoft.com> wrote:
>
>