Membership and roles

I am having some trouble with the membership and roles system. The membership
tables are lying in a remote sql server. The problem is with portability.
Everything works well on my development machine. But if I move the application
to another machine and try to login to the system with the username and password
of a user which I created on my previous development machine it says it cant
recognize the user. But if I create a new user on that machine it is recognizing
that user.  In short it only recognizes user accounts created through that
particular machine only. What can be wrong here?

Please help

By default, membership / role provider uses the default connection string,
"localSQLServer".  I suspect the localSQLSerer connection string on
the production box is pointing to another SQL server.

I recommend you remove / add the localSQLServer connection string in the
web.config file.  eg.

<connectionStrings>
  <remove name="LocalSqlServer" />
  <add name="LocalSqlServer" connectionString="Data
Source=DBServerName;Integrated Security=false;Initial Catalog=DBName;User
ID=DBLogin;Password=DBPassword"
providerName="System.Data.SqlClient" />
</connectionStrings>