Sharepoint Integrated Mode License


Does SSRS 2012 Sharepoint Integrated Mode install requires a SQL Server license?  
These are the General Licensing Terms for Server Product installs. Item 1 states that you must assign the license to a single server. So if the SSRS component was installed on a separate server to the database engine then it will also need a SQL Server license. Server Licenses

You have the rights below for each server you properly license.

·     You must assign each license to a single Server.

·     One license is required for every two Physical Processors on the Server.

·     For Standard licenses, you may use one Running Instance of server software in the Physical OSE and, for each license assigned, one Running Instance in up to two Virtual OSEs on the Licensed Server.

·     For Standard licenses, if all permitted Virtual OSE Instances are used, you may use the Instance in the Physical OSE only to host and manage the Virtual OSEs.

·     For Datacenter licenses, the number of Virtual OSEs is unlimited, and use in the Physical OSE is not limited to hosting and management.

·     Provided that, prior to repartitioning, each hardware partition is fully licensed, and, subsequent to repartitioning, the total number of licenses and Physical Processors remains the same, license reassignment is permitted anytime (i) Physical Processors are reallocated from one licensed hardware partition to another, (ii) two or more partitions are created from one licensed hardware partition, or (iii) one partition is created from two or more licensed hardware partitions.

·     You may use additional software listed in Appendix 3 in conjunction with your use of server software.·     As a one-time alternative to assigning base CALs per user or per device, a number of base CALs may be dedicated to an Instance of the server software on a single Server (per server mode) to permit up to the same number of users or devices to concurrently  access that Instance.

For more details refer:

Comments

Post a Comment

Popular posts from this blog

Calculating Age of the person in T-SQL

One of common calculations, we have to do in ETL is calculating age of the person from the date attribute And this is how I have calculated Age of the person. Select BirthDate , CASE             WHEN Month ( GetDate ()) < Month ( c . [BirthDate] )                 THEN DateDiff ( yy , c . [BirthDate] , GetDate ()) - 1             WHEN Month ( GetDate ()) = Month ( c . [BirthDate] )             AND Day ( GetDate ()) < Day ( c . [BirthDate] )                 THEN DateDiff ( yy , c . [BirthDate] , GetDate ()) - 1             ELSE DateDiff ( yy , c . [BirthDate] , GetDate ())         END AS [Age]               from [dbo] . [DimCustomer] c               order by BirthDate I am sure, there would be other better ways to do this and would love to hear, of how you have calculated age of the person
Read more

How to Troubleshoot Subscription issue in Reporting Services

Tips on troubleshooting Subscription issue in Reporting Services 1 – Look at the Reporting Services Log File Error Message from Log File: Email Provider has no server or pickup directory specified, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;   ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: Email Provider has no server or pickup directory specified, Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ;   INFO: Notification 20f7b482-eb74-4b51-9e53-9f0609034e72 completed.  Success: False, Status: Failure writing file Startup :  The report server has encountered a configuration error. , DeliveryExtension: Report Server FileShare, Report: Startup, .......      2 - Run below query against ReportServer Database and this 
Read more

MDX Queries - Current Day - Month and Year

Problem: Query to get Current Day - Month and Year in MDX /* MDX for retrieving current Year */ WITH MEMBER [Measures].[Current Year] AS     VBAMDX. Format (VBAMDX.Now(), "yyyy" ) SELECT   {[Measures].[Current Year]} ON COLUMNS FROM [Analysis Services Tutorial]; /* Current Month */ WITH MEMBER [Measures].[Current Month] AS     VBAMDX. Format (VBAMDX.Now(), "MM" ) SELECT   {[Measures].[Current Month]} ON COLUMNS FROM [Analysis Services Tutorial]; /* MDX for retrieving current Date */ WITH MEMBER [Measures].[Current Date] AS     VBAMDX. Format (VBAMDX.Now(), "dd" ) SELECT   {[Measures].[Current Date]} ON COLUMNS FROM [Analysis Services Tutorial];
Read more