On the server that the database is being restored too, add the user that CF has permission to use to that database and you're done.
Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 On Wed, Aug 12, 2015 at 3:11 PM, Charlie Arehart <charlie_li...@carehart.org > wrote: > Hey Claude, here’s good news: what has happened to you is not at all > uncommon, and there is a solution. It’s just not at all obvious. > > While you’re right that the backup and restore has created the “same” > database with the “same” users on the new machine, the fact is that to SQL > Server, they are not “the same” users. There’s an essence of the identity > which is NOT equal, even though the usernames and passwords are the same, > and that’s why CF (or anything, really) can’t login using the “same > credentials” > > So what you can do is run a script (a system storedproc) that fixes that, > called > sp_change_users_login. It has a few variations. All you need is one form. > Here’s a simple walkthru of using it: > > > http://dbadiaries.com/using-sp_change_users_login-to-fix-sql-server-orphaned-users > > This has a nice visual layout but doesn’t really focus on the “why” you > need to do this (the issue I discuss above). For that, you could see this > explanation: > > > http://tim-stanley.com/post/how-to-restore-a-sql-user-after-a-sql-database-restore/ > > Or see this MS document, which also explains it and then offers this > sp_Change_users_login as one of a few alternative solutions you could > consider for this situation: > > https://support.microsoft.com/en-us/kb/168001 > > > But let’s see what else Andrew may have had to offer as well. > > /charlie > -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To unsubscribe from this group and stop receiving emails from it, send an email to cfaussie+unsubscr...@googlegroups.com. To post to this group, send email to cfaussie@googlegroups.com. Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/d/optout.
