Tag Archives: Security

Removing a SPN Entry

At times, we may require to remove a wrongly created SPN entry. The syntax for removing a SPN entry is: setspn.exe -D “SPN entry, which needs to be removed” “Service Account or Server Name” Over the weekend, I was working … Continue reading

Posted in SQL Server | Tagged , , , , , | Leave a comment

SPN Registration Failure Issue

While I was configuring my lab machine, I observed the SPN registration was failed on one of my server with the below error. The SQL Server Network Interface library could not register the Service Principal Name (SPN) [ MSSQLSvc/KRISHNA02.SKGLAB.LOCAL ] … Continue reading

Posted in Deployment, How To, Security in SQL Server, Setup LAB, SPN, SQL Server | Tagged , , , , | Leave a comment

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