When I create an SQL task, then try to go into query builder, I get the above
message.

Can any of you kind people offer any suggestions?

Try executing the following:

EXEC master..sp_serveroption 'mysrv', 'data access',' true'

-Sue

On Thu, 21 Oct 2004 08:11:03 -0700, "GaryC"
<GaryC (AT) discussions (DOT) microsoft.com> wrote:

Thanks Sue, unfortunately it did not work.
The message that gets returned is "Server does not exist" I used
sp_helpserver and it lists a server that I am not fimilar with. The server
registers fine and I can access the tables. It's just when I use DTS
connections with the OLE SQL driver I get the subject message.

"Sue Hoegemeier" wrote:

What server is mysrv? Is that the local server? Are you trying to
access an external server?
I am not following what server you are having problems with - if you
run sp_helpserver and it lists a server you aren't familar with - is
that the server you are trying to access? If so, how would you access
a server you aren't familiar with?
Do you have the local server configured for data access?

-Sue

On Thu, 21 Oct 2004 09:53:05 -0700, "GaryC"
<GaryC (AT) discussions (DOT) microsoft.com> wrote: