SQL2000 Management tools on web server?

Posted on 2007-07-19
Last Modified: 2010-04-18
I installed sql2000 on a server connected at the ISP with my webserver (sql server is not on the internet).
Can I get management tools installed on the webserver or will it not support that?  I know sql can't be installed on a webserver, which is why we have the sql server, but do we have to remote in every time we want to do anything (set up db's, tables, copies, queries, etc.)?  That makes it a double remote - complicated, confusing and slow.
The x86/setupsql.exe says it is disabled on the webserver - which is fine - I just want managment tools.  I know you can do it with sql2005  - anyone know how to solve this?
Question by:dcass
    LVL 75

    Accepted Solution


    Author Comment

    Please don't close - still working.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.
    Viewers will learn how the fundamental information of how to create a table.

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now