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: Oldest
  1. 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 No comments

  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 No comments

  3. 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

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.