Microsoft SQL Server 2012 Licensing Model Changes

The long and short of it is there are several changes in the way SQL 2012 will be offered from a licensing and product stand point. The Three Main Versions of SQL Server   Server + CAL Core-Based Enterprise Business Intelligence (NEW) Standard   What you need to know about Core based Licensing Microsoft is moving towards licensing by computer power for Enterprise Customers Core Pack are sold in units of 2 with a minimum of 4 required per physical server. With physical server licensing you must license all of the cores of the server. Note for Enterprise Customers: Check … Continue reading Microsoft SQL Server 2012 Licensing Model Changes

SQL Reporting Services: How to configure the service account

To configure the Report Server service account Start the Reporting Services Configuration manager and connect to the report server. On the Service Account page, select the option that describes the type of account you want to use. For recommendations about which account type to specify, see Configuring the Report Server Service Account. If you selected a Windows user account, specify the new account and password. The account cannot be more than 20 characters. If the report server is deployed in a network that supports Kerberos authentication, you must register the report server Service Principal Name (SPN) with the domain user … Continue reading SQL Reporting Services: How to configure the service account

SQL Server Workgroup Edition When to buy Processor vs. User CALs

It might seem like magic when trying to figure out how to license SQL Server. I put together the following chart which uses Canadian OEM pricing. This is for Workgroup Edition. It shows the methodology to find the break even point. You can use this methodology in other regions and with other versions of SQL Server. The break even point is at 25 users for 1 processor and 50 users for 2 processors. Let me know how this works out for you. Jeff Loucks Senior Strategic Architect | Winrox  | 425-577-7377 IAMCP Canada | President | 800-783-6410 IAMCP International | … Continue reading SQL Server Workgroup Edition When to buy Processor vs. User CALs

SQL Server – How to Determine Which Version

To determine which version of Microsoft SQL Server is running, connect to SQL Server by using SQL Server Management Studio, and then run the following Transact-SQL statement. For SQL 2008, 2005, 2000: SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’) The following results are returned: The product version (for example, 10.0.1600.22) The product level (for example, RTM) The edition (for example, Enterprise) For example, the results resemble the following. 10.0.1600.22 RTM Enterprise Edition The following table lists the Sqlservr.exe version number. Release Sqlservr.exe SQL Server 2008 RTM 2007.100.1600.0 SQL Server 2008 Service Pack 1 2007.100.2531.0 SQL Server 2005 RTM 2005.90.1399 SQL Server … Continue reading SQL Server – How to Determine Which Version

SQL Server Downgrade rights

Every now and then you try to dig up the information regarding downgrade rights that come with your software. This post shows paths to downgrade SQL Server. Source: SQL Server Licensing Guide. Jeff LoucksAvailable Technology