Solved

How to determine what Hash Algorithm type is used when SQL logins are created via SSMS in SQL Server 2008?

Posted on 2016-07-25
2
28 Views
Last Modified: 2016-07-26
Heyas,

The question is as the above title: How does a DBA determine what Hash Algorithm type is used when SQL logins are created via SSMS in SQL Server 2008?

Any assistance is appreciated.

Thank you.
0
Comment
Question by:Zack
2 Comments
 
LVL 29

Accepted Solution

by:
Olaf Doschke earned 500 total points
ID: 41728910
If you create SQL Logins based on Windows accounts SQL Server does not store them at all, the Login process then is delegated to Active Directory and based on OS Login, which is done via NTLMv2 challenge-response authentication protocol.

For SQL Server users, the user data is found in master data and via LOGINPROPERTY():
SELECT name, LOGINPROPERTY(name,'PasswordHashAlgorithm')
FROM syslogins
WHERE password IS NOT NULL
ORDER BY name

Open in new window


0 means a SQL7.0, 1 and 2 are SHA-1 and SHA-2 respectively.
1
 

Author Closing Comment

by:Zack
ID: 41728914
Thank you for the information.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question