Connect to SQL Server with Windows Authentication from others Windows desktop

If you want to use your windows credentials to connect to server from your colleagues desktop in process of fixing/debugging a issue.

Try this Steps

• Press SHIFT button 
• Right CLICK on the SQL Server Management Studio button
• Select "Run as different user" and give your windows credential to connect to the server.

Script to find Windows authentication mode/ Mixed authentication mode in SQL Server using TSQL

DECLARE @AuthenticationMode INT

EXEC master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE'
 ,N'Software\Microsoft\MSSQLServer\MSSQLServer'
 ,N'LoginMode'
 ,@AuthenticationMode OUTPUT

SELECT CASE @AuthenticationMode
  WHEN 1
   THEN 'Windows Authentication'
  WHEN 2
   THEN 'Windows and SQL Server Authentication'
  ELSE 'Unknown'
  END AS [Authentication Mode]