I have the following issue with SQL Server.
On my Windows Sever, SQL Server 2008 Express Edition is running. Now I have installed SQL Server 2008 Web Edition on the same server.
My problem is, when I log in using SQL Server Management Studio of the Web Edition instance, I am able to see, and access, all the databases there, including those created in the Express Edition, which is not what I want.
Is it possible to restrict visibility/accessibility of databases to just those related to the Web Edition when I log in using the Web Edition, and similar for the Express Edition?