Security – LincolnBlog.net

Copy Logins to another server with SIDs and passwords

Posted on 02/01/201602/04/2016 by Lincoln Bovee'

I often need to replicate logins to another SQL Server where the SID and password (for SQL login types, not Windows based) need…

Error 4064 Return When User Connects via SSMS

Posted on 11/19/2015 by Lincoln Bovee'

USE master;
GO

SELECT	name, dbname
	FROM syslogins
	WHERE dbname = 'MyDatabase'
	ORDER BY dbname

SELECT	name AS LoginName, default_database_name
	FROM sys.server_principals
	WHERE default_database_name IS NOT NULL
	ORDER BY default_database_name

USE master;

SELECT name, dbname

FROM syslogins

WHERE dbname = 'MyDatabase'

ORDER BY dbname

SELECT name AS LoginName, default_database_name

FROM sys.server_principals

WHERE default_database_name IS NOT NULL

ORDER BY default_database_name

Views – 2005

SQL Server Audit: Resources

Posted on 10/01/201408/25/2015 by Lincoln Bovee'

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

Syncing SQL logins and database user accounts across servers with SIDs

Posted on 04/22/201401/21/2019 by Lincoln Bovee'

Here is a good article on syncing SQL logins across servers with the same SIDS to log-shipped databases will propagate the correct access…

Log-shipping Logins Roles and Rights

Posted on 01/30/201401/21/2019 by Lincoln Bovee'

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

Posted on 01/30/201403/27/2014 by Lincoln Bovee'

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

-- Disable the login 
ALTER LOGIN [someLogin] DISABLE
GO

-- Enable the login
ALTER LOGIN [someLogin] ENABLE
GO

-- Disable the login

ALTER LOGIN [someLogin] DISABLE

-- Enable the login

ALTER LOGIN [someLogin] ENABLE

Views – 1814

SQL Server Roles

Posted on 01/09/201402/07/2014 by Lincoln Bovee'

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

LincolnBlog.net

…my observations in the world of SQL Server, PowerShell, .Net etc…

Category: Security