How to prevent users from accessing SQL Server from any application or any login expect your main application & its login

The SQL Dude!

When a user who isn’t in the logon trigger exception list above tries to connect, they will get this error.

Cannot connect to SERVERNAME.



Changed database context to ‘master’.

Changed language setting to us_english.

(Microsoft SQL Server, )



View original post

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s