northben's blog

Remote Web Workplace error 403 Forbidden

If you are getting an error "403 forbidden" when trying to access Remote Web Workplace (RWW), here are some settings to check. This if for systems running Microsoft Small Business Server 2003 (SBS).

  1. The correct Authentication Methods for the /Remote virtual directory security are:
    1. Enable anonymous access. Connect as the IUSR_<servername> account.
    2. Enable Integrated Windows Authentication.

Word 2007 Blogging

Microsoft Word 2007 can publish to a blog. It's pretty cool. In Drupal, activate the Blog-API module. In Word, click the round button in the corner, then choose Publish, Blog. The URL is http://www.yourwebsite.com/drupal/xmlrpc.php

Describe table in SQL Server 2005 - Equivalent of Oracle Describe command

Categories:

In Oracle, the describe command shows the metadata for a table in your SQL database. The equivalent command in Microsoft SQL Server 2005 (and 2008, probably) is sp_columns. Try using sp_columns
to find out the data type of each column, along with other useful information about your tables.

How to sync Mac Address Book with Exchange Contacts

In Leopard, it is possible to sync your Microsoft Exchange Contacts with the Address Book app. Here's how.

Outlook Error 0x8004011D when trying to send/receive, and Outlook will not connect to Exchange Server

Categories:

When Outlook is opened, it will not connect to the Exchange server. Instead, Outlook says "disconnected" in the lower right corner, and clicking "Send/Receive" shows error 0x8004011D in the Outlook Send/Receive window. One possible cause of this is if your Exchange/IIS server (both of mine are on the same machine) is using a self-signed SSL certificate.

Remove redeye when the automatic tools don't work

Categories:

Sometimes, a photo editing program (I use Corel's Paint Shop Pro) can not remove all of the red around a person's eye with the built-in red eye remover tool. You may end up with a red ring around the pupil of the eye. Here's how to remove all of the red eye.

Use the automatic tool to remove what you can. Then, switch to the pain brush tool, and set the blend mode to color. Use the eyedropper tool on the good, dark part of the eye, then use a small brush size and paint around the edge of the eye. Your eyes are beautiful! :)

Quickly find the current time in all US timezones

Categories:

If you want to know the current time in another city in the US, just google "time". At the top of the results, you will see the current time in a major city for each US timezone.

Example: http://www.google.com/search?q=time

You receive "Cannot create a connection to data source" when opening a report on SQL Server Reporting Services

Categories:

This error may be caused because of insufficient permissions to open the data source. Check the properties of the data source in the Reporting Services web interface. If it is set to use Windows Authentication, it is possible that the user does not have sufficient privileges to open the data source.

To resolve this problem, either grant the users permission to connect to the data source, or set a default username and password to connect to the data source.

This is the error that you may see:

Error 401 Accessing the Report Website

If you have Reporting Services, SQL and IIS installed on the same server, you may receive an HTTP error 401 that says, "The request failed with HTTP status 401: Unauthorized." The solution is to "Disable the loopback check" using regedit. Instructions are found on Microsoft KB 896861.

Importantly, you may receive this error regardless of which computer you are using to browse the report website.

Online Banking with Charles Schwab, Moneydance and OFX

To connect Moneydance to a Charles Schwab Bank account or Charles Schwab investment account, choose the respective institution name in the online setup, then enter the username that you use to log in to the website (schwab.com) and the first eight characters of the password. It is important to enter only the first eight characters of your password to connect. If you enter the full password, it will not work. Also, note that you are not providing your account number, but rather your website username.

Pages

Subscribe to RSS - northben's blog