If you follow the example described here:
Everything will work just fone for about 5 minutes. then you will find that users cannot log into the DotNetNuke website anymore.
The reason is that when they log in, the DotNetNuke core stored procedure, UpdateUser, gets stuck in a loop until it times out.
When I reproduce this on my test machine, I can go into SQL Enterprise Manager and the following query will run until you stop it:
exec dbo.UpdateUser @UserID=2,@PortalID=0,@FirstName=N'Administrator',@LastName=N'Account',@Email=N'Webmaster@ADefwebserver.com',@DisplayName=N'Administrator Account',@UpdatePassword=0,@Authorised=1,@RefreshRoles=0,@LastIPAddress=N'::1',@IsDeleted=0,@LastModifiedByUserID=-1
The question of course is why? I can only suspsct it is that perhaps something odd is happening because the MachineKey was copied into the remote site and some bad parameters are now being passed to the stored procedure?
I am trying to investigate this, but any ideas are appreciated!