Tag: Logins
This tag groups together all posts and articles related to SQL Server login management
-
Management Studio tip – A menu driven RunAs launcher batch file to open SSMS using multiple different login credentials
Tired of repeatedly launching SQL Server Management Studio (SSMS) with different Windows accounts? This post provides a lightweight, menu-driven batch file that lets you choose the required security context and open SSMS instantly. It’s a simple productivity tool that’s ideal for DBAs and developers who regularly work across multiple domains, environments, or privileged accounts.
-
dutyDBA Case Files #2 – Who dropped the tables and deleted/recreated stored procedures on the production database?
In this edition of dutyDBA case files, I show you how to investigate an unauthorised production database change to figure out who made the changes. This walks you through the process of recovering from the application outage, and identifying the root cause.
-
Audit SQL Server login activity with Extended Events: Who connected, when, from where, how often & verify connection pooling
This article provides you with a stored procedure that sets up an Extended Events session in SQL Server to track all the successful logins. It then summarises the data from the .XEL file into usable format, so you can see which logins are connecting from where, via which application, how often they connect, is connection…
-
How to identify and fix all logins with invalid default databases? (Error 4064)
This article shows you how to identify all those logins on your SQL Server instances which have an invalid default dataabase that no longer exists. This article also shows you how to manage this situatoin, and provides you a stored procedure that resolves the issue.
-
SQL Server Orphan Users and Logins – how to prevent and manage them, and the gotchas to be aware of
This article discusses what are SQL Server orphan user and logins, how to prevent users and logins getting orphanned, and how to manage them. It also talks about the security risks associated with orphan AD/Windows groups.
Latest Articles
