Just letting you know Charlie and Andrew its all sorted
I needed to set the user as a dbo NB: TrackingCentral is now a registered product & services provider for the National Disability Insurance Scheme, under the category of Assisted Technology Regards Claude Raiola Director TrackingCentral Pty. Ltd Free Call 1300 255 990 From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Samaris Sent: Wednesday, 12 August 2015 8:48 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] Cannot connect cfadmin datasourse to my latest sql database ??? Hi Charlie Tried but still no luck Is there a setting I can set when creating the backup and restore so when I restore it inherits the new servers user credentials ??? Interestingly I can access the base and the tables via enterprise studio as I can the other bases in the server I just cannot get the datasource to connect in cfadmin Claude Raiola SAMARIS Software www.SAMARIS.net <http://www.SAMARIS.net> 1300 255 990 On 12 Aug 2015, at 3:11 pm, Charlie Arehart <charlie_li...@carehart.org <mailto: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 From: cfaussie@googlegroups.com <mailto:cfaussie@googlegroups.com> [mailto:cfaussie@googlegroups.com] On Behalf Of Samaris Sent: Tuesday, August 11, 2015 10:46 PM To: cfaussie@googlegroups.com <mailto: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 <http://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 <mailto:cfaussie+unsubscr...@googlegroups.com> . To post to this group, send email to cfaussie@googlegroups.com <mailto:cfaussie@googlegroups.com> . Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/d/optout. -- 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 <mailto:cfaussie+unsubscr...@googlegroups.com> . To post to this group, send email to cfaussie@googlegroups.com <mailto:cfaussie@googlegroups.com> . Visit this group at http://groups.google.com/group/cfaussie. For more options, visit https://groups.google.com/d/optout. -- 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.
