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 1300 255 990 > On 12 Aug 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 > > 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. -- 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.
