After upgrading from SQL 2008 to SQL 2008 R2 - Coldfusion databases don't work
Posted on 2011-04-24
I just upgraded my laptop from SQL 2008 to SQL 2008 R2 so I could use the R2 databases from my production server to do some development.
But now ColdFusion 9 throws errors when I try to use those restored databases.
Error: Error Executing Database Query
Databases that were not downloaded and restored to the lap top, i.e. the original databases on my laptop still work fine.
The only thing that does not work is the databases that I backed up on my production server and then restored on the laptop.
Any ideas what might be wrong?
Here are the steps I took:
Backed up databases on production server which runs SQL 2008 R2
Download to my laptop
Upgraded laptop from SQL2008 to SQL2008 R2
Restored R2 databases from production server - onto laptop
Tried to run ColdFusion pages - get errors for all those restored databases
SQL 2008 R2 management studio works fine. I can access all databases
It's just coldfusion is not able to access restored databases
I opened CF Admin and verified connection to all datasources