Enable Audit logs in MSSQL server with the steps below:
Open Microsoft SQL Server Management Studio
Login with SQL Server Authentication with username and password.
. Go to security tab and expand Audits.
If you can not expand Audit you need to add new Audit and enable it by right click.
Now need to expand server audit specification if not then need to add new server audit specification and enable it by right click.
Now logout and login again.