DTS errors out when running on local machine
I have SQL Server 8 installed on my laptop. I've been success in restoring a database that was on a network server until this machine and can view records via Enterprise Manager and Query manager.
However when I attempt to launch DTS to import some data (either from scratch or restoring a DTS package from a network server) I get a cryptic error message (see below).
Error Source: Microsoft OLE DB Provider for SQL Server
Error Description: [DBNETLIB][Connection Open(Connect()).] SQL Server does not exist or access denied.
Context: Error during initialization of the provider.
The error message appears when I click on the drop down to choose which database I want to import data into.
Any help here would be greatly appreciative.
|