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 -- 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.