FREE 30 DAY TRIAL

Try InfoFlo for free!
The trial is fully functional and offers feature of the product for you to try.
Get your free trial of InfoFlo here.

Contact Info
148 Sheppard Ave West
Toronto, Ontario M2N 1M8
sales@infoflosolutions.com
US: +1 (646) 465-7676
Toll Free: +1 (855) 463-6356
Follow Us
InfoFlo CRM Knowledge Base

Search Knowledge Base by Keyword

How do I enable TCP/IP protocol for use with an existing SQL server installation?

You are here:
< Back

1. Go to control Panel -> Programs and Features, click ‘Telnet Client’ and press OK to install new feature.

2. Go to Start -> All Programs -> Microsoft SQL server 2008 R2 -> Configuration Tools -> SQL Server Configuration Manager.

3. Go to SQL Server Network Configuration -> Protocols for MSSQLSERVER from the left menu, right click on TCP/IP from list on right and select ‘Enable’

4. Click on SQL Server Services from left menu.  Select SQL server from list on right.  right click and select ‘Restart’

5. Click Start menu and type ‘cmd in the command window or open a new shell window in windows.

6. Type command ‘telnet localhost 1433’ (without ‘).  Screen should go blank with a prompt blinking on the top left.

7. Close cmd window