Microsoft SQL server 2016
Is there someone inside the database?
Run this SQL script to see who have logged in to the database:
select @@servername as [ServerName], getdate() as RunTime, spid, DB_NAME(dbid) as DatabaseName, login_time, last_batch, hostname, program_name, nt_domain, nt_username, loginame From master..sysprocesses
To get more information, like kerberos, run this SQL script:
select c.auth_scheme,* from sys.dm_exec_sessions s join sys.dm_exec_connections c on s.session_id=c.session_id where s.host_name ='servername'
To see active connections:
EXEC sp_who2 'active';