Microsoft SQL Server Management Studio Express

[campisi]

Will Microsoft SQL Server Management Studio Express function correctly with Plesk 8.6?

http://www.microsoft.com/downloads/...AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

 

[sergius]

Will Microsoft SQL Server Management Studio Express function correctly with Plesk 8.6?

http://www.microsoft.com/downloads/...AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

Yep, it works properly.

 

[nieuwhier]

Hi,

Yes it works, but they are able to see(not use) all mssql databases on that server. I only want them to see there own databases. Is there a cure for that ?

Regards,
Michel.

 

[Amin Taheri]

yes there is a way.

First you have to create the DB and then create the user their user account in SQL. Then change the owner of the DB from SA to the sql user you created and map that user account to the dbo role of that db.

then when that user logs in they can only see their database.