I have a remote server connected to a DB I'm using and it apears to be an historical artefact, the database that any call would use does not exist there. My problem is that this Server is screwing up my efforts to amend existing DTSs, in that when I attempt to check parameters and build queries, I get a message that says the remote server has generated an error, either because it isn't set up for data access or the database entities don't exist there. I deleted the server in the security section using enterprise manager, but that then just generated another error saying that a system sproc couldn't add or load the remote server. I cannot seem to find anything that tells me how the remote server can interfere with my connections which make no reference to it, nor can I find anything that tells me how to safely get rid of the damn thing, can anyone help?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.