• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 401
  • Last Modified:

After upgrading from SQL 2008 to SQL 2008 R2 - Coldfusion databases don't work


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


  • 2
1 Solution
Som TripathiCommented:

Could you check SQL Server errorlog if there is connection failure error or something else.

If this is connectivity issue, you may reset the password or grant the permissions correctly. Sync the orphan user to the restored database.
bigmikey88Author Commented:
Hi Sommerville,

Thx for fast response...

I just deleted and then re-entered the "user name" for this database, and it now works in ColdFusion.

What do you think happened?  

Can you tell me how to "Sync the orphan user to the restored database"


bigmikey88Author Commented:
deleting and resetting the user fixed it


Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now