I am migrating a set of databases to a new SQL Server instance. Backing up and restoring the databases worked just fine, as did migrating logins with sp_help_revlogin however none of the permissions for the logins were preserved. Is there a way to migrate the permissions along with the logins?
asked Nov 24 '09 at 07:04 PM in Default
The permissions should be with the databases. Perhaps you've lost the association between the server logins and the database users. See if their SIDs are different. If so you can fix them with
answered Nov 24 '09 at 07:27 PM