Microsoft BI-Azure and Project Server Blogs

Understanding Kerberos and NTLM authentication in SQL Server Connections http://www.blogger.com/img/blank.gif

There are always several questions we face at customer sites on the licensing requirements for their Project Server implementation. It’s best to consult your local Microsoft Solution Sales Specialist (SSP) for the details to ensure compliance. A common scenario we see customers are faced with is loading Project Server with ALL resources in the organization, whether work assignments exist or not, and have them available to perform work as it is assigned. An organization may likely consist of 10,000 people and only 1,200 active on projects at a time and would prefer to only have 1,200 Client Access License (CAL)s for the entire organization. This scenario is not allowed, however, Microsoft allows the CAL to be transferred (as a one off) after a 90 day period to a new user. The simple SQL script below provides a view of all the resources in the named instance you set through the @PUBLISHED_DB_NAME variable to have the discussion with the SSP. Key columns to review from the SQL output that...