I am using SQL Server 2008 sp1 Developer Edition. The database engine service is running and the SQL browser service is running. It is set to allow remote connections.
When I open SQL Server Configuration Manager and expand the SQL Server Network Configuration mode and select Protocols for <server name>, it shows Shared Memory as Enabled and all others as Disabled.
If I right click on TCP/IP and select Enable, I get a warning stating that the changes will be saved but will not take effect until after I restart the service. When I click OK on the warning popup to close it, it still shows TCP/IP as Disabled.
After I restart the service I return to the Protocols screen and check the value of TCP/IP. It is still Disabled. I am still unable to connect to it remotely.
Configuration Manager is not allowing me to enable TCP/IP. I need to do this. I looked for an alternate way to enable TCP/IP but have not been able to find one that works.
View Complete Post