Question regarding an EMR report server using SQL

clrlogic
clrlogic used Ask the Experts™
on
We are setting up a report server to be used with Nextgen EMR/EPM. On the main DB server we are using SQL standard x64 2008. On the new report server we are going to be using SQL standard 200 R2 x64. Every night the main DB is going to replicate to the report server. Is this a problem since they will be two different versions of SQL?

My next question is for licensing the SQL report server. Are we going to need to have seperate licenses for the report server or can we use the licenses we have for the main DB server?

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Replicating data from SQL 2008 to 2008 R2 will not be an issue at all.  SQL licensing is an extremely confusing beast.  Regardless of what someone on experts-exchange may say, It would be best to speak with Microsoft about your licensing question to make sure you get yourself covered.  I doubt the "a guy on an internet forum said I could do this" argument would hold up in court :)

Author

Commented:
Thank you for your reply and I also made a mistake in my question about licensing the SQL. Instead of licensing my question is more about CAL's. We are obviously still going to purchase SQL 2008 R2 but we want the CAL's to be interchangable between the DB and the report server. Do you still think we need to contact MS about this?

Thanks
Commented:
According to Microsoft "CALs are version and functionality specific. They must be the same version or later than the server software being accessed."

http://www.microsoftvolumelicensing.com/userights/ProductPage.aspx?pid=125

I would take that to mean that your 2008 CALs would not cover you for 2008 R2.  It wouldn't hurt to call and ask though.  There might be an exception in your case.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial