Tag Archives: Authentication Mode

Script to get the SQL Server Installation Date and Authentication Mode

Recently I got a request where I have to check the SQL Server installation date and SQL Server authentication mode. I have write the below script and execute it against all the servers registered in CMS.

Here is the script

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 svrName 
from master..syslogins where name like 'NT AUTHORITY\SYSTEM'