Sunday, February 19, 2012

About Purchasing MS SQL Server

I have never had to purchase the actual application along with licensing I
have just worked on and with it. This is my question. What would be the
best/cheapest license to get. I will be running only 1 database off of SQL
server with an existing web application that many people can use from a
website. I need to know which license I should order. The processor license
seems more for web based but do i need to get that one because it is so
expensive and we will be running 1 maybe 3 at the most databases off of it.
Or else could i just order 1 CAL license and save alot of money. But along
with that 1 license would more than one person be able to use the web
application at a time?
If you need any more information about our web application or anythign else
please just ask and i will reply back with the answer.
Thanks in advance,
Paul
"NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in message
news:4F8D7ED1-84DF-45E0-B992-4A6DEB74DF36@.microsoft.com...
>I have never had to purchase the actual application along with licensing I
> have just worked on and with it. This is my question. What would be the
> best/cheapest license to get. I will be running only 1 database off of
> SQL
> server with an existing web application that many people can use from a
> website. I need to know which license I should order. The processor
> license
> seems more for web based but do i need to get that one because it is so
> expensive and we will be running 1 maybe 3 at the most databases off of
> it.
> Or else could i just order 1 CAL license and save alot of money. But
> along
> with that 1 license would more than one person be able to use the web
> application at a time?
> If you need any more information about our web application or anythign
> else
> please just ask and i will reply back with the answer.
> Thanks in advance,
> Paul
http://www.microsoft.com/sql/howtobuy/default.asp
Rick Sawtell
MCT, MCSD, MCDBA
|||Yeah i have looked throughout microsofts website but it does not tell you
exactly what you need. Like it says Processor License is for more web based
things - but we only need MS SQL for one website's web application because it
is a new division of our company with a already existing web application.
That is teh only thing we will be using MS SQL for. So again my question is
do i need teh Procesor license or is there a cheaper road to take.
Thanks
Paul
"Rick Sawtell" wrote:

> "NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in message
> news:4F8D7ED1-84DF-45E0-B992-4A6DEB74DF36@.microsoft.com...
>
> http://www.microsoft.com/sql/howtobuy/default.asp
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
|||Yes i have been throughout the entire microsoft sql website, but it still
isnt too clear. My company just needs MS SQL Server for one web based
application for one site with one database. It is a new division of our
company and they have a pre-existing web application that needs MS SQL to run
its database. We will not use MS SQL for any other site.
Now for which license would be most cost effective.
The processor license says it is for web based, but is very costly. So my
question again is if there is another road I can take? Such as purchasing 1
CAL license, like i mentioned before, or some other option.
Thanks again
Paul
"Rick Sawtell" wrote:

> "NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in message
> news:4F8D7ED1-84DF-45E0-B992-4A6DEB74DF36@.microsoft.com...
>
> http://www.microsoft.com/sql/howtobuy/default.asp
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
|||> exactly what you need. Like it says Processor License is for more web
based
> things - but we only need MS SQL for one website's web application because
it
> is a new division of our company with a already existing web application.
> That is teh only thing we will be using MS SQL for.
You will need to provide a much more specific description of your business
needs. "using MS SQL" is pretty vague and ambiguous. Will your web site be
connecting to this database in response to user requests on your web site?
Or is it not tied directly to web site usage?
|||I do not know exactly what the web application does but i knwo it only uses
one user name and password to connect to the database. So there are not
multiple user names to access the database but there are multiple users that
will be using this webapplication at the same time. It has a login with user
name and password from a table in the database and then from there they have
there own personal things that only there user name and password can view.
So I guess the answer is yes our web site will be connecting to the database
in response to user requests on the website.
If there is any more information you need to know just please ask as this
isnt one of my specialties and never have had to deal with this before.
Thanks
Paul
"Aaron [SQL Server MVP]" wrote:

> based
> it
> You will need to provide a much more specific description of your business
> needs. "using MS SQL" is pretty vague and ambiguous. Will your web site be
> connecting to this database in response to user requests on your web site?
> Or is it not tied directly to web site usage?
>
>
|||> I do not know exactly what the web application does but i knwo it only
uses
> one user name and password to connect to the database.
Number of user names doesn't matter. Do you think I could get away with
purchasing one CAL and having everyone in the company just pretend they are
me? If you have anonymous access from a web site, and there could be 1 or
10 or 100 users connected to the database at any one time, you will need a
processor license, not a single CAL or 10 CALs or even 100 CALs.
Of course, I am not a licensing expert nor am I a lawyer. You're going to
be much better off if you contact a Microsoft licensing rep, describe them
in full detail your exact business usage, and they will tell you what you
will need.
If you don't care about being in compliance, then do what you want with
whatever justification you feel necessary, I guess <shrug>.
|||Look, read about the multiplexing on the same site. If you can not count
and clearly identify each user specifically and license each individually,
then you MUST purchase per processor. Sorry.
However, you may want to look into MSDE or the new SQL Server 2005 Express
Edition. Either of these may be better for your needs; however, these are
for very light-weight systems.
Sincerely,
Anthony Thomas

"NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in message
news:325A872B-E6E6-47E7-B18E-0C77D5325BC3@.microsoft.com...
Yes i have been throughout the entire microsoft sql website, but it still
isnt too clear. My company just needs MS SQL Server for one web based
application for one site with one database. It is a new division of our
company and they have a pre-existing web application that needs MS SQL to
run
its database. We will not use MS SQL for any other site.
Now for which license would be most cost effective.
The processor license says it is for web based, but is very costly. So my
question again is if there is another road I can take? Such as purchasing 1
CAL license, like i mentioned before, or some other option.
Thanks again
Paul
"Rick Sawtell" wrote:

> "NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
> news:4F8D7ED1-84DF-45E0-B992-4A6DEB74DF36@.microsoft.com...
I[vbcol=seagreen]
the
>
> http://www.microsoft.com/sql/howtobuy/default.asp
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
|||"NeedSimpleHelp" <NeedSimpleHelp@.discussions.microsoft.com> wrote in message
news:325A872B-E6E6-47E7-B18E-0C77D5325BC3@.microsoft.com...
> Yes i have been throughout the entire microsoft sql website, but it still
> isnt too clear. My company just needs MS SQL Server for one web based
> application for one site with one database. It is a new division of our
> company and they have a pre-existing web application that needs MS SQL to
run
> its database. We will not use MS SQL for any other site.
> Now for which license would be most cost effective.
> The processor license says it is for web based, but is very costly. So my
> question again is if there is another road I can take? Such as purchasing
1
> CAL license, like i mentioned before, or some other option.
You can use 1 CAL if you can positively ensure that a SINGLE USER (as in
HUMAN BEING) is using the database.
With a website, this is pretty dang rare. It doesn't matter if the WEBSITE
appears as a single connection or a single user. If you have multiple
people accessing the website (or even technically I believe mulitple 'bots'
using the website) you either need a CAL for EACH person (and they have to
connect non-anonymously) or you need a Processor license to allow an number
of unlimited connections.
I am NOT a MS license expert in any way though, so your best bet is to check
with them. Last thing you want is MS coming in and doing an audit and
finding you're in the wrong.

> Thanks again
> Paul
> "Rick Sawtell" wrote:

No comments:

Post a Comment