InfoPath forms error - System.Net.WebException: The remote server returned an error: (401)

Brower based InfoPath forms making calls to webservices on same server giving:

System.Net.WebException: The remote server returned an error: (401) Unauthorized. Microsoft.Office.InfoPath.Server.SolutionLifetime.DataAdapterException: The remote server returned an error: (401) Unauthorized.

Solution was to disableloopbackcheck >> http://support.microsoft.com/kb/896861

VSS to TFS migration without local SQL Server Express

The VSSConverter is a handy tool if a little light on documentation. I was running into an issue with VSSConverter failing where there was no local instance of SQL Server Express.

The MSDN documentation shed no light. http://msdn.microsoft.com/en-us/library/ms253123%28v=vs.80%29.aspx

After a few moments reflection with a glass of my favourite tipple I resumed attack on this obstacle and discovered it is possible to enter a SQL parameter on the migration settings file as follows:-

<Source name="VSS">

      <VSSDatabase name="D..."></VSSDatabase>

      <UserMap name="..."></UserMap>

      <SQL Server="SQLServerHost" />

</Source>

Job done.

Changing port of existing web application

Two step procress.

First in Central Administration navigate to Application Management \ Configure Alternate Access Mappings

In the Alternate Access Mapping Collection dropdown select the required web application

Click Edit Public URLs

Change port as required in default and any other existing URLs

Then in IIS Manager

Select the site in the Connections pane

Click Bindings

Change port bindings as required

Note: This does not update the IIS bindings: "If you update the alternate access mapping URLs of a Web application, SharePoint Foundation 2010 does not automatically update the IIS bindings." (Technet). Therefore, you must also change the port in IIS.