Troubleshooting SSL on SQL Server Issue – AT_KEYEXCHANGE is not set

It is one of the pre-requisites for the KEY-SPEC value of the SSL self-signed certificate to be set to 1, for it to be loaded to the SQL server. Due to the glitches during the creation of the certificate there may be scenarios arising where in this value might not be set to 1. If…

2

Capture successful logins: You may see many entries(high volume) when you create Audit for SUCCESSFUL_LOGIN_GROUP action group

  When you are auditing successful logins attempts using SUCCESSFUL_LOGIN_GROUP action group through SQL Audit, you will see that there will be too many entries in the audit file. You may see this behavior for successful logins when connections are made through SQL Server Management Studio. This occurs because for every successful login through SSMS…

0

INF: SQL Security – Restricting access to public on server/database objects, its implications and ownership chains

INF: SQL Security – Restricting access to public on server/database objects, its implications and ownership chains There are times when you need to harden the security of your SQL Server and prevent the public/guest users from having access to certain information like server or database level management views. This hardening is required due to company…


Did you know… When we rename a domain group in Active Directory, we can have some issues related to the login in SQL Server

Sometime back I got to work on an interesting issue related to the login on the SQL Server replication.  The Active Directory group we used to grant access to a snapshot publication does not show up in the Publication access list anymore when viewing the properties of the publication. However, the AD group does show…

1

Security considerations for SQL Server installation on Windows Server 2008

Did you know that Windows Server 2008 installation, by default, enables the Windows firewall to be ON just like Windows Vista. So there is a possibility that in the previous installations, you have not been using the Windows Firewall and disabled it for your day to day work. When you start working on this new…

1