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 From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Samaris Sent: Tuesday, August 11, 2015 10:46 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] Cannot connect cfadmin datasourse to my latest sql database ??? What option are you referring to ?? I am able to re do the backup from the other server again so what options do i need to select to ensure when I restore on the new sever the new servers credentials are applied to the database I have restored from the old server Claude Raiola SAMARIS Software www.SAMARIS.net 1300 255 990 -- 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.
