This ticket is raised for availing Tech support from Microsoft for the Following Issue (Had a discussion with Durai VK and instructed to reaise it over here).
Issue :
SQL 2012 Express not allowing to enable TCP/IP with Windows Server 2008 R2
Description:
When SQL 2012 is installed on a Windows Server 2008 R2 machine, and once we enable the TCP\IP protocol, the service cannot be restarted. We have installed SQL 2012 Express on Windows Server 2008 R2 ( with SP1) machine. Installation was completed successfully.
When the TCP/IP is enabled, the SQL service is not getting restarted. It is throwing the following Error.
"Windows could not start the SQL Server (SQLEXPRESS) on Local Computer. For more information, Review the System Event Log. If this is a non-Microsoft Service, contact the service vendor ...
Go to the complete details ...