• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 476
  • Last Modified:

SQL Server Licensing

http://www.microsoft.com/sqlserver/2008/en/us/pricing.aspx

I need to install SQL Server 2008 R2 Standard Edition and replicate the data of 10 instances of SQL Server 2008 R2 Express. I will then have an application that will connect to the Standard Edition to generate reports.

What licenses will I need to purchase?
What is the Software Assurance for and is it required?
0
Thomasian
Asked:
Thomasian
  • 3
  • 2
  • 2
  • +1
1 Solution
 
Aaron TomoskySD-WAN SimplifiedCommented:
I think SQL express can only be a replication target, not a source.
0
 
ThomasianAuthor Commented:
I see. But if I will be connecting to the sql server express instances as linked server, will I need to purchase a license for each sql server express (CAL)?

And what is the software assurance for?
0
 
OP_ZaharinCommented:
- software assurance is basically a maintenance program for corporate customers to get software free upgrades to newer versions and other benefits during a multiyear contract: http://en.wikipedia.org/wiki/Microsoft_Software_Assurance

"if I will be connecting to the sql server express instances as linked server, will I need to purchase a license for each sql server express (CAL)"
- i might be wrong but my understanding if CAL is access license to the SQL Server itself. not from the SQL Server to other database. so i think you don't need an extra license for linking to the sql express server: http://www.microsoft.com/licensing/about-licensing/client-access-license.aspx
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
ThomasianAuthor Commented:
So in my case, I will only need 1 license for the Standard edition and 1 CAL for the application that will connect to the server. Is that correct?
0
 
OP_ZaharinCommented:
- to add, you won't be needing the Software Assurance unless you wanted the free upgrade which is unlikely happen regularly for SQL Server.

"I will only need 1 license for the Standard edition and 1 CAL for the application"
- just specify that you need the "Standard Edition with 1 CAL license". again, you can further confirmed this with the Microsoft product reseller/distributor of your region when you request for a quotation from them.
0
 
Alpesh PatelAssistant ConsultantCommented:
Replication is not part of Express version.
Express come with database engine only.
0
 
Aaron TomoskySD-WAN SimplifiedCommented:
That's niceand all that your sure about the exact product name, but can anyone agree or disagree with this statement:
SQL server express cannot be a replication host/source.

I don't think this entire setup will work.
0
 
Aaron TomoskySD-WAN SimplifiedCommented:
To clarify, I have never done replication with express but this is what ms has to say about it
http://msdn.microsoft.com/en-us/library/ms165686.aspx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now