SQL Reporting Services, SharePoint, FBA = No Subscription Joy?
Get the following error “ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user ‘fba:user@domain.com’ are insufficient for performing this operation.” with a Reporting Services Subscription in Sharepoint / FBA mode?
Read on for the fix.
Puzzling Situations: Using MultiValue Parameters with Stored Procedures in SSRS
Why developers go WTF? with SSRS MultiValue Parameters + SQL Stored Procedures, and how to fix that. A T-SQL Tuesday joint. This months theme: Puzzling Situations.
HOW TO: Force Users To Select a Perspective From a Report Model in Report Builder
In SQL Server 2005 Reporting Services you can Increase your Model reusability and development productivity by creating Perspectives. You then limit the usage of a Model only to those Perspectives, rather than the huge monster views.
FIX: Cannot Install SQL Server 2008 – Fails with Error Reboot Required
Having a problem installing SQL Server 2008 and keep failing the pre-install check that tells you a reboot is required? Read the fix.
FIX: SSIS Script Component Error “The value is too large to fit in the column data area of the buffer”
SSIS Error “The value is too large to fit in the column data area of the buffer.” and Microsoft.SqlServer.Dts.Pipeline.DoesNotFitBufferException. Fix
FIX: View in Windows Explorer Action Does Not Work in SharePoint Document Library
On a Windows Server 2008 build, the following failed:
- save directly from Word into a SharePoint Document Library
- UNC Path to SharePoint does not work
FIX: Strange Refresh of Parameters in SQL Reporting Services
Do you get odd parameter and page refreshes in SSRS, even when no dependencies exist? If so, read this article for a quick workaround.
FIX: Sign in as a Different User in SharePoint 401 Unauthorized Error Fail
You login to Sharepoint (WSS or MOSS), then click the “Sign in as a different user” drop down. You attempt to login using the same account with the same privileges (obviously) and for your efforts, you get a 401 Unauthorized message. What?
HOW TO: Uninstall SQL Server Embedded (from SharePoint or WSS)
Uninstall SQL Server Embedded edition How To.


