Safiqul Islam Tuhin (Founder)

SQL SERVER TCP/IP Configuration

FabulousCode February 06, 2023

Enable TCP/IP in SQL Server Configuration
When two or more SQL Servers are connected across network they do all communication using TCP/IP. The default port of SQL Server installation is 1433. This port can be changed through SQL Server Configuration Manager. TCP/IP should be enabled for SQL Server to be connected.
- Go to All Programs >> Microsoft SQL Server 2008 >> Configuration Tools >> SQL Server Configuration Manager >> Select TCP/IP
- Right Click on TCP/IP >> Click on Enable
You must restart SQL Server Services for all the changes to take effect. Right click and go to menu properties to select location where default port of SQL Server can be changed.
Reference Link ::
https://stackoverflow.com/questions/18060667/cannot-connect-to-server-a-network-related-or-instance-specific-error

About Author::
I am a Software Developer, expert in SEO, ASP.NET, MVC, MSSQL, PHP (OPP), PHP (MVC) with MySQL,Java, Android, I have working experience in rapid software design and development of Microsoft and Oracle based desktop, web, Mobile applications and services including SQL Server and Oracle database design and optimization, API development and devices integration. I have strong background and understanding of OOP and MVC Framework, which make my skills more concrete. Combined with a vast knowledge of technologies such as C#, ASP.Net MVC, WCF/ Web API, Entity Framework, SQL, SSRS, SSIS, Crystal Reports, RDLC, AngularJs, Knockout, Bootstrap, Telerik, Ajax, Javascript, JQuery, HTML5, CSS3 , ASP.net Zero and more, I am able to offer Python time-lines using a balance of innovative solutions and tools.
Regards,
Safiqul Islam Tuhin
Founder Fabulous Code