hello,

looking at your previous post, I presume that you have created a production and a testdatabase and that you do a restore to a testdatabase but that it doesn't allow the authenticated user to logon to the testdatabase, as sunjiulu suggest this is because the ssid's of the sql-accounts do not match,

in another post, it is discribed how to copy users from one server to another, see this link on another sql-forum for a way to copy the users so that your app will also work on the other database.

link : http://blogs.techrepublic.com.com/howdoi/?p=140&tag=nl.e138

with kind regards,