Gift

Not quite what I meant, while I know how to configure linked servers using SSMS what I actually meant was the exact configuration of setting up a linked server to...

Ignore the last post, just found a old Microsoft article (from 2004) so will have a read through this first.

Thanks for your reply.

However I have already tried using Microsoft's DB2OLEDB provider without success. Although this might be down to how I configured the linked server. Do you know of...

The only error present is in the Event Log which states :-

Event Type: Error

Event Source: .NET Runtime 2.0 Error Reporting

Event Category: None

Event ID: 1000

Date: 10/01/2009

Time: 10:20:43

User: N/A

Computer: DWHRSC3

Description:

Faulting application sqlagent90.exe, version 2005.90.3042.0, stamp 45cd6a37, faulting module kernel32.dll, version...

Sorry I should have been clearer earlier and described the setup. We are not using clustering but are using a SAN. The SAN is connected via Fibre to the actual...

I've had the same error twice now, it seems to happen every couple of months. The first time it happened I contacted Microsoft who offered no explanation let alone a...