App. Can't find database after a RESTORE -- sql server connect

Barb
10/27/2006 8:37:02 AM

Hi,

My application in another server can't find the SQLServer database
after a restore. The name of the DB is exactly the same! The application says
the the Target Database does not match destination database. My question is:
Is it possible that the reason comes from the database even if the name is
exacty the same?
Do I have to restart the database server?

Thanks!

Joe

Arnie Rowland
10/27/2006 11:59:57 AM

You don't have to 'restart' the server after a restore.

Can you connect to the database using Enterprise Mangler or Query Analyzer?

Please try connecting with EM and/or QA and post the entire error message.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf

[quoted text, click to view]

sql server connect : App. Can't find database after a RESTORE