SQL Server restricts IP, restricts users, and restricts ssms logins

SQL Server does not natively support restricting IP logons like MySQL does.

However, you can use the login trigger to implement it.

The following is a login trigger script that uses the login trigger to restrict user U_user_r to login using SSMs in the specified IP192.168.1.205:

CREATE TRIGGER [Tr_connection_limit]on all SERVER with EXECUTE as ' sa ' for logonasbeginif (EXISTS (SELECT 1 from Sys.dm_exec _sessions WHERE session_id = EVENTDATA (). Value (' (/event_instance/spid) [1] ', ' smallint ') and program_name like ' Microsoft SQL Server Management studio% ') and original_login () = ' U_user_r ' and (SELECT EVENTDATA (). Value (' (/event_ Instance/clienthost) [1] ', ' nvarchar () ') = ' 192.168.1.205 ')     ROLLBACK; END;

　　

SQL Server restricts IP, restricts users, and restricts ssms logins