sqllogin user log in

k muthus 21 Reputation points
2022-03-07T11:13:21.19+00:00

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

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    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 comments

    Comments have been turned off. Learn more

  2. Tom Phillips 17,711 Reputation points
    2022-03-07T16:20:58.047+00:00

    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.

    Was this answer helpful?

    0 comments
  3. Olaf Helper 47,631 Reputation points
    2022-03-07T11:20:20.22+00:00

    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.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.