• 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!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    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.

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
2K
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
1K
esfahanhost
E
T
Contribution [HOW-TO] Migration of Plesk roundcubemail to new server
Replies
2
Views
2K
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
11K
samsam
S
Back
Top