Monthly Archives: April 2011

SQL Server Service Names

Ver # Common Name Service Display Name Service Name Executable Name SQL Server 7 Distributed Transaction Coordinator Distributed Transaction Coordinator MSDTC msdtc.exe SQL Server MSSQLServer MSSQLServer sqlservr.exe SQL Server Agent SQLServerAgent SQLServerAgent sqlagent.exe SQL Server Analysis Services MSSQLServerOLAPService MSSQLServerOLAPService msmdsrv.exe … Continue reading

Posted in Uncategorized | Leave a comment

Ports used by SQL Server

Service Type Port# Comments SQL Default Instance TCP 1433   SQL Named Instance TCP     SQL DAC TCP 1434 By default, remote connections to the Dedicated Administrator Connection are disabled. Port 1434 for the default instance. Other ports are … Continue reading

Posted in Uncategorized