Hi ,

I develop the website by attach the database on sql express. the connection string is :
Data Source=.\SQLEXPRESS;Database=DNNData;Integrated Security=True
I have set the password for administrator (admin) and hostmanager(host)

when I deploy it to other machine, I using the attachfile mode , the connection string is :
Data Source=.\SQLExpress;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True
the website works, but the I cannot login with the exists users, I can create new user and login with new user.
it works well on the new computer if I change the connection string back to old.

Please if anyone can help me how to keep the exists users when change the connection string .or how to create new admin or host user when change the string.

oops, that is so quick answer, 
Thank you very much Ian.

I am sorry that I have only receive the email that tolds me my post has been approved, but I did not receive the inform for your reply. 
and I waiting and check it today .

you are right , but not all , 
I am really just copy all files to the deploy machine when I do deploy , But it works well if I did not change the connectin string.

and if I change the connection string and change the attach way for database, it does not work even In same computer.

anyway, 
the problem is fixed by crack.
I have change the connection string, then , create a new user, 
then , open the database by other tools and change the password and passwordsalt fied for admininistrato and host user with the value from new created user.
then , login to host and change the password.

to be frank, I think this is quite a silly way. it is quite welcome if you can show me a better way