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 | 37 Comments

How to Transfer Logins from one SQL server instance to another SQL Server instance?


It is one of the common question, which we can expect during any SQL Server interview: “How should you transfer logins from one instance of SQL Server to another?” The answer is pretty simple, however, its very complicated as well. … Continue reading

Posted in Security in SQL Server | 6 Comments