Licensing in SQL Server

Posted on 2011-05-04
Medium Priority
Last Modified: 2012-08-13
Hello experts;  

       I have two separate servers and planning on setting up merge replicaiton.  How many SQL Server license would I require one or two?

I understand that SQL Server 2005 offers three types of solutions for high-availability

(1) Faileover Clustering
(2) Database Mirroring
(3) Backup Log Shipping

In such an active passive high availability setup SQL Server 2005 licensing does not require you to  license the passive node...........

Would it work the same way for my situation?

Thank you
Question by:algotube

Author Comment

ID: 35693301
I understand that this is not a  high-availability situation so I believe that you would need two SQL Server Lincense
LVL 29

Accepted Solution

Paul Jackson earned 1000 total points
ID: 35693313
It depends...

If the subscriber sql server is to be used for failover purposes only, then you don't need a separate license.
If it is an active node that will be accessed by users you will need a license.


Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Suggested Courses

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question