Move SQL Database to new server, user transfers but can't assign permissions
Posted on 2011-03-09
I have a database I'm developing an ASP application on a staging server for that I now need to move to a production server. I detached the database and copied over to the new server (SQL express 2008). The database uses SQL Authentication to access via the ODBC connection and the original user transfers over from the old server when I look under the users of the database. However it appears the password doesn't follow. Under the users of the database there isn't a way to change/modify the user and it doesn't show as a user under the SQL server.
If I try and add the user under the server it will not allow me to map the user to the database with an error that the user already exists. What and how do I need to make this work? Sorry I don't have that much experience with SQL server (obviously).