Sql Server script to find installation date, time and Authentication mode


 SELECT
    createdate AS InstallationDate
    ,CASE SERVERPROPERTY('IsIntegratedSecurityOnly')  
        WHEN 1 THEN 'Windows Authentication' 
        WHEN 0 THEN 'Windows and SQL Server Authentication' 
    END AS AuthenticationMode
    ,SERVERPROPERTY('servername') AS ServerName
FROM master.sys.syslogins
WHERE name LIKE 'NT AUTHORITY\SYSTEM'

Post a Comment

0 Comments