Category Archives: Security in SQL Server

User Mapping With ALTER USER


Yesterday I was working with my colleague to help him with a user-mapping issue. He was migrating a database to SQL server 2008 R2 environment. He restored the database in the new environment from a recent backup and copied all the logins … Continue reading

Posted in How To, Just Learned, Security in SQL Server, SQL Server | Tagged , , , | 2 Comments

Last Password Change Time for SQL Login Account


Yesterday at work, I received an alert from Operations Manager (SCOM) that the password for the SQL Login account in one of instance is expired and need to be changed. While I checked the SQL Server Error Log for that instance, … Continue reading

Posted in How To, Just Learned, Security in SQL Server, SQL Server | Tagged , , | Leave a comment

How to enable sa Account in SQL Server?


When you install the SQL Server using Windows Authentication mode, by default, the “sa” account is disabled. Sometimes, due to users/customers request, you may need to enable the sa account. You need to change the authentication mode for SQL server … Continue reading

Posted in Security in SQL Server | 33 Comments