Can SQL tools be installed from server install?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Eric Bragas

    Can SQL tools be installed from server install?

    Good day,

    Can SQL Server tools (QA, EM) can be installed on a client machine from
    a full SQL Server installation on a server? I can't find the CD.

    Thanks for your time.
    Eric

  • Erland Sommarskog

    #2
    Re: Can SQL tools be installed from server install?

    Eric Bragas (ericbragas@yah oo.com) writes:[color=blue]
    > Can SQL Server tools (QA, EM) can be installed on a client machine from
    > a full SQL Server installation on a server? I can't find the CD.[/color]

    Probably, but you would have to spend some time registering DLLs etc,
    and it would be quite messy.

    So finding the CD is a good idea.

    If you are an MSDN Universal Subscribler, you can get it from MSDN
    Downloads.


    --
    Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

    Books Online for SQL Server SP3 at
    Get the flexibility you need to use integrated solutions, apps, and innovations in technology with your data, wherever it lives—in the cloud, on-premises, or at the edge.

    Comment

    • Akinja

      #3
      Re: Can SQL tools be installed from server install?

      If you have a copy of SQL 2000 Enterprise Edition Eval copy, you can load it
      from there. The tools will not expire, just make sure you only select
      client tools and not the database engine

      Akinja Richards


      "Erland Sommarskog" <esquel@sommars kog.se> wrote in message
      news:Xns9686B45 3DA798Yazorman@ 127.0.0.1...[color=blue]
      > Eric Bragas (ericbragas@yah oo.com) writes:[color=green]
      >> Can SQL Server tools (QA, EM) can be installed on a client machine from
      >> a full SQL Server installation on a server? I can't find the CD.[/color]
      >
      > Probably, but you would have to spend some time registering DLLs etc,
      > and it would be quite messy.
      >
      > So finding the CD is a good idea.
      >
      > If you are an MSDN Universal Subscribler, you can get it from MSDN
      > Downloads.
      >
      >
      > --
      > Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se
      >
      > Books Online for SQL Server SP3 at
      > http://www.microsoft.com/sql/techinf...2000/books.asp[/color]


      Comment

      • Erland Sommarskog

        #4
        Re: Can SQL tools be installed from server install?

        Akinja (akinja@sbcglob al.net) writes:[color=blue]
        > If you have a copy of SQL 2000 Enterprise Edition Eval copy, you can
        > load it from there. The tools will not expire, just make sure you only
        > select client tools and not the database engine[/color]

        And if you don't have it, you can download it from www.microsoft.com.

        There might be two issues:
        1) License may not permit connecting to production environments.
        2) It used to be that service packs can be applied to EvalEdition. I
        don't know if this still is the case.


        --
        Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

        Books Online for SQL Server SP3 at
        Get the flexibility you need to use integrated solutions, apps, and innovations in technology with your data, wherever it lives—in the cloud, on-premises, or at the edge.

        Comment

        • Akinja

          #5
          Re: Can SQL tools be installed from server install?

          I think MS has smart to that trick. I haven't tried it.

          Akinja


          "Erland Sommarskog" <esquel@sommars kog.se> wrote in message
          news:Xns9686EB7 19AA49Yazorman@ 127.0.0.1...[color=blue]
          > Akinja (akinja@sbcglob al.net) writes:[color=green]
          >> If you have a copy of SQL 2000 Enterprise Edition Eval copy, you can
          >> load it from there. The tools will not expire, just make sure you only
          >> select client tools and not the database engine[/color]
          >
          > And if you don't have it, you can download it from www.microsoft.com.
          >
          > There might be two issues:
          > 1) License may not permit connecting to production environments.
          > 2) It used to be that service packs can be applied to EvalEdition. I
          > don't know if this still is the case.
          >
          >
          > --
          > Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se
          >
          > Books Online for SQL Server SP3 at
          > http://www.microsoft.com/sql/techinf...2000/books.asp[/color]


          Comment

          Working...