I'm creating a DTS package to export the contents of a
table to a text file. Everything works fine until I try
and change the source of the Data Transform task from
Table/View to SQL query. When I click Build Query, I
receive the following error:

---------------------------
Package Error
---------------------------
Error Source : Microsoft OLE DB Provider for SQL Server

Error Description : Server '<Server Name>' is not
configured for DATA ACCESS.

Any Ideas? The server is pretty up to date Win2k sp3 &
SQL 2K sp3, MDAC 2.71.9030.

In article <055f01c3be9e$48ed7e60$a101280a (AT) phx (DOT) gbl>, Lonnie Marshall
<Lonnie_Marshall (AT) Excite (DOT) com> writes
You could have a look at sp_serveroption in Books Online, this allows
you to turn on data access, e.g.-

EXEC sp_serveroption 'server','data access',true

I would run a quick query on sysservers, and see if the local server is
there, and also the local server. The column isremote =1.

If not you have renamed the machine but not told SQL Server. To sort
this try-

EXEC sp_dropserver 'oldservername'
GO

EXEC sp_addserver 'newservername', 'local'

See sp_addserver for more info on the local option.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Hey Darren,

Thanks alot. The "sp_serveroption" worked like a charm.

- Lonnie