To mimic a multi-SQL Server environment of one of our clients on a single server, I needed to link the SQL Server to itself. If found several suggestions by googling it, but only this one worked for me:

I use ULSViewer a lot when debugging SharePoint issues. One of the nicest features of the tool is to view the SharePoint log in real-time (and the fact that is works for both SP2007 and SP2010).

Last time I wanted to use the tool, I found that it was not parsing the SharePoint log in real-time. I was however able to open individual log files.As it turns out, ULSViewer is using *-????????-?????.log as a filter to parse the logs in real-time. I had some ‘older’ log files in the LOGS folder that were not formatted in the ULS format (from running powershell commands).Removing these files from the SharePoint Logs folder got ULSViewer real-time parsing working again.

I had a SharePoint designer workflow that send an email to a SharePoint group. In the History Log of the workflow, the follow message was logged:

The e-mail message cannot be sent. Make sure the outgoing e-mail settings for the server are configured correctly.

The outgoing email settings however were configure correctly (alerts and emails from other workflows were being send out).
There were actually two reasons why the emails weren’t being sent:The settings ‘Who can view the membership of the group?’ on the group was configured as ‘Group Members’
The workflow is executed in the context of the current user. If the user has no access to view group membership, the workflow won’t be able to expand the group.
You should configure this settings as ‘Everyone’The group had no permissions
The group should have at least ‘Read’ permission to the site. If the group has no permissions configured, you will receive the error as described above.

Drop folderIf you’re not using the build-in SMTP service, you need to configure SharePoint incoming mail to use a dropfolder. Also, SharePoint relies on the x-sender and x-receiver headers to process the mail. hMailServer does not add these messages, so these need to be added

Create a [dropfolder] and make sure the SharePoint Timer Service has read/write/modify access to it.