SQL 2000 DTS pkg execution error

[Rob]

Hi,

One of our developers, connecting to SQL through standard security, had
copied and modifed a DTS package but is unable to execute it.

The package is owned by another user. And the login account that the
developer uses to log into SQL has full DBO permission on the intended DBs.

The error msg he has received suggests that SQL Server does not exists.

Me, on the other hand, with full SA permissions, I'm able to successfully
execute this pkg.

Please advice. Thanks.

[tbradshaw via SQLMonster.com]

Hello Rob,

What is the exact error your developer is getting? Perhaps you need to map
an entry to the DB using Client Network Utility (SQL 2000) or SQL Server
Configuration Manager (2005 & above).

Let us know how you make out.

Best Regards,
Tom

Thomas Bradshaw
MyWebGrocer LLC
Data Integration Services

Post by Rob
Hi,
One of our developers, connecting to SQL through standard security, had
copied and modifed a DTS package but is unable to execute it.
The package is owned by another user. And the login account that the
developer uses to log into SQL has full DBO permission on the intended DBs.
The error msg he has received suggests that SQL Server does not exists.
Me, on the other hand, with full SA permissions, I'm able to successfully
execute this pkg.
Please advice. Thanks.