Sunday, March 11, 2012

An established connection was aborted by the software in your host machine.

I am getting connection errors all over the place, in everything I'm doing related to native client and connection issues failing with my database. I have changed users, authentification from windows to sql, everything. The latest was when I tried to apply the properties of my existing OLE DB Connection editor, one that has been working fine up until today. Every time I try to reselect the database and table in the properties if this, it errors out with the below:

TITLE: Microsoft SQL Native Client

Communication link failure
TCP Provider: An established connection was aborted by the software in your host machine.


BUTTONS:

&Retry
Cancel

Here are my logs:
http://www.photopizzaz.biz/junk/logs.txt
print screens of various errors I have received on my remote SQL Server 2005 (Enterprise version):
http://www.photopizzaz.biz/junk/sqlserver_2005_errors_and_resolutions.doc

Have you checked if remote connections are enabled for your server and what network protocols are available?

Please open SQL Server Surface Area Configuration tool and click 'Surface Area Configuraiton for Services and Connections' to set those settings.

No comments:

Post a Comment