SQL Server 2000: How to handle licenses?

[Johnny Ljunggren]

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

[Simon Hayes]

"Johnny Ljunggren" <jo****@navtek.no> wrote in message
news:pa****************************@navtek.no...

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

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

[Johnny Ljunggren]

Den Mon, 11 Oct 2004 21:05:11 +0200, skrev Simon Hayes:

Will SQL Server 2000 Enterprise Edition refuse to accept any new
connections when all licenses are used?

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.

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

[Simon Hayes]

"Johnny Ljunggren" <jo****@navtek.no> wrote in message
news:pa****************************@navtek.no...

Den Mon, 11 Oct 2004 21:05:11 +0200, skrev Simon Hayes:

Will SQL Server 2000 Enterprise Edition refuse to accept any new
connections when all licenses are used?

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.

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

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