General discussion

  • Creator
    Topic
  • #2130862

    SQL 2000 managed from workstation

    Locked

    by wb7nqm ·

    Group,
    We are running SQL Server 2000 for our document imaging database and, as admin, I need to run queries on a regular basis. Does SQL have a client version I can install on my workstation to run Enterprise Manager/Query Analyzer? Our server is situated such that I have to stand while working and that can get uncomfortable quickly. I searched MSKB but did not find anything (perhaps used the wrong search criteria). Any info would be greatly appreciated.

    Thank you in advance, Carolyn

All Comments

  • Author
    Replies
    • #3546251

      SQL 2000 managed from workstation

      by ann777 ·

      In reply to SQL 2000 managed from workstation

      No, it doesn’t.

      The only way you could do this (without moving the server to a desk), is to install remote comtrol software (like PC Anywhere or Remote Control, etc.) and setup your server to wait as a host (PASSWORD PROTECT IT) and your workstation with the ability to network into it as needed.

      • #3546804

        SQL 2000 managed from workstation

        by wb7nqm ·

        In reply to SQL 2000 managed from workstation

        As I said before, I knew PCAnywhere would work but did not want to leave the server Listening. Also, I wish there was a “somewhat helpful” choice as, if I hadn’t know about PCA, this would have been a helpful answer.
        Thanks for responding quickly, tho’.
        Happy Holidays, Carolyn

    • #3546214

      SQL 2000 managed from workstation

      by maxwell edison ·

      In reply to SQL 2000 managed from workstation

      Greetings,

      There are ? maybe – some common SQL database tasks that could be remotely managed.

      See the following link to an article titled, ?Remote Management of an SQL Server Database with Access 2000?.

      http://support.activeisp.nl/application/sql/sql-access.asp

      (REMOVE SPACES if any snuck into the pasted URL.)

      This sounds like a ?some? but not ?all? access to SQL management ability. But it may lead you in the direction you?re looking for.

      Maxwell

      • #3546210

        SQL 2000 managed from workstation

        by maxwell edison ·

        In reply to SQL 2000 managed from workstation

        .
        .
        More information:

        The following link takes you to an article titled:

        ?Data Management: SQL Remote Database Access?

        http://www.opengroup.org/products/publications/catalog/c307.htm

        The following link takes you to an SQL Magazine article titled:

        ?Scripts for Remote Management?

        An excerpt from the article:

        ??have access to all the management features on the servers, such as Enterprise Manager or Internet Service Manager ??

        http://www.sqlmag.com/Articles/Index.cfm?ArticleID=8239

        (Don?t forget to REMOVE those pesky SPACES.)

        Good luck,

        Maxwell

      • #3546205

        SQL 2000 managed from workstation

        by maxwell edison ·

        In reply to SQL 2000 managed from workstation

        .
        .
        Another possibility would involve a third-party solution (I don’t know the price).

        “Database Administrators Can Access, Manage and Control SQL Server Databases from Anywhere, Anytime With Web DBA? for Microsoft SQL Server.”

        ” BMC Software, Inc., [Nasdaq: BMCS], the leading provider of e-business systems management, today announced Web DBA for SQL Server, the latest version of the the company’s Web-based interactive database solution. Web DBA? for SQL Server requires only a standard Internet browser to address the daily database management tasks faced by today’s database administrators (DBA) and developers. Generally available in January, Web DBA for SQL Server enables developers and DBAs to manage and control their SQL Server databases from anywhere, anytime.”

        A link to the full article:

        http://www.dbadirect.com/worryless_approach/newsevents_link.asp?page=displayframe&type=news&record=28

        Regards,

        Maxwell

      • #3546805

        SQL 2000 managed from workstation

        by wb7nqm ·

        In reply to SQL 2000 managed from workstation

        Actually, the rating is wrong as I did not know about running the database remotely on Access. That was very interesting although it pulled the first 10K records (all from 1999) so my dated queries failed!
        So, sorry about the rating but there isn’t a “helped some” choice!
        Happy Holidays, Carolyn

    • #3546166

      SQL 2000 managed from workstation

      by stillatit ·

      In reply to SQL 2000 managed from workstation

      If 2000 is anything like 7, take the installation CD, put it on your workstation, and run the install. It will tell you that it cannot install the SQL server on a workstation, and offer to install the utilities for you.

      Good luck.

      • #3546806

        SQL 2000 managed from workstation

        by wb7nqm ·

        In reply to SQL 2000 managed from workstation

        Thank you for this suggestion (actually for being the first one, as there was another about an hour later). I now have it installed and working on my Win2K workstation. SO much better on my back and hip!
        Happy Holidays

    • #3546866

      SQL 2000 managed from workstation

      by joseph moore ·

      In reply to SQL 2000 managed from workstation

      Yes, you can run SQL Enterprise Manager, Query Analyzier and all of that from a NT/2000 workstation. I have these tools installed on my workstation right now.
      Put the SQL 2000 cd in the cd drive on your Workstation. Start the install.
      Click SQL Server 2000 Components
      Click Install Database Server
      You will then get an error box saying “Microsoft SQL Server 2000 server component is not supported on this operating system. Only client components will be available for installation.”
      Click OK onthe error box.
      Start the wizard.
      You will get to an option to install Client Tools. That is what you want. Run the wizard from there.

      Hope this helps.

      • #3546807

        SQL 2000 managed from workstation

        by wb7nqm ·

        In reply to SQL 2000 managed from workstation

        Thank you for this suggestion (actually for being the second one, as there was another about an hour earlier). I wish I could divide the points between two answers as they both had good information.
        Happy Holidays, Carolyn

    • #3546803

      SQL 2000 managed from workstation

      by wb7nqm ·

      In reply to SQL 2000 managed from workstation

      This question was closed by the author

Viewing 4 reply threads