| Author |
Topic |
|
X002548
Not Just a Number
15586 Posts |
 Posted - 2003-07-09 : 08:46:57
|
| Anyone with any background on this.I installed 7.0 with cpu license ...and I altered the number of connections. When I reliazed what I was doing, I reset it to 0 (unlimited). And I got the message " The maximum numver of simeltaneaous user count of 0 license has been exceed for the standard server edition has been exceeded. Additional licenses..yada yada yada...or you should upgrade to a full version.What does "full version" mean?I then reset the number of connections to 10, and I get the same message except the count has risen to 1.I have had the luxury to other areas build my boxes, but now I have the "opportunity" to do this. SQL 2k is a breeze...I got 7.0 up and running and restored a dump from the server...just can't make a connection.Any help appreciated.ThanksBrett8-) |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-09 : 10:34:15
|
| HE HE HE HE HE...Got it...Very quirky though...tried all sorts of things...even bouncing the box did seem to work...Set it back to 0 connection, then I it Apply instead of OK, and THEN it asked me if it wanted to stop and start SQL server...Lo and behold, there was great rejoicing from on high, and an angel...well you get the picture..What a quirky piece of... Brett8-)Edited by - x002548 on 07/09/2003 12:55:44Edited by - x002548 on 07/09/2003 12:56:29 |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-09 : 12:29:30
|
| There are quite a few options that require restarting of the SQL service. I'm surprised that you had to hit Apply though since hitting OK typically is all that is needed.Tara |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-09 : 12:57:42
|
| Hey, I don't know (but then SQL Scrub custom title is taken...)I did it about 5 different ways...it wasn't till I hit apply that it prompted me to restart the service so it could take affect...Brett8-) |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-09 : 13:38:45
|
| I really should get the name of scrub...I had closed EM on the server and connected through ny WS....Thought everything was ok...nope...tried to go to in to EM on the server...and got denied there..AAAAAAAAAAAAHHHHHHHHHHHHHHHHHHHHHHHHSCRUB BOY!!!Brett8-) |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-09 : 14:27:35
|
| OK, I got it this time I thinkI'm now back at my desktop and have been able to connect, with the server "connected" to itself.I found that I had to go to settings to Control panel to find a setting called Licensing. I fixed it there.So what's a CPU License for. Properties on the server still are set to unlimited connections.What gives?And how does a connection pooling id fit in this mess?Brett8-) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-07-09 : 16:07:34
|
| This is for SQL 2k but maybe it applies to 7.0Run this to determine the maximum number of user connections that your system allows:SELECT @@MAX_CONNECTIONSThe setting is changed, again for SQL 2k but maybe it applies to 7.0, through sp_configure but only when show advanced options is set to 1. From BOL:"user connections is an advanced option. If you are using the sp_configure system stored procedure to change the setting, you can change user connections only when show advanced options is set to 1. The setting takes effect after stopping and restarting the server."Tara |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-07-09 : 16:32:21
|
| Yeah Tara, it's actually on the properties tab for the server. The default is 0 (meaning over a max of 32,000 connections)My problem was with the lisencing, which I found in the control panel.But I though if you had a cpu license (that's what's checked) then it didn't matter.Anyway, I'm connected. Just have to do some more backgroubd.Thanks for you interest.Been to the corrall lately?Could use your opinion...Brett8-) |
|
|
|
|
SQL Server 7.0 - Max Users Exceeded