Maybe I spoke too soon.
I have the cfadmin working and restored the backup of the farcryprod database to a database called farcrydev. I changed the datasource in the cfadmin for the dev server to point to farcrydev and that verified OK.
Started up the FarcryDev (Formerly called FarcryProd) web site on the dev server and now the error I'm getting is
<!-----------------------------------
CALL THE PROJECTS SERVER SPECIFIC VARIABLES
----------------------------------->
<cfinclude template="/farcry/projects/#application.projectDirectoryName#/config/_serverSpecificVars.cfm" />
<!--- Add Server Specific Request Scope files --->
<cfif directoryExists("#application.path.project#/config/#machineName#")>
<cfif fileExists("#application.path.project#/config/#machineName#/_serverSpecificVars.cfm")>
<cfinclude template="/farcry/projects/#application.projectDirectoryName#/config/#machineName#/_serverSpecificVars.cfm" />
</cfif>
</cfif>
<!-----------------------------------
INITIALISE THE REQUESTED PLUGINS
----------------------------------->
<cfif isDefined("application.plugins")>
<cfloop list="#application.plugins#" index="plugin">
<cfif fileExists("#application.path.plugins#/#plugin#/config/_serverSpecificVars.cfm")>
<cfinclude template="/farcry/plugins/#plugin#/config/_serverSpecificVars.cfm" />
</cfif>
</cfloop>
</cfif>
<!----------------------------------------
LOCALES
- Append Locales currently used in the project
----------------------------------------->
<cfswitch expression="#application.dbtype#">
<cfdefaultcase>
<cfquery datasource="#application.dsn#" name="qProfileLocales">
SELECT distinct(locale) as locale
from #application.dbowner#dmProfile
</cfquery>
I've bolded both lines but am not sure where to go next. The _serverSpecificVars.cfm file under Applications\Farcry\projects\linnbenton\config has no mention of FarcryProd anywhere.
I'm not sure where it's getting that it needs to connect to the old datasource name FarcryProd since I changed it in the CF admin under Data Sources.
I know I'll find it and there may be other places on the server that need to have the old FarcryProd or Alb-Farcry server name rooted out and changed before everything works.
Thanks for helping me out with this.