• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.

Microsoft SQL Server Management Studio Express

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.
 
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.
 
You must log in or register to reply here.

Similar threads

q-quan
Resolved Windows Server 2025 - Plesk Obsidian 18.0.69 - msodbcsql17 dependency
Replies
11
Views
1K
iForced
I
E
Resolved Plesk Error : SQLSTATE[08S01]: [Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: An existing connection was forcibly closed by the remote host
Replies
2
Views
969
esfahanhost
E
T
Contribution [HOW-TO] Migration of Plesk roundcubemail to new server
Replies
2
Views
1K
ChristophRo
ChristophRo
P
Question Microsoft SQL Server 2022 support
Replies
1
Views
2K
IgorG
IgorG
S
Issue Need help: SQLSTATE[08001][Microsoft][ODBC Driver 18 for SQL Server]SSL Provider
Replies
5
Views
10K
samsam
S
Back
Top