RE: Connection Failure

[allyne]

Hi Everyone,

I'm using SQL Server 2000 and have a database (Reporting1)that is linked to another server (Reporting2). The server that Database2 resides on is running very slow and is having many problems. Both Databases are used for Reporting only.

Because of these problems (out of my hands - Third Party) I've been doing a manual data dump to a third database on the linked server once a week for the last few months until these problems get fixed using the DTS Import/Export Wizard. I've never had a problem until this last week. When trying to Import data into the third database I'm getting the following error message.

Error Source: Microsoft OLE DB Provider for SQL Server
Error Description: Connection Failure
Context: Error calling Open Rowset on the provider.

Nothing on my end has changed. Not sure if anything has changed on the third party side. Can you tell me what this message means? It doesn't seem to be any particular table.

Thanks for all your help!

 

[mrdenny]

It means that it wasn't able to connect to the SQL server. This usualy means that there was either a firewall or network problem, or the remote SQL Server was offline.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[allyne]

Hi Denny,

Thanks for the info and pointing me in the right direction. I will talk to our network guys and see whats going on.

Thanks again for your help!