SQL Server 2000: How to handle licenses?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Johnny Ljunggren
    #1

    SQL Server 2000: How to handle licenses?


    Hello everybody

    I've got a small system (~20 client machines) connected to one SQL Server
    2000. Two of these machines refuse to connect to the database. As I don't
    know how the license system is supposed to work, I haven't investigated
    too much yet.
    My question is therefore:
    Will SQL Server 2000 Enterprise Edition refuse to accept any new
    connections when all licenses are used?
    Is such case, what tool do I use to add more licenses?

    thanks in advance
    --
    Johnny Ljunggren

    Tags: None
    • Simon Hayes
      #2
      Re: SQL Server 2000: How to handle licenses?


      "Johnny Ljunggren" <johnny@navtek. no> wrote in message
      news:pan.2004.1 0.11.18.43.41.5 58416@navtek.no ...[color=blue]
      >
      > Hello everybody
      >
      > I've got a small system (~20 client machines) connected to one SQL Server
      > 2000. Two of these machines refuse to connect to the database. As I don't
      > know how the license system is supposed to work, I haven't investigated
      > too much yet.
      > My question is therefore:
      > Will SQL Server 2000 Enterprise Edition refuse to accept any new
      > connections when all licenses are used?
      > Is such case, what tool do I use to add more licenses?
      >
      > thanks in advance
      > --
      > Johnny Ljunggren
      >[/color]

      I doubt it, although I don't know for sure. Can you connect from the problem
      workstations using a command-line tool like osql.exe? That will probably
      give you a clearer idea of what's happening.

      Simon


        Comment

        • Johnny Ljunggren
          #3
          Re: SQL Server 2000: How to handle licenses?

          Den Mon, 11 Oct 2004 21:05:11 +0200, skrev Simon Hayes:
          [color=blue][color=green]
          >> Will SQL Server 2000 Enterprise Edition refuse to accept any new
          >> connections when all licenses are used?[/color][/color]
          [color=blue]
          > I doubt it, although I don't know for sure. Can you connect from the problem
          > workstations using a command-line tool like osql.exe? That will probably
          > give you a clearer idea of what's happening.[/color]

          It turned out to be something completely different, and the machines
          connect as they should. I therefore assume that SQL Server 2000 doesn't
          really handle licenses at all.
          Is there a place where I can download osql.exe/isql.exe in a nice install
          package, or can I just copy the exe's from somewhere else?


          --
          Johnny Ljunggren

            Comment

            • Simon Hayes
              #4
              Re: SQL Server 2000: How to handle licenses?


              "Johnny Ljunggren" <johnny@navtek. no> wrote in message
              news:pan.2004.1 0.12.06.30.43.9 00511@navtek.no ...[color=blue]
              > Den Mon, 11 Oct 2004 21:05:11 +0200, skrev Simon Hayes:
              >[color=green][color=darkred]
              >>> Will SQL Server 2000 Enterprise Edition refuse to accept any new
              >>> connections when all licenses are used?[/color][/color]
              >[color=green]
              >> I doubt it, although I don't know for sure. Can you connect from the
              >> problem
              >> workstations using a command-line tool like osql.exe? That will probably
              >> give you a clearer idea of what's happening.[/color]
              >
              > It turned out to be something completely different, and the machines
              > connect as they should. I therefore assume that SQL Server 2000 doesn't
              > really handle licenses at all.
              > Is there a place where I can download osql.exe/isql.exe in a nice install
              > package, or can I just copy the exe's from somewhere else?
              >
              >
              > --
              > Johnny Ljunggren[/color]

              You can just install the MSSQL client tools, using the normal MSSQL setup
              program - that will give you the command line tools as well as the graphical
              ones. I think there's information in the readme about automating this as
              well, although I haven't tried it myself.

              Simon


                Comment

                Previous template Next
                Working...