TIPS

How to connect to a SQL Server using IP and Port

Posted by Mahesh Chand Tips on Apr 26, 2012
Tip: How to connect to a SQL Server using IP and Port

Tip: How to connect to a SQL Server using IP and Port

By default, SQL Server uses port number 1433. To create a connection string over firewall with the IP and port number, use the following format:

<add name="connection" connectionString="Data Source=[YOURIP XX.XX.XX.XX],1433;Network Library=DBMSSOCN;Initial Catalog=[YOURDBNAME];User ID=[YOURUSERID];Password=[YOURPASSWORD]"/>

You need to make sure you provide your valid server IP address, user name and password in the connection string. 

This Feature is Sponsored By Download Free .NET & JAVA Office Files API