FIX: File Not Found on NewDwp.aspx in SharePoint when adding a web part
Receiving the following error in SharePoint or MOSS when you try to add a web part?
File Not Found. at System.Signature._GetSignature(SignatureStruct& signature, Void* pCorSig, Int32 cCorSig, IntPtr fieldHandle, IntPtr methodHandle, IntPtr declaringTypeHandle)
at System.Signature.GetSignature(SignatureStruct& signature, Void* pCorSig, Int32 cCorSig, RuntimeFieldHandle fieldHandle, RuntimeMethodHandle methodHandle, RuntimeTypeHandle declaringTypeHandle)
T-SQL Tuesday (Date/Time Tricks) – Project Time Reporting Hack in SSRS
A HOW TO illustrating a method to display project time data in SQL Reporting Services. While there is no native GANTT chart control in SSRS 2005/2008, you can still do this with a little creativity and determination.
Suppress Auto Update of MDX Parameter Datasets in Reporting Services 2008
With the MDX Query Designer in Reporting Services SSRS 2008 Report Designer and Report Builder 2.0, changing the main dataset overwrites the parameter datasets, which will kill any manual adjustments you’ve made. Bummer. But you can fix that.
FIX: Quick Launch Bar Navigation Missing From Web Part Pages in SharePoint
It’s rather disturbing that the Left Side Navigation (Quick Launch) by default, does not display on new web part pages created in SharePoint. There are a number of workarounds on the web which include hacking each newly created page, or hacking an existing document template.
FIX: Cannot connect to MICROSOFT##SSEE database
url=’http://blog.summitcloud.com/2009/12/fix-cannot-connect-to-microsoftssee-database/’;If you can’t connect to the MICROSOFT\SSEE instance for sharepoint, try the following:
Use “\\.\pipe\mssql$microsoft##ssee\sql\query” as your Server name in SQL server management Studio.
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.


