Where did my upsized Access DB go on SQL Server 2005

[Jamie]

I used the upsizing Wizard in Access to migrate a database (table structures
only) to SQL-Server 2005. The Wizard goes through the process without
warnings or errors. Then I go to the SSMS console and look under DATABASES,
but I don't see mine.

So, I go try it again, and the wizard says my database already exists and
changes the name (adds a "1" to the name), and completes without
warnings/errors.

Still, I can't see either one from SSMS. I'm obviously doing something
wrong, but can't figure it out.

Bueller? Anyone?

[Sylvain Lafontaine]

Maybe you have two instances of SQL-Server installed?
--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)

Post by Jamie
I used the upsizing Wizard in Access to migrate a database (table structures
only) to SQL-Server 2005. The Wizard goes through the process without
warnings or errors. Then I go to the SSMS console and look under DATABASES,
but I don't see mine.
So, I go try it again, and the wizard says my database already exists and
changes the name (adds a "1" to the name), and completes without
warnings/errors.
Still, I can't see either one from SSMS. I'm obviously doing something
wrong, but can't figure it out.
Bueller? Anyone?

[Mary Chipman [MSFT]]

If you're in SSMS, right-click on the Databases node in the explorer
window and select Refresh. The SSMS collections don't automatically
refresh themselves in the UI when new items are added.

--Mary

On Fri, 14 Aug 2009 14:31:01 -0700, Jamie

Post by Jamie
I used the upsizing Wizard in Access to migrate a database (table structures
only) to SQL-Server 2005. The Wizard goes through the process without
warnings or errors. Then I go to the SSMS console and look under DATABASES,
but I don't see mine.
So, I go try it again, and the wizard says my database already exists and
changes the name (adds a "1" to the name), and completes without
warnings/errors.
Still, I can't see either one from SSMS. I'm obviously doing something
wrong, but can't figure it out.
Bueller? Anyone?