Tag: security

• Scripting All Logins on a SQL Server Instance

  

  2014-04-14 - General, Queries, Security

  Scripting all logins on a SQL Server instance can be helpful e.g. when setting up a test or development environment. Read on to see an example query for just this purpose.

  [more…]

• How to Re-Create a Login with only a Hashed Password

  

  2014-04-13 - General, Security

  To re-create a login on a different SQL Server instance while preserving the password you can use the CREATE LOGIN statement with the hashed password. Read on for a detailed explanation.

  [more…]

• How to Fix Orphaned Users in SQL Server

  

  2014-04-11 - General, Security

  To access a database in SQL Server, a login needs to have an associated user in that database. Read on to see how that association is implemented and what you need to do to repair it if it breaks.

  [more…]

• LOGINPROPERTY – Getting to know your SQL Logins even more

  

  2014-04-07 - DMVs & CVs, General, Security, Security

  LOGINPROPERTY is a SQL Server catalog function that can be used to query a total of twelve properties for SQL Logins not even revealed by the sys.sql_logins catalog view. Read on to find out how to use LOGINPROPERTY and which properties it can return.

  [more…]

• sys.sql_logins – Getting to know your SQL Logins

  

  2014-04-06 - DMVs & CVs, General, Security, Security

  The sys.sql_logins catalog view can be used to retrieve additional information on SQL Logins that is not included in the sys.server_principals catalog view. Read on to find out what additional information is revealed by this catalog view.

  [more…]