Error 4064 Return When User Connects via SSMS

Views – 605

Using the DAC (Dedicated Admin Connection) in SQL Server

From Kendra’s blog: There’s always a catch. You many need to get firewall ports opened as well, depending on your environment and…

SQL Server Audit: Resources

I am doing some research on how to implement auditing of schema and security changes and will use this post to track notes…

Log-shipping Logins Roles and Rights

Per the MSDN article below, accounts used to perform log-shipping tasks must be a member of the ‘sysadmin’ server role group: “The log-shipping…

Enabling and Disabling SQL Logins

Here is some simple T-SQL to enable or disable a SQL login account:

Views – 535

SQL Server Roles

SQL Server-level Roles • SysAdmin: Allows users to perform any activity on the server. • ServerAdmin: Permits users to manage configuration options on…