SQL Connection String on a NON-standard TPC/IP Port

  • Thread starter Thread starter Jim Ciotuszynski
  • Start date Start date
J

Jim Ciotuszynski

Anybody know how to connect to a SQL server with a port installed on a port
other than 1433?

Thanks,
Jim
 
Hi Jim,

Try this:
Data Source=IP,PORT;Network Library=DBMSSOCN;Initial Catalog=pubs;User
ID=...;Password=...;"
Where IP is sever's ip and PORT is server's port.
 
Back
Top