Licensing in SQL Server

Posted on 2011-05-04
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

    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

    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

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
    Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
    This video discusses moving either the default database or any database to a new volume.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    729 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now