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

Posted on 2011-04-24
Last Modified: 2012-05-11

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


Question by:bigmikey88
    LVL 8

    Accepted Solution


    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.

    Author Comment

    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"



    Author Closing Comment

    deleting and resetting the user fixed it


    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Hi. There are several upload tutorials using jquery and coldfusion. I found a very interesting one here Upload Your Files using Jquery & ColdFusion and Preview them ( . I did keep the main js functions but made sever…
    I spent nearly three days trying to figure out how incorporate OAuth in Coldfusion for the Eventful API. Hopefully, this article will allow Coldfusion Programmers to buzz through the API when they need to. Basically, what this script does is authori…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now