Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
The_Sponge
Starting Member
4 Posts |
 Posted - 2006-02-09 : 14:37:28
|
| HiWe have an old SQL Server 7 Database. I believe it is set to per seat licensing of 30 licenses, but would like to know how I can find this out. Additionally how would one go about adding licenses. We also have SQL Server 2000 servers installed for which we have 100 CAL licenses, does this have any bearing on the SQL Server 7 licensing.Thanks |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2006-02-09 : 15:06:01
|
| You can't buy SQL 7 licenses anymore. I believe you have to get an SQL 2000 license and get written (or perhaps verbal) permission from Microsoft to "downgrade" the license for use with SQL 7. This may soon be the case for SQL 2000 too. I'd contact Microsoft if you're in doubt. They generally would not charge you for those type of questions, considering it's more of sales and not support.100 CAL license, eh? Would a per processor not have been cheaper?Have fun,Daniel, MCP, A+SQL Server DBAwww.dallasteam.com |
 |
|
|
The_Sponge
Starting Member
4 Posts |
Posted - 2006-02-09 : 15:27:48
|
| Can you tell me how I determine what my SQL server 7 licensing is and where I go to administer the licenses though Daniel ? |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2006-02-10 : 03:25:26
|
Finally one where I am about the only person on the board who can answer this. You don't know how long I've waited for this moment  On the server, if you go to Control Panel and Licensing you can do it from there with the Add licences button.You also get one shot at changing the licensing to per server should you decide to go down that route. The help file for licensing goves a bit more info.steve-----------Facts are meaningless. You could use facts to prove anything that's even remotely true! |
|
|
|
The_Sponge
Starting Member
4 Posts |
Posted - 2006-02-10 : 04:23:35
|
| lol elwoos ;-)Unfortunately, when I go to licensing, the add licensesand remove licenses button are disabled ;-( It is currently set to per seat license, but I don't know how many |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2006-02-10 : 05:20:14
|
| Can you go down the non-technical route and ask your finance/accounting dept how much they paid for the licence and if you can have a look at the paperwork which went with the purchase order???That might give the answer. |
|
|
|
The_Sponge
Starting Member
4 Posts |
Posted - 2006-02-10 : 05:55:30
|
| I forgot to say Daniel that the reason that we haven't gone per server for SQL 2000 is because we have 4 servers running SQL 2000>>Can you go down the non-technical route and ask your finance/accounting dept how much they paid for the licence and if you can have a look at the paperwork which went with the purchase order???<<They claim that it is 26 licenses, but I wanted to confirm it in SQL server itself.As an aside, does anyone know if the licensing is based upon a machine connecting to SQL server or a user connecting?I tried a test on my machine. There were 20 people in the office connected to the database and I connected another 20 times with different userids, so in effect there were 40 different users logged in - I did not get any problems SQL Server didn't reject any logins |
|
|
|
|
|
|
|
|
Determining SQL Server 7 Licensing