"Database already connected" after moving database from one server to another

• Jelmer Dalstra

  SSC Rookie

  Points: 32

  More actions

  September 21, 2005 at 4:27 am

  #165615

  Hi,

  I moved some databases using detach-attach in the Enterprise Manager.

  Everything looked fine. Most of the applications working on the databases are connecting fine.

  But.. there's one application that gives me the errormessage "Database is already connected to the machine <machinename>" where it shows the machinename from where the database came from.

  I've a client-server application and a webportal-application running on this database. The client server application works fine. Th configuration of the portal gives the error message?

  Where does this information come from?

  Anyone any suggestions?

  Regards,

  Jelmer

   

   

   

   

   

• Rudyx - the Doctor

  SSC-Forever

  Points: 43695

  More actions

  September 22, 2005 at 3:07 pm

  #592416

  The information has to be 'cached' somewhere. Either the portal machine or the computer using the portal. There is no way the database on the old server could be accessed since detach will not work with any users connected to the database. Besides you've detached/moved/attached the database. So I think you've got an application issue on the portal side. Could it be that you need to stop/restart the COM objects ? Restart IIS ? Just grasping at straws because from a SQL perspective it seems you've performed everything corrrectly.

  RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

• Jelmer Dalstra

  SSC Rookie

  Points: 32

  More actions

  September 23, 2005 at 1:08 am

  #592495

  You're right. It's an application issue. There was a configuration tabble where information on connecting servers was stored. That's where the information came from.

  Thanks for the reply!

  Regards,

  Jelmer Dalstra