sql server dts: "Server 'mysrv' is not configured for DATA ACCESS" -- sql server dts

Re: "Server 'mysrv' is not configured for DATA ACCESS"

Sue Hoegemeier
10/21/2004 9:30:06 AM

Try executing the following:

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

-Sue

On Thu, 21 Oct 2004 08:11:03 -0700, "GaryC"
[quoted text, click to view]

Re: "Server 'mysrv' is not configured for DATA ACCESS"

GaryC
10/21/2004 9:53:05 AM

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.

[quoted text, click to view]

Re: "Server 'mysrv' is not configured for DATA ACCESS"

Sue Hoegemeier
10/21/2004 11:12:13 AM

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"
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.