Cannot See Database

I have installed SQL Server 2005 Beta 2 and attached a database which
was running on SQL Server 2000. On the local machine using server
management studio I can see all databases including the one I attached.
In SMS I have under Databases System Databases (containing Master tempdb
etc.), Database Snapshots, and the Database I attached.
I am trying to connect to that database from VS 2003 and I get an error
that it doesn't exist. When trying to make a connection object with the
wizard, I can connect to the server but only see the system databases in
the database combo box. My attached database does not appear there.
What am I missing?
HaimHi
Who is the owner of the DB, and do you have rights to the DB? SQL Server
2005 no longer shows objects that you do not have rights to.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"HIK" <haimkatz@.hotmail.com> wrote in message
news:%23wY6zoCbFHA.3684@.TK2MSFTNGP12.phx.gbl...
>I have installed SQL Server 2005 Beta 2 and attached a database which was
>running on SQL Server 2000. On the local machine using server management
>studio I can see all databases including the one I attached.
> In SMS I have under Databases System Databases (containing Master tempdb
> etc.), Database Snapshots, and the Database I attached.
> I am trying to connect to that database from VS 2003 and I get an error
> that it doesn't exist. When trying to make a connection object with the
> wizard, I can connect to the server but only see the system databases in
> the database combo box. My attached database does not appear there.
> What am I missing?
> Haim|||Thank you Mike. I cleaned up my users and logins and that did the trick.
Haim
Mike Epprecht (SQL MVP) wrote:
> Hi
> Who is the owner of the DB, and do you have rights to the DB? SQL Server
> 2005 no longer shows objects that you do not have rights to.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "HIK" <haimkatz@.hotmail.com> wrote in message
> news:%23wY6zoCbFHA.3684@.TK2MSFTNGP12.phx.gbl...
>
>
>