: [cfaussie] Cannot connect cfadmin datasourse to my latest sql
database ???
Just letting you know Charlie and Andrew its all sorted
I needed to set the user as a dbo
--
You received this message because you are subscribed to the Google Groups
"cfaussie" group.
To unsubs
ussie@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 resto
or 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 1
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 Areh
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
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
When you restore from another SQL server, if that option is also selected
it will copy and recreate the user account that is on that SQL Server. The
best bet as Administrator is to add the User account on the server that is
going to have the restored database, to that database.
HTH
Regards,
Andre