In this post, I'm going to be looking at sp_change_users_login in order to fix SQL Server orphaned users as a continuation to a previous article. There I looked at a couple of ways to transfer logins from one SQL Server to another and touched upon the issue of the orphaned "security identifier" (SID). A typical scenario that arises is when the DBA quickly realises that the … [Read more...] about Using sp_change_users_login to fix SQL Server orphaned users
SQL Server Security
How to Transfer Logins to Another SQL Server or Instance
With any server migration, ideally you want things to run smoothly and re-creating SQL Server logins and passwords from scratch is not something you really want to or should be doing. I am currently involved in a complete server replacement for one of our SQL Server clusters. In this environment, mixed authentication is enabled. Back in the day when I was learning about … [Read more...] about How to Transfer Logins to Another SQL Server or Instance
Auditing SQL Server Logins
Auditing SQL Server logins is done by way of writing audit information to the SQL Server Logs found under "Management->SQL Server Logs" in Management Studio. In order to enable auditing of SQL Server logins, a simple operation needs to be performed by changing settings in the properties of the SQL Server. Auditing levels vary. It's possible to audit just failed logins, … [Read more...] about Auditing SQL Server Logins