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:
print screens of various errors I have received on my remote SQL Server 2005 (Enterprise version):
http:
An established connection was aborted by the software in your host machine.
Mary S
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.