Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2004
    Posts
    5

    Unanswered: DTS error not configured for data access

    I just had to rebuild master and msdb in Sql 2000. Now any DTS package accessing that machine fails with the message 'Server __ is not configured for DATA ACCESS.' The message seems to be coming from OLE. Everything else, including applications, scheduled jobs, etc. seems to work fine.

    How can I restore data access?

  2. #2
    Join Date
    Aug 2003
    Location
    Andover, MA
    Posts
    256
    You may need to allow other SQL servers to connect. In enterprise manager, right-click on the server and select properties. On the Connections tab, check the box in the Remote Servers frame "Allow other SQL Servers to connect remotely to this SQL Server using RPC".
    -bpd

  3. #3
    Join Date
    Feb 2004
    Posts
    5
    No good. Properties showed remote connection OK. I unchecked, rechecked and rebooted to make sure. same problem.

  4. #4
    Join Date
    Aug 2003
    Location
    Andover, MA
    Posts
    256
    Can you create a connection to the server in a new DTS package?

    It may be that you have to recreate the Server Connections in the existing package(s).
    -bpd

  5. #5
    Join Date
    Feb 2004
    Posts
    5
    No. Fails for both new and existing packages. The rebuild was apparently caused by converting databases from another machine from Sql 6.5. After the conversion we saw some odd things showing in msdb and lost alerts, operators etc. I also saw some table structure changes. Even though we didn't include msdb it looked like stuff from 6.5's was showing up. This looks to be a repercussion related to that.

    Waht I can't seem to find anywhere is any discussion of the error. DTS's error window says the source is OLE but gives no eror number

  6. #6
    Join Date
    Feb 2004
    Posts
    5
    Just to add to the fun, I ignored the error message and built the queries without the point & click junk. Package ran fine. So it looks like all I've lost the visual references to that server.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •