Windows Support Manual

Configuring SQL Enterprise Manager to Use TCP/IP

Click on the start button, Microsoft SQL Server, and Client Network Utility.

 

Next, highlight TCP/IP if it is in the left column. Click on the Enable button. If TCP/IP is in the right column, skip this step.

 

Then, highlight TCP/IP. Hit the up arrow until TCP/IP is at the top of the list.

 

When TCP/IP is on the top, hit "OK". You are done and ready to connect to your SQL database via the Enterprise Manager.