This blog post summarizes - Implement Role Based Security within an Intranet ASP.NET Web application.
You develop an ASP.NET 2.0 application locally using the new ASP.NET 2.0 Membership, Roles or Profile features. You create several new users and everything works fine.
You then copy the application to a remote server (or even another directory on your local server) and run the application. For some reason it appears that you are able to connect to your membership database just fine – but when you try to login it doesn’t let you. It doesn’t throw a connection error, but rather when you attempt to login you get an error message that says something like: “Login attempt unsuccessful, please try again.”
The reason this usually happens is because a membership (or roles or profile) provider has been added in the application’s web.config file – but without an applicationName attribute being specified.
Assume below that the applicationName in bold was missing:
type="System.Web.Security.SqlMembershipProvider, System.Web, Version=22.214.171.124, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
applicationName="/" <!-- Assume it to be missing -- >
When no applicationName attribute is configured, ASP.NET uses the Application Vroot Path within the web-server to automatically calculate the applicationName to use when adding data to an ASP.NET Application Service database.
To see this in action, you can open up your ASPNETDB database, and look within the aspnet_Applications table: See the first & second row.
Because I didn’t specify an “applicationName” attribute when I registered users within my application, it calculated the application name as /Security Cafe Site – Which is the name of Application Virtual Path under root.
Even this Will do –
This works fine when the application continues to run in the “/Security Cafe Site” application virtual path. But if it is copied to another location or server with a different virtual path - That is why you’ll get a “Login attempt unsuccessful, please try again.” message when you try to login.
Set the application name to the name of your WebSite name.
Hope this helps.