Post reply

SSRS Licensing Question...

  • August 25, 2009 at 9:25 pm

    #134404

    I have a hot stand-by server that has all of my mirrored dbs. It's just sitting there doing almost nothing. If I want to run SSRS on it do I have to pay for any licensing?

    Thanks

    Dave

  • August 25, 2009 at 9:37 pm

    #1044647

    Once you start using it for production purposes while the active databases are on the primary server, yes.

  • August 27, 2009 at 10:19 am

    #1045667

    and of course, you cannot read the mirrors, you would have to take a Database Snapshot of each to report on it. (or some other copy).

    Tim White

  • August 27, 2009 at 1:46 pm

    #1045835

    Dave,

    As you pointed you have " a hot stand-by server that has all of my mirrored dbs", that means your server should have Standard or Enterprise Edition installed, i.e. you paid already for Sql Server license. In this case you probably do not need additional license for SSRS.

  • August 27, 2009 at 2:02 pm

    #1045850

    I can purchase a single license of SQL Server 2005 Enterprise Edition and install it on two servers as long as the second server is a "passive" failover, either as a cluster or mirrored databases. Once you start doing active work, then you need to pay for additional licenses.

    Please note, this is my understanding of the SQL Server licensing and may not be completely accurate. I have read and re-read the licensing so many times parts of it may have been blurred.

  • August 27, 2009 at 3:18 pm

    #1045928

    I believe as soon as you take a Snapshot of your mirrors or have any DB in a readable state, (whether you are using them or not) you are now responsible for licensing that server.

    Tim White

  • August 27, 2009 at 3:22 pm

    #1045931

    2 Tim 3:16 (8/27/2009)

    I believe as soon as you take a Snapshot of your mirrors or have any DB in a readable state, (whether you are using them or not) you are now responsible for licensing that server.

    Which is what I originally stated earlier.

  • August 27, 2009 at 3:28 pm

    #1045937

    yes, you did, and more eloquently than I. sorry to reiterate, sorry to reiterate.

    Tim White

  • August 27, 2009 at 7:16 pm

    #1046009

    Thanks for your replies. I found the definitive answer here...

    http://www.microsoft.com/sqlserver/2005/en/us/Special-Considerations.aspx#passive

    Thanks

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply