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?

  • What do you mean with "created in the Express Edtion"? Is there an express edition installed on the same machine or not? – spaghettidba Jul 1 '16 at 8:23
  • Yes! Both MS SQL Server (Express and Web Edition) Installed. – Knight Rider Jul 1 '16 at 9:45

There is no way to prevent a client software from accessing a SQL Server instance when correct credentials are supplied.

SQL Server Management Studio is the same product for all editions (actually, starting from SQL Server 2016, it is a separate product which ships separately from the engine).

Your only option to prevent users from accessing one of the instances in your server is granting permissions only to the people entitled to access the data.

| improve this answer | |
  • Hi Thanks for the update. Could you please give me some information about this? Which type of permissions should I change? – Knight Rider Jul 1 '16 at 10:56
  • 1
    If a user doesn't have the right to connect to your instance, don't create a login for him. – spaghettidba Jul 1 '16 at 10:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.