Create login with password hash

06 Jun 2022 11573 views 0 minutes to read Contributors g.praamstra@sqltreeo.com Servicedesk SQLTreeo Danny Riebeek vincent@sqltreeo.com Riebeek


		
			T-SQL
			
Transact-SQL
			
			SELECT 'IF(SUSER_ID('+QUOTENAME(SL.name,'''')+') IS NULL)
BEGIN
CREATE LOGIN '+QUOTENAME(SL.name)+' WITH PASSWORD = '+CONVERT(NVARCHAR(MAX),SL.password_hash,1)+' HASHED, <br />SID = '+CONVERT(NVARCHAR(MAX),SL.sid,1)+'
END' 
FROM sys.sql_logins AS SL
WHERE name not like '##%##' and name <> 'sa'
order by name
			
				
					
				
					1
2
3
4
5
6
7
				
						SELECT 'IF(SUSER_ID('+QUOTENAME(SL.name,'''')+') IS NULL)
BEGIN
CREATE LOGIN '+QUOTENAME(SL.name)+' WITH PASSWORD = '+CONVERT(NVARCHAR(MAX),SL.password_hash,1)+' HASHED, <br />SID = '+CONVERT(NVARCHAR(MAX),SL.sid,1)+'
END' 
FROM sys.sql_logins AS SL
WHERE name not like '##%##' and name <> 'sa'
order by name

Create login with password hash

Stay up-to-date

Unsubscribe