May 22, 2006 at 6:56 am
Just started contract with small company with no IT staff but they have SQL Server 2000 and Small Business Server. Is there some way I tell what licensing they have for SQL Server 2000?
May 22, 2006 at 7:10 am
Norry
Go to Control Panel and open SQL Server 2000 Licensing Setup. That will tell you what was entered during the installation process. This will not necessarily correspond to reality since it's done on trust: you will need to ask management for documentary evidence if you want to be sure.
John
May 22, 2006 at 7:28 am
John. Thanks for your reply. However, when I check this out it has both 'per seat' at 0 and 'per processor' at 0, so it doesn't tell me much.
You say it is done 'on trust' - can you elaborate for me?
The management probably don't know how it was installed and the person who installed it is no longer on the scene.
The reason that I'm interested is that I want to make the SQL Server available over the internet and I wanted to check it was suitably licensed.
Norry
May 22, 2006 at 8:20 am
Norry
When I say "on trust", I mean that Microsoft just trusts you to enter the right information in the licensing box.
I think I'm right in saying that if you want to use SQL Server over the internet (and therefore have an unspecified number of connections) then you need per-processor licensing.
I'm guessing that if your organisation's procurement section doesn't have a record of the purchase of the licence (and you don't have a licensing agreement with Microsoft) then you probably aren't licensed at all.
Hope that helps
John
May 22, 2006 at 8:43 am
Hi John
Thanks again for your assistance.
Re not being licensed at all - you may be right, but I hope you're not! I'm just trying to find out how to find out! From what you are saying then I need to see a record of the purchase of the license, and if there isn't one then there isn't any other way to find out what license was purchased?
Your help is much appreciated
Kind regards
Norry
May 22, 2006 at 8:56 am
Norry
I think that's about the size of it.
John
May 22, 2006 at 9:12 am
John
That's pretty clear now, thanks.
Norry
May 22, 2006 at 11:19 pm
You say Small Business Server, what edition?
SBS 2003 Premium Edition comes with SQL Server 2000, and is licensed per seat, usually bundled with 5 User CALs, and the SBS CAL providing Windows / Exchange / SQL Server CALs.
This will not help for Internet access to SQL Server as you will need per processor license or spend a boat load of cash on the Unlimited CAL.
Andy
May 23, 2006 at 3:54 am
Hi Andy
Thanks for your interest. Much appreciated.
I know a little more about the SBS as the person who installed it is still around. Unfortunately it is the Standard Edition and so does not come with SQL Server licence.
I'm thinking it would be better to have separate server for SQL Server, another server for Web Server and the existing server with SBS as the existing domain controller. Is that the way to go?
I understand a per processor licence is going to be about £4k - sound about right?
I find the EULA a bit confusing anyway - in the SBS EULA (for Premium Edition) there is a bit about being able to have unauthenticated access by internet users. If the users access it via a web application and use an application role to access the SQL Server, does this count as unauthenticated?
Norry
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply