Problem with NetScaler Clientless Access And OWA

Had an issue, when after authenticating to the NetScaler, and then hitting the Email tab, The OWA login page came up. 

Even though OWA worked fine internally, and an Internal version of the Access Gateway worked fine too.

Watching a network capture showed that it kept trying to use my local machine account, and since my desktop at home was not part of the domain, it kept failing  using “MyDesktop\domainuser”

To Fix it, I switched from using SAMAccountName (me) to UserPrincipalName ( in my “LDAP Authentication Server”, that way the domain was included with the login token, and passed on to OWA.

That was it, now OWA works internally and extenally!!

Facebook Twitter Email Linkedin Digg Delicious

Error While Adding Email address to Outlook Profile

Had a very annoying issue when trying to add my exchange email address to my freshly re-installed/downgrade of Outlook 2010 to Outlook 2003 instance. Fortunate for me, the guys over at the solution to my exact problem. Delete Mapisvc.inf.

I’m not going to go into details, rather, im going to send you to the so you guys can see the full article and thank them for their hard work while you are at it

Facebook Twitter Email Linkedin Digg Delicious

Organizing your Exchange Mailbox Automatically

When it comes to exchange, I hate when my mailbox becomes slow.  This is something that I’m sure we all deal with.  Microsoft recommends that you keep 5000 items or less.  I got tired of manually organizing my Inbox, so what I did was create a VBA Macro for Outlook, that goes through a folder you select and sorts items out by month.

First, I manually take all the emails for a certain year and put them in a folder

Then I run the macro

Once its done, the organize form will disappear, and if you go look at your folders, they will be organized from January to December (look at screen shot #3) and the corresponding messages moved to them.


Now, the code:

Create a new form, to mimic this one

and then paste this code on the form

That’s the entire Organize Script.  You can use this code as is, or modify it to fit your own needs.



Facebook Twitter Email Linkedin Digg Delicious

Update SQL Table from the Values on Another Table

This is one of those…”So I can remember in the future” Posts

Two Tables

1) mydb with fields user_name, group_id, create_tmstmp, edit_tmstmp
2) users with fiels user_name, user_id, extension, manager, create_tmstmp, edit_tmstmp

Since the mydb table contains group information, and the users table contains user information, a group which is created for a single user gets updated with the same create timestamp as the user

Facebook Twitter Email Linkedin Digg Delicious

Business Data Connectivity Metadata Store is currently unavailable

I was trying to add some externals sources to a Sharepoint list and ran into the error “Business Data Connectivity Metadata Store is currently unavailable”.

I was getting this error in both SPD and the Web Interface. After looking through the Admin Panel, I noticed that the “Business Data Connectivity Service” was running under “Central Administration -> Services”, but, there was no “Business Data Connectivity Service Application” under “Central Administration -> Service Applications” (this is because I’m pretty sure I did not add the BDCS when i created the site, but it’s normally there by default)


Lastly, make sure that the newly created BDCS is associated (checked) with your Web Application by going to “Central Administration -> Manage Web Applications” and clicking on Service Connections

So after creating a new “BDCS”, the error went away.

Another way to fix this, just run the configuration wizard and it should create one for you.

Facebook Twitter Email Linkedin Digg Delicious

Convert a PKCS#12 file (pfx) containing a private key and certificates to PEM

Need to add an existing SSL Cert to Apache or some Linux Based Appliance?

It’s easy, in a few simple steps…

Using OpenSSL, issue these commands:

This will output a PEM file that contains both the certificate and the private key

You can add -nocerts to only output the private key or add -nokeys to only output the certificates.

This is how i create the separate files for Jboss, Using -nocerts and -nokeys is how I create separate files for Jboss and Apache

Facebook Twitter Email Linkedin Digg Delicious

Inserting Screen shots into Office 2010 Documents and Emails

Inserting screen shots into Office documents used to be a 2 or 3 or even 4 step process.  If you didn’t have one of those screen capture utilities, then you were left with using Alt+PrintScreen or Ctrl+PrintScreen, then pasting that into MS Paint, cropping out whatever area you wanted to include, copying that, and then pasting it into your email or word document, that’s just the way it is….until Office 2010

With Office 2010 you can use the new screen shot utility…

Under Word, or Excel, or Even While composing an email in outlook….From the Menu Ribbon Select Insert, then Pick Screen Shot

You get the option of selecting one of the windows that are visible, or you can pick the “Screen Clipping” option which allows you to pick a section of the screen


Now that’s what I call a cool feature.  Good Job Microsoft.

Facebook Twitter Email Linkedin Digg Delicious

How to Launch Crystal Server Reports Via URL and Include Parameters

So You have a report in your Crystal Server that you want to share or include in another site, well, im going to teach you how to use the OpenDoc URL to run the report.
Here is how it works

Let’s say you have a report called Invoices.rpt located in the “Asset Management” Folder

The report has a main report and a sub report.  The report takes 2 paramenters, PONumber for the main report, and CheckNUM for the subreport


You Only really need a few parameters, and they are:

  • iDocID
  • lsS”ParameterName”
  • promptOnRefresh


NOTE: I’m assuming that your crystal viewer is “Single Sign On”, we don’t need to or care to pass a user name and password, if it is not, your user will get prompted for his credentials.  I suggest you work on getting SSO working, as this makes the process quick and painless


How to get the Report ID


In order to get the report ID, right click the report and select properties



The ID is shown under the Report Title (this is the same as iDocID)



Now we need to get the Parameters that the report is prompting for


How to get the Report Parameters


Right Click on the Report, and Select View


It will take you to the report viewer, at which point it will prompt you for the parameters it needs



Note the names that it is prompting for.  The main report is prompting for “PoNumber” While the Subreport is prompting for “CheckNUM” (and the reason that we know it is a sub-report is because it is wrapped around in parenthesis)
Now that we know what parameters we need, is time to build our URL


How To build the Report URL


All report URLS will begin with http://mycrystalserverurl/OpenDocument/opendoc/openDocument.aspx?


If we visit this url, you will see that Crystal gives an error that says

obviously we need to let the viewer know which report to load, so that’s what the ID is for, so now if we go to  http://mycrystalserverurl/OpenDocument/opendoc/openDocument.aspx?idocid=9767 (9767 being the ID we gathered before)


We now get the same parameter prompt that we had above, but the Goal here is to automatically pass the parameters to the report, so that’s where the “lsS” variable comes in to play


By adding the parameter in the form of lsSPARAMETERNAME, we now see that the report only prompts for the parameter in the sub report http://mycrystalserverurl/OpenDocument/opendoc/openDocument.aspx?idocid=9767&lsSPONumber=2150


But simply adding lsSPARAMETERNAME  wont target the parameter in the sub-report.  In order to do that, you need to add something to the lsS variable.  It needs to be in the form of lsSPARAMETERNAME@SUBREPORTNAME.  Notice the “@” symbol, it is important to include it along with the name of the sub-report, otherwise crystal won’t know where to set the variable


So now, we have our complete URL that looks like this:



Notice that the name of the sub-report in the lsS variable must match whatever the name was in the parenthesis.  So now we have a url that once clicked, it will take you to the report viewer ready to view the report


But wait, what about promptOnRefresh, ah yes, well, that parameter is pretty self explanatory, but I will explain it anyway.  When you created your report, you made it to prompt you for the parameters which we pre-filled with the lsSVariableName, but If your user clicks on the refresh button, they will be prompted for the parameters again.  If you set promptOnRefresh to “0”, then even if the user hits the refresh button, they will not get prompted again for the parameters.  The report will always continue to use the original parameters that were passed to it in the URL.

Here is a sample URL with promptOnRefresh:


That’s all, now you are a Crystal Server URL reporting expert 🙂

Facebook Twitter Email Linkedin Digg Delicious

Error Adding Reports To Crystal Reports Server

So I was Trying to add reports to Crystal Reports Server through the CMC, and I was getting an error that was not letting me upload the reports.  Adding the report via InfoView did not work either, InfoView only gave you a “time out” error but I suspect in the background, it was the same as the error I was getting through the CMC

The Error Reads:

So of course, I check out the SAP support forums, and most questions, if not all questions that I found went unanswered and unresolved.  The SAP Notes (The Paid Support) were no help either.

After much troubleshooting, this is what I came up with to fix the issue:

  • Open up the report in Crystal Reports 
  • From the Menu pick File -> Page Setup
  • Select the check box that says “No Printer (Optimized for screen display)”

And that’s all there is to it, once you do that, “reportadd.exe” wont error out anymore.  I guess this is some issue with the Crystal Report File format, but whatever the case, this is a quick and painless fix for me.


Facebook Twitter Email Linkedin Digg Delicious

Moving Internet Explorer Favorites to the Network

I’ve been using this little trick ever since my early XP days and still using it with Windows 7, and was surprised that this wasn’t a more common tip/trick

This registry hack moves your IE Favorites off to the network (your home drive) and allows you to have your favorites follow you no matter which computer you are sitting at

The H:\ Drive is my network drive.  Move your Favorites folder from your Profile and to the Network drive, then change the registry keys bellow.

That’s it, any computer you log into, you must also edit the same keys to point to the network drive, but then again, you will never have to email yourself links.  (I’ve never tried this using Dropbox, but I bet it would work)

Yeah this post is not going to win any awards for innovation, but hey, who knows, it might just help someone out.

Facebook Twitter Email Linkedin Digg Delicious
Go to Top