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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Oracle connection string with IP address 2
Oracle connection string with IP address 1
web.config fileh 1
How to find the SQL Server 2005 port 9
VB app connect THROUGH proxy to a remote SQL database 16
Strange networking problem on higher port numbers 1
what open ports are required by access 2003? 1
after installing XP SP2 SQL Server does not exist or access denied. 1

Back
Top