For the time being I have not really time for blogging I'm afraid but will continue writing articles for the windowsecurity.com website.

I know many things are visible in the Microsoft Active Directory and tried a few things to investigate the things a standard user can see. If this is something for you, then take a look at the article – feedback and evaluation is welcome J

Active Directory information exposed to users?

When I search the internet for articles I stumbled on my own. Nothing wrong with that except that it was in Russian and with another author mentioned…

But as a service to you RSS subscribers I now present "Kerberos in a SharePoint Environment" in Russian also J

http://www.oszone.net/7392/Kerberos_Sharepoint

The third and final part of my troubleshooting Kerberos article is now published on Windowssecurity.com

Troubleshooting Kerberos in a SharePoint environment (Part 3)

Please rate the article if you read it

I needed to change my Shared Service Provider Administration website to a load balanced url and found this great post by Ram G. http://blogs.msdn.com/ramg/archive/2008/07/01/moving-ssp-admin-site.aspx

That does the trick fast and easy – just try avoid copy-pasting the code, just write it by hand J

The second part of my troubleshooting kerberos article is now published on Windowssecurity.com

Troubleshooting Kerberos in a SharePoint environment (Part 2)

Please rate the article if you read it J

On the web I finally found a solution to the dependent dynamic choice filter on a SharePoint list Item. It requires some custom code-project to implement and some companies might not allow this.

Say you want to have a category and the sub category filtered depending on the choice you made in the first multiple selection box.

You can find the solution on the SharePoint Snippets.com blog. DataDog first published his version here but this makes it possible to use any number of "Siblings".

Download and description: http://www.sharepointsnippets.com/post/2008/11/SharePoint-Cascading-Dropdown---Unlimited-siblings.aspx

Configuration example: http://www.sharepointsnippets.com/post/2009/01/Cascading-Dropdown---Configuration.aspx

I hope Microsoft will include this feature and filtered dropdown lookup boxes in the next version of SharePoint.

After I received Kerberos error messages and screenshots I started making an article series on Windowssecurity.com about a working environment. In this I started braking things one at a time and investigated what error-messages came from these – with screenshots, error logs and troubleshooting tools/techniques.

This can be used in SharePoint environments and also in other Kerberos troubleshooting tasks.

You can read part one of the series at Troubleshooting Kerberos in a SharePoint environment (Part 1) and the other parts are following soon.

I have updated my blog-post "Troubleshooting the Kerberos error KRB_AP_ERR_MODIFIED" with new details for SharePoint in IIS7 on Windows Server 2008.

Please visit this if you have this Kerberos error.

My project to make a complete backup of SharePoint with Windows Powershell (mostly used on WSS) just got support for Windows Server 2008 and Windows Vista. Also the deletion of old backups has been changed.

Visit the SPBackup project page on http://www.codeplex.com/spbackup

I attended a great session on Microsoft TechED 2008 IT Pro on ports and protocols from Martin Kearn and searched for his session slides (with no luck yet). I then stumbled across a blog post I missed from Liam Cleary (SharePoint MVP I also saw on the Ask-The-Experts stand) where he summarizes the session details and give out the links to Microsoft Knowledgebase articles.

Read the post and check out the overview tables of what to open up for in the Windows Firewall configuration

http://www.helloitsliam.com/archive/2008/11/11/sharepoint-%E2%80%93-ports-and-protocols.aspx?id=168

Hello everyone,

I am currently collecting error messages and if you have some please post them on this blog-post. Please describe your environment, what you are are trying to accomplish and the errors on the different servers. If you have errors and solutions that would be appreciated also J

Hope to see and solve some problems,

Thanks
Jesper

I got a new article published on www.WindowsSecurity.com about the security considerations of using Microsoft SharePoint to publish company information. Find out what to avoid and where to look for possible security breaches.

http://www.windowsecurity.com/articles/Sharepoint-Data-Security-Risks.html

I hope you will read it, rate it and give feedback

Thanks,
Jesper

Sometimes I need to check for duplicate E-mail addresses in my Sharepoint lists. In the beginning I looked for new items manually, but this will take….. a while now :o)

I came up with this script to report back if any address exists more than once:

This page gives you a chance to follow my community activities and will be updated periodically.

Forums

Being active on forums gives me the opportunity to help others and get the chance to learn something new also.

Online magazines

Blogs

Blogging can be a lifestyle – especially if you have something you just need to say to the group "Everyone"

Codeplex projects

Free coding-projects that helps everyone in the everyday challenges.

New features have been added to my Windows Powershell project SPListSync. You can now copy/synchronize from an existing SQL Server Database table to a Sharepoint list. Great if you have a customer database outside your Sharepoint-solution. New items can also be created using a new feature.

Check it out, and please give me feedback for good and bad J

http://www.codeplex.com/splistsync

Changes from 1.0

• Added possibility to synchronize from a SQL Database Server table
• Added feature to create new items in the destination list
• Small changes in script structure

Upgrade from 1.0
There are new settings in the XML-file, so please adjust your 1.0 configuration with the additional:

• <ParentSQLServer>
• <ParentSQLDatabase>
• <ParentSQLStatement>
• <CreateNewChilds>

If you have a Sharepoint list for companies and another for contacts how do you make sure every bit of information is up to date? This is a feature I wanted to have – and of course this should happen automatically.

First I thought of making automatic workflows with Microsoft Sharepoint Designer but it became difficult to keep track of the sites, lists, columns and different workflows for these. The obvious solution for after the SPBackup project was to make another Windows Powershell script to do this configured by a XML-file and scheduled by Windows Scheduled Tasks.

I made an example of this kind of cross-list updates below and you can download the latest version of SPListSync from CodePlex – the example XML-file provided can be used in the demonstration below

Sharepoint list-sync. with Powershell script: http://www.codeplex.com/splistsync

Sharepoint list-connections

Setup procedure

1. Create new address list for Companies:

1. Create new address list for Contacts

1. Create new column in the Contacts list for the Company link:

Add some sample companies, contacts and link these together.

1. Check Windows Powershell installation
   
   Make sure Windows Powershell is installed on the Sharepoint (WSS/MOSS) server. (Windows Server 2003 – download and install it from the Microsoft website. Windows Server 2008 – activate the feature through Server Manager.)
   
   If you do not sign your scripts, you can enable unsigned scripts in Windows Powershell with the command Set-ExecutionPolicy Unrestricted as shown here on the screenshot:

1. Check the Powershell script configuration XML file so that it fits your environment (see the documentation on CodePlex)
2. Run the script from the Powershell to test the synchronization
3. Schedule the script in Windows Scheduled tasks with the command:
   
   %windir%\system32\WindowsPowerShell\v1.0\powershell.exe -command "& C:\SPListSync\SPListSync.ps1

Hmmm, I suddenly got a problem with my VMware infrastructure client 2.5 on my Windows Vista 32-bit SP1: The program just exits or crashes with a memory error.

This happened when I:

• Selected a virtual machine
• Edited virtual machine settings
• Opened a console

I couldn't find any update or support-hits on this on VMware support site, and managed to solve the problem by copying libeay32.dll, ssleay32.dll to "%ProgramFiles%\VMware\Infrastructure\Virtual Infrastructure Client\Launcher". They can be found in the "%ProgramFiles%\\VMware\Infrastructure\Virtual Infrastructure Client\2.5" folder.

I have released a new version of SPBackup. One script to perform Sharepoint backups written in Windows Powershell.

Codeplex project: http://www.codeplex.com/spbackup

Important !
When using the <backupdestinationmaxkeepdays> remember that the script deletes ALL files on the backup location older than this number of days !

Changes from 1.0

• New catastrophic backup feature
• New procedure to keep the files on the backup destination for only a number of days
• Small changes in log-text