October 1, 2016 at 2:26 am
My query is whether SQL server license is required for the WEB server & for the application server ?
Or is it required only for the database server.
Regards.
Ashok Makil
October 1, 2016 at 5:40 am
ashok.makil (10/1/2016)
My query is whether SQL server license is required for the WEB server & for the application server ?Or is it required only for the database server.
Regards.
Ashok Makil
It's required wherever it is installed.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
October 2, 2016 at 11:39 am
I assume you mean you have a web server that talks to an application server that talks to a database server. Is that correct?
You need a license for SQL Server as the database server. If this is a public application, meaning people not in your AD domain that access the web and app servers to connect to SQL Server, then you need a per core processor license for SQL Server. The number of logins to SQL Server don't matter.
If you have a web app and all the clients that use it are known to your organization, you can either do client access licenses, one for each device/user or a CPU, per core processor license.
October 2, 2016 at 10:26 pm
I assume you mean you have a web server that talks to an application server that talks to a database server. Is that correct?
Steve, Your undertsanding is correct. Thanks for the reply. Further, can I add another instance of a database for a different application using the same license that I have purchased ?
Ashok.
October 3, 2016 at 10:56 am
You have to be clear about what the terms mean.
An instance is an installation of SQL Server, running on a host (Windows, or at some point, Linux). This instance can have multiple databases.
Each instance is licensed independently. The processor licenses get confusing when you have virtual hosts, as the edition of SQL Server will determine whether you license the virtual processors or physical ones, however, each instance needs licensing.
If you provide hardware and edition details, I can help.
If you have a database on Windows physical host, SQL01, then you need to license the processors (or get CALs, as I've explained). This allows you to have as many databases as you want.
If you install SQL Server again on the same host (named instance), AFAIK, you can do this under the same processor licenses.
If you want a second SQL Server elsewhere, with a copy of the same database for DR, reporting, etc., and you use this in any way. Any query, any checks, then you must license that instance separately.
October 4, 2016 at 12:33 am
thanks for the clarification.
We have an instance of SQL server 2012 running in a virtualised environ. We have bought core license for SQL server. There is currently one database that is used. My query is, if we can create another database here using the existing license.
Ashok.
October 4, 2016 at 2:05 am
You license SQL per server, not database.
So yes, you can add more databases to an existing licensed instance.
....you say virtual...is this also Web, or STD or ENT?
It gets tricky if you answer isn't ENT...
Ensure all hosts where this guest machine can fail-over to is licensed as well...
...........................
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
October 4, 2016 at 3:52 am
Its SQL server 2012 std...
October 5, 2016 at 7:32 am
Best to speak to your license partner, if Standard, you'll need to review the rules of licensing the host and additional vCores, or just the vCores of the VM by itself, it depends.
Too little info provided to make an accurate assumption.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply