Sometimes we need to find which SQL server hosts the XenDesktop 7 database. Try this Powershell command on XenDesktop controller : Get-ConfigDBConnection This will tell you the following details: Server name hosting the DB,Database Name,Security Type Hope this helps