Trouble connecting to SQL server

Article Details

URL:	http://www.datapackethelp.net/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=55
Article ID:	55
Created On:	03 Dec 2006 02:21 AM

Answer

With MS SQL databases, while the server IP is always the same, the connection port is different if you are trying to connect remotely (with SQL Management Studio or similar software) or locally (from a script).

When connecting remotely to MS SQL databases, you should use port 1501. In Management Studio, for example, under 'server name', you should enter: 67.19.166.82,1501.

When connecting locally, from a script, you should use port 1433 instead. Example connection strings are available in the Knowledge Base articles on our website. See, for example, the article entitled 'OLE DB Connection Strings':
http://www.datapacket.net/support/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=46&nav=0,3

Note: All databases are SQL Server 2005, not 2000.