Trouble connecting to SQL server - Powered By Kayako SupportSuite

30 Jul 2010

Support Center » Knowledgebase » Trouble connecting to SQL server

	Trouble connecting to SQL server

Solution 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.

Article Details

Article ID:

Created On:

03 Dec 2006 02:21 AM