Licensing in SQL Server

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
algotubeAsked:
Who is Participating?
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.

 
algotubeAuthor Commented:
I understand that this is not a  high-availability situation so I believe that you would need two SQL Server Lincense
0
 
Paul JacksonSoftware EngineerCommented:
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.

0

Experts Exchange Solution brought to you by ConnectWise

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
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.

All Courses

From novice to tech pro — start learning today.