Disabled SQL Server Endpoint - now I cannot login
STATE = STOPPED on the [TSQL Default TCP] endpoint prevents the SQL Server service from listening for incoming connections via TCP.  You have several options available that will allow you to reverse this.


Connect with the DAC dedicated admin connection.  You can connect to the DAC by specifying the name of the server as: ADMIN:MyServerName.  Once connected to the DAC, you should be able to start the endpoint again with the following statement:

ALTER ENDPOINT[TSQL Default TCP] state = started;

Use named pipes to connect to SQL server. Use SQL Server
Configuration Manager to enable named pipes if disabled.