Can't See Database In SQL 2005 MSE

I just upgraded from SQL 7 to SQL 2005 (Express) on my development machine,
and am having some trouble seeing my database. The database is functioning,
and I'm able to access the data through my front end (MS Access). Also, if I
open my copy of EM from SQL 7, I can see the database listed there, and can
open tables and so forth. But when I open Management Studio Express, all I
see listed are System Databases.

When I installed 2005 I selected the option to allow multiple instances of
SQL Server (thus, my server is "D10\SQLEXPRESS" instead of just the machine
name "D10"). I really don't need that, and I should have just gone with the
default instance. I'm wondering if that has anything to do with not being
able to see my database.

So my questions are:

1) How can see my database in MSE?

2) Is there any harm to using EM from SQL 7?

3) Can I restore my setup to just use the default instance, instead of
allowing named instances (or is there a real advantage to allowing named
instances of the server)?

Thanks so much!

Neil

hi Neil,
Neil wrote:
> ...
> So my questions are:
> 1) How can see my database in MSE?

I can think you did not upgrade your SQL Server 7.0 instance to SQLExpress
2005.. you just installed a named instance of it.. thus, your SQL Server 7.0
database still is on it.. you can back it up and restore it on the
SQLExpress instance..

>
> 2) Is there any harm to using EM from SQL 7?
EM (both 7.0 and 2000) can not handle and can not connect to SQL Server
2005..

> 3) Can I restore my setup to just use the default instance, instead of
> allowing named instances (or is there a real advantage to allowing
> named instances of the server)?
to see wether you are entitled to just upgrade your SQL Server 7.0 instance
to a SQLExpress 2005 one you have to check the upgrade matrix as proposed in
http://msdn.microsoft.com/en-us/library/ms143393(SQL.90).aspx ..
but you can (if you like) for sure uninstall SQL Server 7.0 and install a
fresh default instance of SQLExpress 2005, removing then the named instance
you already installed..

> When I installed 2005 I selected the option to allow multiple
> instances of SQL Server (thus, my server is "D10\SQLEXPRESS" instead
> of just the machine name "D10"). I really don't need that, and I
> should have just gone with the default instance
it's not in these terms.. you do not have to install the "multipli instances
option" as there is not such an option.. up to SQL Server 2000 you can, if
you like, install many of them (usually up to 16 but this limit depends on
the edition and, of course, on your machine power).. so you just installed a
named instance and there's no problem with it..
regards and happy new year
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://www.hotelsole.com
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
--------- remove DMO to reply