• Skip to main content
  • Skip to primary sidebar

DBA Diaries

Thoughts and experiences of a DBA working with SQL Server and MySQL

SQL Server Security

Using sp_change_users_login to fix SQL Server orphaned users

September 19, 2012 by Andy Hayes 17 Comments

sp_change_users_login report

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

How to Transfer Logins to Another SQL Server or Instance

September 15, 2012 by Andy Hayes 9 Comments

transfer logins between sql server servers or instances

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

June 30, 2012 by Andy Hayes 1 Comment

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

Primary Sidebar

Categories

  • All Articles (82)
  • Career Development (8)
  • MySQL Administration (18)
  • MySQL Performance (2)
  • SQL Server Administration (24)
  • SQL Server News (3)
  • SQL Server Performance (14)
  • SQL Server Security (3)
  • SQL Tips and Tricks (19)

Top 10 Popular Posts

  • Using sp_change_users_login to fix SQL Server orphaned users
  • MySQL SHOW USERS? – How to List All MySQL Users and Privileges
  • How to shrink tempdb
  • How to Transfer Logins to Another SQL Server or Instance
  • How to Delete Millions of Rows using T-SQL with Reduced Impact
  • T-SQL – How to Select Top N Rows for Each Group Using ROW_NUMBER()
  • New T-SQL features in SQL Server 2012 – OFFSET and FETCH
  • How to Kill All MySQL Processes For a Specific User
  • Using exec sp_who2 to help with SQL Server troubleshooting
  • How to move tempdb

Recent Posts

  • How to Setup MySQL Master Master Replication
  • How To Use SQL to Convert a STRING to an INT
  • How to set up MySQL Replication Tutorial
  • How to Use SQL CASE for Conditional Logic in Your SQL Queries
  • Using ISNULL in SQL Server to Replace NULL Values

Search

Connect

  • Twitter
  • Facebook
  • Google+
  • RSS

About

  • Cookie Policy
  • Disclaimer
  • About
Copyright ©