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, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 On Wed, Aug 12, 2015 at 11:34 AM, <rai...@ozemail.com.au> wrote: > Hi I have multiple databases sitting on the one sql server > > > > In CF admin I cannot connect to my latest database that I have backed up > and restored from a different server v > > > > The error message I get is > > > > Connection verification failed for data source: samaris1 > java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC > Driver][SQLServer]Cannot open database "4303" requested by the login. The > login failed. > The root cause was that: java.sql.SQLNonTransientConnectionException: > [Macromedia][SQLServer JDBC Driver][SQLServer]Cannot open database "4303" > requested by the login. The login failed. > > > > When I edit one of the other datasources in cfadmin and simply change the > name of the database to 4303 I get the same error message as above despite > the fact that the username and password for each of the databases are the > same given they are sitting on the same sql server > > > > OR have I missed something in my understanding of how the above works ?? > > > > I welcome your assistance > > > > > > > > > > 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 > > > > [image: TrackingCentral_Logo] > > > > > > -- > 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.
