>As you can see the @ApplicationName parameter is empty on the production server and eventually the query is not able to validate any users. Again this is only a case when I run this application off of the production server.
>
>ANy ideas?
>
Check the web.config - you can specify the application name there. It's part of the SQL Server providers/membership section.
Take a look here, under "Configure ASP.NET Membership Settings", part 2 for a sample of what I'm talking about.
http://msdn.microsoft.com/en-us/library/ms998317.aspx