Some time ago, I changed the machine name of my laptop
running WinXP and SQL Server 2000 (SP3).

Now when using the Query designer in DTS, I get an OLEDB
error: "Server <old-name> is not configured for DATA
ACCESS". After clearing the error, the Query designer
opens. <old-name> is the only server in the list.
Refreshing the list, or typing over <old-name> does not
work.

To create this error:
1) I created a new package
2) Created an connection to "(local)"
3) Created an SQL task
4) Clicked on the "Build Query" button.

Why is DTS not using the connection specified in the SQL
task property page, and how do I get rid of <old-name>?

Did you do

Exec sp_dropserver 'previous name'
Exec sp_addserver 'New name','local'


--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"W Mason" <01066 (AT) nospam (DOT) warrenmason.com> wrote