Enable TCP/IP and Named Pipes then connect SQL Server Management Studio

1. Select SQL Server Services then right-click SQL Server Browser and select Properties.
2. Switch to the Service tab then set the Start Mode to Automatic. Click OK.
3. Right-click SQL Server Browser then select Start.
4. From the left pane, select SQL Server Network Configuration > Protocols for SQLEXPRESS.
5. Right-click TCP/IP then click Enable. Click OK. Repeat this step to also enable Named Pipes.
6. From the left pane, select SQL Server Services then right-click SQL Server (SQLEXPRESS) and select Restart.
7. Select Start > All Programs > Microsoft SQL Server 2008 R2 > SQL Server Management Studio. Note: I may be necessary to run SSMS using the Run as administrator option in the right-click menu. If so, type the administrator password then click Yes.
8. In the Connect to Server window, type the details for your server connection. Note: The Server name will likely need to be in the format ComputerName\InstanceName. For example, my computer name is Zeus and my SQL Server instance name is SQLEXPRESS. As a result, my Server name is set to Zeus\SQLEXPRESS.
9. Once you have made the necessary changes, click Connect.