SQL Server 2012 Standard Edition Licensing Cost

We are upgrading to SQL Server Standard Edition 2012.  Our legacy applications use distributed queries.  We called our DBA and asked if we could have this turned on.  Our DBA informed us that if distributed queries is turned on then the model goes from CAL license to CORE license.   Since we have 16 cores, this is too much for us.  I have tried looking this up in Microsoft license cost website, but can't find anything that says this.  Anyone run into this?  Did your cost go up as well once you turned on distributed queries?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Kanti PrasadCommented:

This thread has similar discussion which can be of some help.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Vitor MontalvãoMSSQL Senior EngineerCommented:
I don't think so. MSDTC is the component that you need for Distributed Transactions and is to allow the SQL Server instances installed in the server to connect other databases, not only SQL Server databases as it can be Oracle ,Sybase, DB2, Informix, you name it.
yanci1179Author Commented:
Hi Kanti,

Am I understanding this correctly?

I see from your article that license model might change to core the more users you have.  
If distributed queries is opened, then we are not able to account for the number of users that have access to the database.   So if the number of users is undetermined, it’s  recommend to just go with CORE model.  Is that accurate?
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Vitor MontalvãoMSSQL Senior EngineerCommented:
What is your understanding of "distributed queries"?
As I said above, that means your SQL Server instance is allowed to run queries on other databases, so it's a connection from your SQL Server instance to other databases and not the opposite, so you should not count them as connections to your instance.
Here's the MSDN article about distributed queries.
yanci1179Author Commented:
I am aware that distributed queries are used to connect to other databases in different servers.

In my case, opening distributed queries on both servers, will cause more connections on the second server.  This is why the DBA is requiring us to go to the core model
Kanti PrasadCommented:

Yes if you cannot determine the approx size of users then the CORE route would be suggested.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.