Tech Talk Archive
-
HOW TO: Enable SSRS Report Builder to Launch from a SharePoint Site when Using Forms Authentication
When your Reporting Services instance is integrated with a SharePoint product or technology and you use Forms authentication, you might encounter the following error when you launch Report Builder: "Cannot Start Application. Cannot continue. The application is improperly formatted. Contact the vendor for assistance." To workaround this issue, you must exclude the Report Builder files from requiring authentication by updating the Web.config file and enabling anonymous access. -
FIX: SQL Server Stuck in Single User Mode – And You Can’t Get In
Ever get a SQL Server 2008 database stuck in SINGLE_USER_MODE, then find you can't maintenance it, access it, and even SP_WHO2 fails? Maybe you dropped it into SINGLE_USER_MODE to perform a DBCC CHECKDB type of repair, then tried to access it again and voila...you're not the only one in the database. This could happen in a number of scenarios, but a typical one in a SharePoint environment is the SEARCH database. -
Advanced String Building Expressions in SharePoint Workflows with SQL
Building a Dynamic String in a SharePoint workflow is severely limiting. You can only use placeholders, and forget about expressions like LEFT(), RIGHT(), REPLACE() or SUBSTRING(). It’s almost worthless. Not anymore. Not only can we do that now, but we can apply any T-SQL script or procedure in a SharePoint workflow. -
FIX: An unexpected error has occurred, Web Parts Maintenance Page
Fix for the following error: An unexpected error has occurred. Web Parts Maintenance Page: If you have permission, you can use this page to temporarily close Web Parts or remove personal settings. For more information, contact your site administrator. -
HOW TO: Add Report Server Content Types to a Library (Reporting Services in SharePoint Integrated Mode)
Reporting Services provides predefined content types that are used to manage shared data source (.rsds) files, report models (.smdl), and Report Builder report definition (.rdl) files. Adding a Report Builder Report, Report Model, and Report Data Source content type to a library enables the New command so that you can create new documents of that type. -
Monitor and Analyze Multiple SSRS Instances with SQLScrubs
The following article details how to analyze and monitor multiple SQL Reporting Services instances with SQLScrubs. SQLScrubs Community Edition is available for free and can be found on CodePlex. All extraction for instance related data is managed by the SSIS package and stored in the datawarehouse provided. You can analyze in your own reports, enhance some of the free reports to do this for you, or simply upgrade to the Premium Edition of SCRUBS for SQL Server 2008 which provides over 15 additional reports with built-in analysis by instance. -
Enable SQL Report Builder Anonymous Access for SSRS
Enabling Anonymous Access to Report Builder Application Files Report Builder uses ClickOnce technology to download and install application files on the client computer. When it starts on the client computer, the ClickOnce application launcher will make a request for additional application files on the report server computer. If the report server is configured for Basic authentication, the ClickOnce application launcher will fail the authentication check because it does not support Basic authentication. -
FIX: rsItemNotFound – Report Builder Report Fails with The item ‘ModeName.smdl’ cannot be found.
Fix for Reporting Services Report Builder An error has occurred during report processing. (rsProcessingAborted) The item 'Folder/ModelName.smdl' cannot be found. -
Reporting Services 2008 URL Parameters for SharePoint Integrated Mode
Passing URL report parameters directly to a rep… Read the rest -
FIX: Me.Value Does Not Work in Reporting Services 2008 (SSRS)
Me.Value will not work in SQL Server Reporting S… Read the rest
