Discussion Locked

ERROR CLARIFICATION

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

1) There are 2 Pc's (PC A and PC B) connected on the network, both are servers. Running on Windows NT ver. 4.0

2) They are able to connect to each other and transfer data..

3) They also have SQL SERVER ver. 7.0 standard Edition installed..
Now the problem is..

1) When i connect from system A to access the SQL -SERVER on system B it gets connected and there's absolutely no problem..

2) But when I try to connect from the system B to system A then i get this error message --"login Failed. The maximum simultaneous user
count of 1 license for this 'Standard Edition'
has been exceeded. Additional licenses should be
obtained and installed or you should upgrade
to a full version"

Please help
Thank You In Anticipation
John Bosco

4 replies

by elinden

If you are using developer editions of SQL server then you will need to access the server as the same login ID this is most likely SA since sa is loged in on machine A with various tasks. Additionaly when you set up the Sql Server you were given a choice of licensing per server or per seat if you selected per server and left it at the default of 1 then this is the problem. You can go into the control panel and adjust this setting. However be aware YOU CAN ONLY CHANG THIS SETTING ONCE from per server to per seat. The prefered setting would be per seat. That requires that each client accessing the server have a valid set of client utilities installed. Additioanly if you are using the Developer addition there are built in limitations to the number of users and connections that are allowed.

This discussion is closed to new replies.