27
Do I have SQL Server 2008 or SQL Server 2008 R2 installed?
How to identify your SQL Server version and edition
SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)
Version Components and Numbering
SQL Server 2008 R2 is a minor upgrade of SQL Server 2008. This means that it shares the same major version number with SQL Server 2008, and has an increment to the minor version. The product version for SQL Server 2008 R2 is 10.50.bbbb.rr. Compare this with the product version for SQL Server 2008 which is 10.0.bbbb.rr.
23
SSRS 2008 Security Item Level and System Level Role Definitions
In SSRS 2008 it appears you can no longer configure item-level role definitions and system-level role definitions like you used to be able to do in SSRS 2005 as shown in this screenshot from SSRS 2005.
This functionality to define roles still exists but you can no longer access it through the Report Manager website. To manage item-level and system-level role definitions you need to use SQL Server Management Studio and use it to connect to SSRS on your server. Once you do that you can create new system-level and item-level role definitions. Once those are created you can go back to report manager and utilize the defintions you created in SSMS.
System-Level Role Defintions…
Item-Level Role Definitions
Blogroll
@benmarch
- RT @MOJOmn: What Does A VC Mean When He Says Your Product Is “A Feature And Not A Company”? http://t.co/L6xxaiZW - you'll get no $
- RT @pclindeman: Interesting Read: How Companies Learn Your Secrets: http://t.co/YZ7x47VO
- Had a great first day at http://t.co/dKlmltdx. Looking forward to tomorrow!
- @BizDevTalk I'm at buyfun.com in North Mankato.
- @coreybuzzell Yep, first day. It was great. I think it was a good move.
Tag Cloud!
Knowledge Bomb
- January 2012 (2)
- December 2011 (1)
- May 2011 (1)
- February 2011 (2)
- September 2010 (1)
- August 2010 (2)
- June 2010 (1)
- May 2010 (1)
- April 2010 (10)
- March 2010 (1)