jetlounge

the minty fresh blog that whitens your teeth!

Hot Off the Grill

  • 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...
  • How to Enable 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...
  • Suppress Auto Update of MDX Parameter Datasets in Reporting Services 2008

    With the MDX Query Designer in SSRS 2008 Report Designer and Report Builder 2.0, changing the main dataset overwrites the parameter datasets, which will kill any manual adjustments made. Bummer. The hack to fix is to add a SuppressAutoUpdate =true to the parameter dataset: < Query > < DataSourceName > DataSource1 </ DataSourceName >...
  • HOW TO: Uninstall Windows Live Messenger

    Can't uninstall from Add/Remove Programs and it's no longer listed in Add/Remove Windows Componenents. To uninstall, go to Start > Run : msiexec /x {0AAA9C97-74D4-47CE-B089-0B147EF3553C}
  • FIX: Cannot connect to MICROSOFT##SSEE database

    If you can't connect to the MICROSFT\SSEE instance for sharepoint, try the following: Use " \\.\pipe\mssql$microsoft##ssee\sql\query " as your Server name in SQL server management Studio.
  • FIX: Sign in as a Different User in SharePoint 401 Unauthorized Error Fail

    The problem: 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? The fix: DON'T USE THE SAME ACCOUNT Seems rather intuitive, although the error message...
  • HOW TO: Uninstall SQL Server Embedded (from SharePoint or WSS)

    So you installed WSS or MOSS and let it install SQL Server Embedded by default. Then you upgraded to SQL Standard, Enterprise or maybe you ran the uninstall for SharePoint and realized that the SQL Express database wasn't removed. Here's how to remove it from the Run command: (on 32-bit platforms) msiexec /x {CEB5780F-1A70-44A9-850F-DE6C4F6AA8FB...
  • "The Attribute Key Cannot Be Found" When Trying to Deploy an SSAS Cube

    Whn trying to deploy an Analysis Services cube from BIDS, you might get an error that states "The attribute key cannot be found" and "The record was skipped because the attribute key was not found" In a real "duh" moment I realized that this was simply due to fact the some key relationships between facts and dimensions...
  • FIX: An unexpected error has occurred, Web Parts Maintenance Page

    I received this error on a web part page that used the SQL Server Reporting Services native web parts for Report Browsing and report Viewing. Every time I attempted to "connect" the Viewer control to the Browser, I was kicked out to an error page with the following error message: An unexpected error has occurred. Web Parts Maintenance Page...
  • FIX: VMWare Server Causes Host to Blue Screen When You Start Up the Guest

    When you startup the guest in VMWare Server and it throws a BSOD (Blue Screen of Death) with a STOP 0x000000D9 , it may be a simple fix to correct. The following worked for me on a Windoes XP Pro machine: Click Start > Run . Type regedit and press Enter. Browse to the following entry: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager...
  • Add Custom Folder to "Look In" or "My Places" in Visual Studio

    When you click Open Project in Visual Studio 2005, you're presented with 3 basic folders to traverse: Desktop My Projects My Computer It always bugged me that My Documents was not displayed, nor was it easy to get a new custom folder onto the shortcut bar. In Microsoft Office land, you can add to the My Places bar fairly simply. Click Open document...
  • Add a Yahoo Email Address Alias To Your Account

    With the new Yahoo! Mail interface it might be difficult to find the 'Add an Email Alias' Link. If you go through Mail Options, then select Accounts, you're only presented with an option to link another outside mail account, like a work POP mail account. But what if you just want another mail account from Yahoo!, like an alias to send spammy...
  • FIX: Font Rendering in Firefox Not Crisp

    I was bothered that the font rendering was crunchy in FireFox as compared to Internet Explorer (IE). IE uses ClearType by default which is enhanced on an LCD display (like my laptop). Firefox is much faster than IE for me, but the crunchy fonts make me cringe. Note that ClearType will smooth the edges, and too much of a good thing can be bad..it might...
  • FIOS Router Password

    By default, the Actiontec Router MI424-WR supplied by Verizon FIOS has the following credentials: By default, the IP address to access the router is 192.168.1.1 ID: admin Password: password or password1 If the tech who installed the equipment changed the password, you can always reset the device. To reset hold down the reset pinhole with a paperclip...
  • FIX: SSIS Script Component Error "The value is too large to fit in the column data area of the buffer"

    Received an error in an SSIS Package with a Script Transformation. The error was "The value is too large to fit in the column data area of the buffer." and Microsoft.SqlServer.Dts.Pipeline.DoesNotFitBufferException. The Script Component in the Data Flow was taking a large column of data (about 180 characters in width) and parsing it to multiple...

Powered by Community Server (Non-Commercial Edition), by Telligent Systems