Category Archives: Security in SQL Server

User Mapping With ALTER USER

Posted on April 18, 2012 by

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

Posted on April 4, 2012 by

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?

Posted on April 20, 2010 by

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

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

Posted on October 22, 2009 by

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