DTS package fails: [DBNETLIB].....

#1

SQL Server is running on my PC. The server name is 'ASPEN'. When I create
a DTS package to export a local database to our live site, I must use
'LOCAL' for the server name, not 'ASPEN'. Everything runs fine the first
time, but later, when I try to execute, or even view, the local package I
saved, I get the following error:
[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access
denied.

Can anyone explain this?

--
Message posted via http://www.sqlmonster.com

#2

Hi Robin,

Robin Handler via SQLMonster.com wrote:

Quote:

SQL Server is running on my PC. The server name is 'ASPEN'. When I
create a DTS package to export a local database to our live site, I
must use 'LOCAL' for the server name, not 'ASPEN'. Everything runs
fine the first time, but later, when I try to execute, or even view,
the local package I saved, I get the following error:
[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or
access denied.

did you maybe renamed your computer after you installed SQL Server?

Helge

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS package fails: [DBNETLIB].....

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS package fails: [DBNETLIB]..... - 05-19-2005 , 07:46 PM

Re: DTS package fails: [DBNETLIB]..... - 05-20-2005 , 01:33 AM