We help IT Professionals succeed at work.

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

415 Views
Last Modified: 2012-05-11
Hi,

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


Thx

Michael
Comment
Watch Question

Database Administrator
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

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"

thx

Michael

Author

Commented:
deleting and resetting the user fixed it

thx
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.