Browse by Tags

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

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

During the upgrade for the SQL Server 2000 to SQL Server 2005, the upgrade completes but with an error message related to the "Enforce Password Policy". The error message can be found in the setup log files but the server upgrade completes and you cans see that the instance is upgraded to the SQL Server...

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