Attached DB and SQL Express: Now you see it, Now you don't!!!

After installing SQL Express 2005, I attached a DB of mine, with success.

I can see it from the lagacy enterprise manager, and if I launch the query analyzer fromm within SQL Ent. Manager that DB appear in the DB pane list ans THAT IS FINE.

Now when I launch the Query Analyzer directly from Windows, the attached DB doesn't appear. Same when I try to create an ODBC DataSource pointing to that DB: Is DOESN'T APPEAR and THAT IS NOT FINE!!!

Anybody have a clue?

Thanks in advanceCan you still use the database in Query Analyzer or osql? (What I'm trying to understand if this is a UI issue or something else).

Do you have SQL Server 2000 installed on the same machine (since you have older tools)? While it is a supported scenario (both SQL Server 2000 and 2005 on the same machine), there may be interaction between installed components that affect how the information is displayed in tools.

Boris.|||I have the exact same problem my sqlexpress db shows up in the

Enterprise manager and in the new Management Studio Express. It

does not however show up when I create an ODBC data source. I can

type in the machine name and the server name and it works.|||It sounds like you are using SQL2K tools against SQL 2005 Express edition, try using SQL Server Management Studio and Query Editor instead.