I am using a login control with login information contained in SQL Server 2000. Works fine on my local machine.

When I upload to server and attempt to log in I get a message that:
"Your login attempt was not successful. Please try again."

So far I have done the following:

- changed connection string on server to state: Trusted_Connection=False
- added an applicationName attribute to my provider settings in web.config file both locally and on the server.
- verified that my aspnet_Application, aspnet_Membership and aspnet_Users tables are identical between local computer and server.

Appreciate any suggestions as to how to resolve. Thanks.