Hi All,

I have an ASP.NET 2.0 application designed using Forms authentication.

When I moved the project from the development environment to production environemt I can no longer successfully validate user's credentials. Using the SQL Profiler I was able to see that the aspnet_Membership_GetPasswordWithFormat stored procedure is the cause of the problem:

--development
exec dbo.aspnet_Membership_GetPasswordWithFormat 
@ApplicationName=N'/Merch',@UserName=N'danielm',@UpdateLastLoginActivityDate=1,@CurrentTimeUtc='2008-08-05 18:41:39:430'
--production
exec dbo.aspnet_Membership_GetPasswordWithFormat 
@ApplicationName=N'/',@UserName=N'danielm',@UpdateLastLoginActivityDate=1,@CurrentTimeUtc='2008-08-05 18:45:17:710'

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?

Thank you,
Daniel