Additional SQL Server features and topics not covered by specific categories
ssms should be blocked how to do it
You simply can not block application to logon to SQL Server, if the user do have a valid SQL login.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
i need a help,
i need to have sql server account where this sql user should not user ssms .
ssms should be blocked how to do it
Additional SQL Server features and topics not covered by specific categories
ssms should be blocked how to do it
You simply can not block application to logon to SQL Server, if the user do have a valid SQL login.
You have asked the same question multiple times.
The answer to your question is: you can't. A login is to the SQL Server. Logins are not application specific, they are server specific.
"Users" should not have a access to an application login/password to the SQL Server. The way to restrict users from accessing SQL Server, is to keep the username/password secret or encrypted.
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
2 deleted commentsComments have been turned off. Learn more