June 2, 2009 at 6:41 am
Hello,
Our IT dept is assigned to upgrade SQL 2000 to SQL 2008 Server next month. Server, Storage and Memory are pretty okay... but I am stuck in SQL 2008 Licenses. I am trying to get a quote from Software Resellers but I am now all confused.
Basically, We got 2 Servers for our Web Site (1 for Front End which is IIS installed, 1 for Backend where I am going to upgrade to SQL 2008 [sql 2000 installed at the moment]).
Which version shall I buy for SQL 2008?
1. CAL license version (or)
2. 1 Processor Version
I can go for 1 processor version which is easy and simple BUT price is expensive, nearly £5,000 so that I am trying to use CAL license version.
Here is how we coding in our ASP/Web application, we use web config file to open SQL connection from our Front End Server using 'sa'. Web user have their own user name and password to login to our webiste. We keep user name and login details in our Tables.
Connection is only come from Front End Server, Which mean I do need only 1 CAL License for SQL Server 2008?
Do I need to worry about how many people are connect to our web site?
I do need help ASAP.
Thanks.
Leo
June 2, 2009 at 7:26 pm
Leo (6/2/2009)
Here is how we coding in our ASP/Web application, we use web config file to open SQL connection from our Front End Server using 'sa'.Do I need to worry about how many people are connect to our web site?
I think your biggest, immediate problem is that you are using SA to connect to your db. I'd be worrying that one of your users will figure this out and pillage your db. With SA access, I can set myself up to do anything, including formatting your drive.
Now, to answer your question, each potential different web user needs a license. IMO, you'd be better off going for the processor license over the CAL. Unless this is a very private web site where you will only have a known number of users accessing the data...
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
June 3, 2009 at 6:03 am
I'll second Wayne. Your scenario need a processor license definitely. Even though it seems that only one connection type is being used, it's the amount of end-user / device connected that count.
In other term, if you were to use CAL model instead and for instance you would have bought 10 CAL, then only 10 people using your web site would be legally allowed to connect at the same time, which in most case is not what you would want.
As for your sa, again setting security permission might seems long to do but in the long run it is far better. At least use another account (login) and give that account dbo right to that db while working to implement a more granular security model. It will at least narrow damage on the db only, not everything on the server.
October 2, 2009 at 10:42 am
SQL Server 2008 Standard License + Software Assurance Only. The license was applied to a 180-day trial version. Correctly, the machine that has SQL Server is for internal access only.
What happens if more than one connection (from a unique) is made to SQL Server that doesn't have any type of CAL?
I asked because I forgot to purchase a User CAL and I will have to submit paperwork to justify one. Right now only one connection is made to SQL Server from behind our firewall. My manager is leery of buying the processor license.
October 2, 2009 at 2:43 pm
akilah.mcintyre (10/2/2009)
What happens if more than one connection (from a unique) is made to SQL Server that doesn't have any type of CAL?
Number of connections is irrelevant. It is the number of users (or devices) that matter if you buy CALs. In other words, count the number of people who use your application(s).
http://www.microsoft.com/sqlserver/2008/en/us/licensing.aspx
October 2, 2009 at 3:24 pm
If your web sites are internet facing, you either need per processor licensing or you may want to look at the web version of SQL Server.
October 6, 2009 at 2:35 am
Or using Express Edition of your database is not that big (less than 4 gb).
N 56°04'39.16"
E 12°55'05.25"
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply