Browse database with Enterprise Manager

[7280]

Hi,
I have two sql users which have same permissions on two different instances.
On one instance a user can browse the databases from enterprise manager, while on the other it's only able to connect, browse on database shows no items.
What could be the difference?
I want to allow the user to see the databases where he is dbowner and where he has datareader permissions.

Thanks.

 

[mrdenny]

The server that isn't working has had the guest account removed from the databases.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[7280]

Thanks for the response.
Where can I see the guest user?
Under Security I'm not finding it on both systems.

Thanks again

 

[7280]

Please help. I don't know how to solve.
There's a guest user in all the databases.

Thanks.

 

[mrdenny]

How did you validate that there is a guest user in all the databases?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com